(Terry Purcell) When requiring multiple counts you can choose to write multiple SQL statements (or write a program) such as: SELECT COUNT(*) AS UNDER_40K WHERE SALARY < 40000 AND SELECT COUNT(*) AS ABOVE_40K WHERE SALARY >= 40000 Or you can choose to simulate these multiple counts in
Read More - Register for Free Membership