SELECT Statement (JOINS & Subqueries) - Edubirdie

University:
California State University, Northridge
Course:
COMP 440 | Database Design
Academic year:

2024
Views:

231

Pages:

5
Author:

Riley K.

SELECT Statement (JOINS & Subqueries) + New Attempt Due Nov 1 by 11:59pm Points 20 Submitting a file upload File Types pdf All of the following queries should be written for Sakila database Your submission should include the screen shots of MySQL Workbench showing query as well as the results. 1) Write a SQL query that will display the first name, last name and total morncy spent by a customer in the range of $50 to $60 during the month of august 2005 in descending order of total money spent. 2) Write a SQL query that display the title & count of top 5 movies rented most often. 3) Write a SQL query that will display the actor id, first name and last name of the actor with highest number of movies. 4) Write an SQL query that will display the film category name, language and count of films for each category and language in descending order.

Related Documents

SELECT Statement (JOINS & Subqueries)

SELECT Statement (JOINS & Subqueries) - Page 1

SELECT Statement (JOINS & Subqueries) - Page 2

SELECT Statement (JOINS & Subqueries) - Page 3

SELECT Statement (JOINS & Subqueries) - Page 4

SELECT Statement (JOINS & Subqueries) - Page 5

of 5

Recommended Documents

Quiz 1 - Introduction to Database Systems

Quiz 1 - Introduction to Database Systems

California State University, Northridge COMP 440 | Database Design

Quiz 3 - The Relational Database Model

Quiz 3 - The Relational Database Model

California State University, Northridge COMP 440 | Database Design

Quiz 5 - Advanced Data Modeling

Quiz 5 - Advanced Data Modeling

California State University, Northridge COMP 440 | Database Design

Quiz 10 - Database Performance Tuning and Query Optimization

Quiz 10 - Database Performance Tuning and Query Optimization

California State University, Northridge COMP 440 | Database Design

CREATE TABLE & INSERT statement (Problems 8.16-8.19)

CREATE TABLE & INSERT statement (Problems 8.16-8.19)

California State University, Northridge COMP 440 | Database Design

Assignment

CREATE TRIGGER & PROCEDURE statement (8.26-8.30)

CREATE TRIGGER & PROCEDURE statement (8.26-8.30)

California State University, Northridge COMP 440 | Database Design

Assignment

Query optimization (Problems 11.11-11.14)

Query optimization (Problems 11.11-11.14)

California State University, Northridge COMP 440 | Database Design

Assignment

Quiz 8 - Advanced SQL

Quiz 8 - Advanced SQL

California State University, Northridge COMP 440 | Database Design

Normalize Table (Problem 6.5)

Normalize Table (Problem 6.5)

California State University, Northridge COMP 440 | Database Design

Assignment

Transaction management (Problem 10.1)

Transaction management (Problem 10.1)

California State University, Northridge COMP 440 | Database Design

Assignment

Create ERD (Problem 5.3)

Create ERD (Problem 5.3)

California State University, Northridge COMP 440 | Database Design

Assignment

Quiz 7 - Introduction to SQL

Quiz 7 - Introduction to SQL

California State University, Northridge COMP 440 | Database Design