Question: Write an SQL query to count how many units each tut0r teaches. In your result-set, include the tut0rs staffID, firstname, surname and the number of
Write an SQL query to count how many units each tut0r teaches. In your result-set, include the tut0rs staffID, firstname, surname and the number of units they teach. Must be compatible with SQL 5.7.
Please provide a detailed explanation of the answer / how you came up with it.
Table names / fields below:

Student (studentID, firstName, surname, email, streetNo, streetName, suburb, city, postcode, state watchType, watchSerialtf, buddylD) PhoneNumber (phoneNumber, studentID) Unit (unitID, unitName, unitCode, semester, year) Enrolments (unitlD studentID) UnitTutor (stafflD, unitID) Assignment (assignmentID, assignmentName, dueDate) Grade Tutor (staffID, firstName, surname, email) SleepPatterns (sleepID, studentID, date, timeAsleep, timeAwake) anmentlD, grade) FOREIGN KEYS Enrolment (studentlD) is dependent on Student (studentlD) Enrolment (unitlD) is dependent on Unit (unitID) Enrolment (stafflD) is dependent on Tutor (stafflD) StudentSleepPatterns (studentID) is dependent on Student (studentlD). StudentSleepPatterns (sleepPatternID) is dependent on SleepPatterns (sleepPatternlD) StudentAssignment (student ID) is dependent on Student (studentID) StudentAssignment (assignmentlD) is dependent on Assignment (assignmentlD) PhoneNumber (studentlD) is dependent on Student (studentlD) OTHER CONSTRAINTS Student (state) domain is [QLD, SA, TAS, NSW, WA, NT or ACT SmartWatch (type) domain is [FitBit, Suunto, Apple Watch or Samsung Gear] Students may have up to three phone numbers
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
