Write the SQL code for the following: Count the number of reservations for 1/3/2021 and display that
Question:
Write the SQL code for the following: Count the number of reservations for 1/3/2021 and display that number with a CountOfReservationID column heading.
a. SELECT COUNT(ReservationID) AS CountOfReservationID FROM Reservations WHERE ClassDate=#1/3/2021#;
b. SELECT CountOfReservationID FROM Reservations WHERE ClassDate=#1/3/2021#;
c. SELECT COUNT AS CountOfReservationID FROM Reservations WHERE ClassDate=#1/3/2021#;
d. SELECT COUNT OF ReservationID AS CountOfReservationID FROM Reservations WHERE ClassDate=#1/3/2021#;
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answered By
Hillary Waliaulah
As a tutor, I am that experienced with over 5 years. With this, I am capable of handling a variety of subjects.
17+ Reviews
30+ Question Solved
Related Book For 
Concepts Of Database Management
ISBN: 9780357422083
10th Edition
Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt
Question Posted:
