Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*Task 5*/
- SELECT DISTINCT tc.id_teacher, tc.name, tc.surname
- FROM courses cs
- INNER JOIN exams ex
- ON cs.id_course = ex.id_course
- INNER JOIN teachers tc
- ON tc.id_teacher = ex.id_teacher
- WHERE LOWER(course_name) = 'data warehouses'
- ORDER BY 3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement