Question: SQL commands needed runTime, movie (id, title, relYear, category, director, studioName, description, rating) actor (aID, fName, surname, gender) stars (movieID, actorID) movGenre (movieID, genre) (d)

SQL commands needed

SQL commands needed runTime, movie (id, title, relYear, category, director, studioName, description, rating) actor (aID, fName, surname, gender) stars (movieID, actorID) movGenre (movieID, genre)

runTime, movie (id, title, relYear, category, director, studioName, description, rating) actor (aID, fName, surname, gender) stars (movieID, actorID) movGenre (movieID, genre) (d) Using a subquery method list the title and category of movies that star the actor Michael Fassbender'. (5) (e) Find the movie(s) (listing the title and rating) with the highest rating. (5) (1) Using the implicit join syntax, list the title and release year of all movies which were directed by Angelina Jolie or which star Angelina Jolie as an actor. (5) (g) For each genre, list the genre and the number of movies in the database, released since 2000, for that genre. (5) (h) List the names of actors who have starred in more than 10 movies. (5) PTO

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 Databases Questions!

Using Apex Oracle on website to do database please help me Vendor VendorID 100 200 VName Titan ABC Manufacturers Sales_Order Order ID 200 201 202 203 Order Date 2018-01-11 2017-10-21 2016-05-04...

Use the following tables to answer the questions: WRITE OUT THE SQL COMMANDS NEEDED TO LIST OR RETRIEVE THE BELOW INFORMATION (use SELECT, FROM, WHERE, JOIN, ON, etc) - write the full SQL commands 7....

Could really use some help, haven't received response to my questions. Assignment 5: Database Refactoring Task Consider the following database relations Order and Orderltem, 1. name the refactoring...

Assignment 5: Database Refactoring Task Consider the following database relations Order and Orderltem, 1. name the refactoring pattern(s) you use. 2. list every step in the order of changing from the...

Database refactoring question that i need assistance on. Assignment 5: Database Refactoring Task Consider the following database relations Order and Orderltem, 1. name the refactoring pattern(s) you...

data base PART B - Basic SQL to understand Constraints Ques 1. (a) Write the SQL statements (SQL Workshop SQL Commands) needed to create the following relations using all required and mentioned...

In each of the following queries, use SQL to obtain the desired results using the data shown in the Colonial Adventure Tour Database listing found on the homepage under the databases heading. Also,...

4 Personal Assistants are programmes which respond to user utterances (spoken or typed commands). For example, they can be used to provide helpful answers to a users question about products on a...

Why do you think the empirical studies about factors affecting equity returns basically showed that domestic factors were more important than international factors, and, secondly, that industrial...

Ace-It Financial Calculators Ltd. has the following capital structure: Bonds ................ $40,000,000 at face (par) value Preferred ............... 5,000,000 Common stock ........... 15,000,000...

On January 1 , 2 0 2 5 , Cullumber Company acquires \ ( \ $ 1 2 0 , 0 0 0 \ ) of Spiderman Products, Inc., \ ( 9 \ % \ ) bonds at a price of \ ( \ $ 1 1 4 , 1 3 5 \ ) . Interest is received on...

Dept. A's beginning work in process for materials cost totaled $15,000. Current material costs for the month equal $90,000 and there are 5,000 equivalent units. Material cost per equivalent units...

7. There is sufficient time for conducting an evaluation. Here, information regarding training effectiveness is not needed immediately.

8. There is interest in measuring change (in knowledge, behavior, skill, etc.) from pretraining levels or in comparing two or more different programs.

6. The cost of the training creates a need to show that it works.