Question: For this assignment we will focus on the table Movies. IV. Answer the following questions in the comments of your code. 1. (5 pts) How

For this assignment we will focus on the table Movies. IV. Answer the following questions in the comments of your code. 1. (5 pts) How many rows are there in the table? 2. (5 pts) How many distinct movies are in the table? 3. (5 pts) How many movies released in 1996 are in the table? 4. (5 pts) How many movies released between 2000 and 2002 (including) are in the table? 5. (5 pts) List the movies (list the titles not the count) that start with Harry. 6. (10 pts) Create a new table called Movies1. This new table should have all the information that table Movies has plus 1 additional column. This additional column should say funny if a movie is listed as Comedy, or scary if the movie is either Thriller or Horror. Leave it as NULL if the movie is neither. 7. (5 pts) Use group by to count how many scary or funny movies are in table Movies1. 8. (10 pts) What happened to the movies that are both Comedy and Horror or Comedy and Thriller? Think about why theyre marked as only funny or scary in table Movies1. Create another table Movies2 that is like Movies1, but it has scary and funny for movies that are listed as both Comedy and Horror or Thriller.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!