How can I get this query:
For each month (use dateofappointme nt) of 2010, show a count of appointments. Also show the count of diagnosed diseases, and a count of patients seen during the month.
I'm trying this query but it doesn't work , because I got same number for each count
Code:
SELECT COUNT(APPOINTMENT.APPOINTMENTID), COUNT(PATIENT.PATIENTID), COUNT(DIAGNOSED.DISEASEID) FROM APPOINTMENT ,