Question

Write and run the SQL to list the different expected graduation dates [class of 20XX] in the BSU_Students table. List each expected graduation date only once.  

Answer 1

Answer

SQL code

SELECT Distinct Stuexpectedgraddate

FROM BSU_Students;

Explanation

Output

---

am not able to find original database

i created sample one for the purpose of explanation

all the best

1 2 CREATE TABLE BSU_Students(Id integer PRIMARY KEY, Stuexpectedgraddate date); | min 6 7 INSERT INTO BSU_Students VALUES (101, '15-5-2021'); INSERT INTO BSU_Students VALUES (102, '15-5-2021'); INSERT INTO BSU_Students VALUES (103, '15-5-2022'); INSERT INTO BSU_Students VALUES (184, '15-5-2023'); INSERT INTO BSU_Students VALUES (105, '15-5-2023'); 8 9 10 11 12 SELECT Distinct Stuexpectedgraddate From BSU_Students;