Question: Using SQL , count how many classes each customer has signed up for. Show the customer's last name, first name, and number of classes. Use

Using SQL, count how many classes each customer has signed up for. Show the customer's last name, first name, and number of classes. Use an appropriate JOIN.
a. SELECT LastName, FirstName, Count(ReservationID) AS [Number of Classes]
FROM Customers INNER JOIN Reservations ON CustomerID = CustomerID
GROUP BY LastName, FirstName;
b. SELECT LastName, FirstName, Count(ReservationID) AS [Number of Classes]
FROM Customers INNER JOIN Reservations ON Customers.CustomerID = Reservations.
CustomerID
GROUP BY LastName, FirstName;
c. SELECT LastName, FirstName, Count(ReservationID) AS [Number of Classes]
FROM Customers INNER JOIN Reservations ON Customers.CustomerID = Reservations.
CustomerID;
d. SELECT LastName, FirstName, Count(ReservationID) AS [Number of Classes]
FROM Customers OUTER JOIN Reservations ON Customers.CustomerID = Reservations.
CustomerID
GROUP BY LastName, FirstName;

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 Programming Questions!