Shell Programming and Scripting

hi, iam completely new to scripting. this may sound naive but i have spend lot of time figuring this out.

i want to make a script to find number of sql processes running. If the number of processes are more then 200, then pick out process IDs along with query it is executing, which are running from more then 60 seconds and kill them.

this is what I have tried but I am stuck at getting to read the value of count(*).

Code:

for TOTAL in $( mysql -uusername -ppassword information_schema -e "SELECT count(*) as TOTAL FROM processlist")
do
  echo -n "${TOTAL}"

if
[${TOTAL}>=200]

then
for ID in $( mysql -uusername -ppassword information_schema -e "SELECT ID FROM processlist where Info REGEXP 'insert into' AND Command='Query' AND State!='query end' AND TIME >= 60" )


do
  echo -n "Killing thread ${ID}..."
  mysqladmin kill ${ID}
  echo " Done"

done

Please help, I have spend a lot of hours but all in vain..