View for Course Information | Challenge

# Introduction In this challenge, we will define views in a MySQL database to display specific course information. Given a database of a university institution, the task is to define two views: `comp_spring_2018` which displays the `course_id`, `building`, and `room_number` of all courses offered by the "Comp. Sci." department in the spring semester of 2018, and `comp_spring_2018_taylor` which uses the `comp_spring_2018` view and displays the `course_id` and `room_number` of all courses offered by the "Comp. Sci." department in the spring semester of 2018 and located in the "Taylor" building.

|60 : 00

Click the virtual machine below to start practicing