SQL View Questions

The actual database images below:

https://imgur.com/a/lOBwraF?fbclid=IwAR3miKWbIcmWO2z_v8FwAf7iRu_r3r-doNwteUp6_wR2Er0GAnZoBhc7aCI

1. Create a view that will display all of the following columns, joining tables (you built in Lab 7 & 8) as appropriate: Provide a screenshot of script execution.

Student First Name

Student Last Name

Course Title

2. Select all data from the view. Provide a screenshot of all data[1].

3. Create a view that will display all of the following columns, joining tables (you built in Lab 7 & 8) as appropriate: Provide a screenshot of script execution.

Student First Name

Student Last Name

Course Title

Course Faculty First Name

Course Faculty Last Name

Final Grade (number)

4. Select all data from the 2^nd view. Provide a screenshot¹.

5. Select data from the 2^nd view, for Harrys classes only. Provide a screenshot¹.