Question: Write a query to display how many people are in each class (put o for classes without students). - Use a LEFT or RIGHT join
Write a query to display how many people are in each class (put o for classes without students). - Use a LEFT or RIGHT join with a subquery - Use IFNULL to assign o to classes without students - See: https://www.w3schools.com/sql/sql isnull.asp 111 - SELECT * FROM students 3 Edit: \[ \begin{array}{l} 85 \text { - SELECT * FROM registered_students; } \\ 86 \end{array} \]
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock