Kickstart 2020 with new opportunities! - hours only!Up to 80% off on all courses and bundles.-Close
8. Views based on views


Perfect! As we already mentioned, views work just like tables. This means we can create a view which will be based on another view. Let's try that out.


Create a view current_course_lecturer which will show the name and description of all current courses with the first and last name of their lecturers. Use the view current_course and the ERD below to help you.

Tables in the database

Stuck? Here's a hint!


CREATE VIEW current_course_lecturer AS 
SELECT name, description, first_name, last_name FROM current_course JOIN lecturer ON current_course.lecturer_id =;