SELECT Statement - Edubirdie

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

2024
Views:

283

Pages:

6
Author:

Riley K.

SELECT Statement New Attempt Due Out 25 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 resuits. 1. Write a SQL query that returns all rows from actor table if last name starts with CR (e.g. CRUISE). 2. Write a SQL query that returns all rows from address table if postal code is 35200 or 17886. 3. Write a SQL query that returns all information of G rated films from film table which were released in 2006 and cost in between $1.5 and $3 to rent. 4. Write a SQL query that returns store id and count of active customers per store from customer table. 5. Write a SQL query that displays postal code and count of addresses for that postal code from address table if count is more than 1.

Related Documents

SELECT Statement

SELECT Statement - Page 1

SELECT Statement - Page 2

SELECT Statement - Page 3

SELECT Statement - Page 4

SELECT Statement - Page 5

SELECT Statement - Page 6

of 6

Recommended Documents

Quiz 1 - Introduction to Database Systems

Quiz 1 - Introduction to Database Systems

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 3 - The Relational Database Model

Quiz 3 - The Relational Database Model

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 5 - Advanced Data Modeling

Quiz 5 - Advanced Data Modeling

California State University, Northridge COMP 440 | Database Design

Answer Key

Quiz 10 - Database Performance Tuning and Query Optimization

Quiz 10 - Database Performance Tuning and Query Optimization

California State University, Northridge COMP 440 | Database Design

Answer Key

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

Answer Key

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

Answer Key