Advertisement
Guest User

Untitled

a guest
Dec 11th, 2019
112
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. /*Task 5*/
  2. SELECT DISTINCT tc.id_teacher, tc.name, tc.surname
  3. FROM courses cs
  4. INNER JOIN exams ex
  5. ON cs.id_course = ex.id_course
  6. INNER JOIN teachers tc
  7. ON tc.id_teacher = ex.id_teacher
  8. WHERE LOWER(course_name) = 'data warehouses'
  9. ORDER BY 3;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement