SKE Queries 01

SELECT a.stateid,b.name, count(*) FROM orders a, states b WHERE a.stateid=b.id and traderuserid IN ( SELECT id FROM users WHERE loginname = 'kumarsea') and active =1 GROUP BY b.name , a.stateid order by a.stateid;