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:

Write an SQL query to count how many units each tut0r teaches.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!