Im quite new to the use of sql, and i have this problem right now:
I have two tables:
Schools
Students
Each row in the students table has a "school_code" field that corresponds with a code of one school in the Schools tables.
I have to count how many students are there in each school: Basically, i should do a new query with the entire table "Schools" and add one more field with the number of students in each school......
Can anyone tell me how can i do this? For me is quite difficult to guess it right now, and i have a bit of an urgency with this.
thanks!