Write the SQL code for the following: List the session dates and numbers for those sessions scheduled

Question:

Write the SQL code for the following: List the session dates and numbers for those sessions scheduled between 10/18/2021 and 10/20/2021.

a. SELECT SessionDate, SessionNum FROM Session WHERE SessionDate BETWEEN #10/18/2021# AND #10/20/2021#;

b. SELECT SessionDate, SessionNum FROM Session WHERE SessionDate BETWEEN '10/18/2021' AND '10/20/2021';

c. SELECT SessionDate, SessionNum WHERE SessionDate BETWEEN #10/18/2021# AND #10/20/2021#;

d. SELECT SessionDate, SessionNum FROM Session WHERE SessionDate #10/18/2021# >< #10/20/2021#;

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Concepts Of Database Management

ISBN: 9780357422083

10th Edition

Authors: Lisa Friedrichsen, Lisa Ruffolo, Ellen Monk, Joy L. Starks, Philip J. Pratt

Question Posted: