dblabs/m.sql
2024-01-25 21:55:48 +01:00

6 lines
No EOL
182 B
SQL

--Which students have taken 0 credits? [16]
select firstName, lastName
from Students
left join TakenCourses on Students.pNbr = TakenCourses.pNbr
where TakenCourses.pNbr is null