WebApps: SQL HW #3

All Homework Must be Uploaded to it own GitHub repository. You will copy the URL Link for your GitHub Repository and Submit that link for each of your homework assignments

Homework #1

Given the skills and queries we covered today, answer the following 10 questions.

Once completed create/save the queries (SQL Code) in a .sql file using DBeaver and commit the file to github. After which you will need to submit the GitHub link to the assignment.

ANSWERS:
Use SQL to find these answers. Some of the questions are slightly ambiguous so the intended outputs are included below. Also as you do the problems please number the problems to make grading easier.
Please use DBeaver for your queries.
1. 2
2. 5567
3. Film 200 with 9 
4. 0
5. 1 – 8040
6. 378
7. film_id 508 – 15 actors
8. 13
9. 3
10. 5 ratings, PG-13 has the most

Homework Questions

Click To Download SQL Homework #3 Questions

Lecture Files:

Click to Download Joins/Presidents SQL File

Click to Download Subqueries and Multijoin SQL File

Useful Resources:

https://www.lucidchart.com/

Curated Video Help:

Image Resources:

Note: You can right click images and press ‘save image as’ to save the image to your computer.

Skip to content