In: Computer Science
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
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;