Practice Set 1
Explore practical SQL query writing using the MovieIndustry database. Learn to retrieve top movie box office results, identify actors with shared last names, count actors by last name, list actors involved in movies, and find actors without movie roles to strengthen your data analysis skills.
We'll cover the following...
We'll cover the following...
Practice Set 1
We’ll build upon the MovieIndustry database we have been working with throughout the lesson. We’ll add two more tables for a total of four. The relations between the tables are pictorially depicted below.
Connect to the terminal below by clicking in the widget. Once connected, the command line prompt will show up. Enter or copy and paste the command ./DataJek/Lessons/quiz.sh and wait for the MySQL prompt to start-up. ...