List the films title and films release year

Assignment Help Computer Engineering

Reference no: EM132171728

Using MySQL and sakila table, definitions, and download found here:

1. Using the Sakila schema, produce two queries that identify the films each actor has been in. List the film's title, film's release year, and actor's last name Use implicit inner join syntax across three tables in the first query. Use two explicit inner join syntax in the second query.

Expected Result Set Size: 5462

2. Using the Sakila schema, select the rental_date and customer_id of the first rental made by each customer.

Expected Result Set Size: 599

3. Using the Sakila schema, return the number of rentals that were made between June 15, 2005 and June 18, 2005. Do not use the string comparison operation ‘like' to compare dates. Hint: between

Expect count of 997

4. Using the Sakila schema, return the customer ID, first name, last name, and email of customers that have not returned their rentals Eliminate duplicate customers from the result set. Note the use of joins or nested selects is allowed in this question.

Expected Result Set Size: 159.

Reference no: EM132171728

Questions Cloud

Find the profit in dollars from the sale : Find the profit in dollars from the sale of the x expensive watches is P(x)=0.03x2-3x+7x0.5-5200.

Create a polynomial expression for the volume v : Create a polynomial expression for the volume V in terms ofx. Make a plot of V versus x.

What is the expected npv for project : What is the expected NPV for this project? What is the probability of this project generating a positive NPV for the company?

Normal distribution with a standard deviation : A survey reported that the mean starting salary for college graduates after a three year program was $35,000.

List the films title and films release year : List the film's title, film's release year, and actor's last name Use implicit inner join syntax across three tables in the first query.

What is the probability that a college student expresses : The relative frequency distribution of the number of phobias reported by a hypothetical sample of 500 college students is given as follows.

Distribution of the number of phobias : The relative frequency distribution of the number of phobias reported by a hypothetical sample of 500 college students is given as follows.

Create a sum called s2 that adds up all the terms : Program a FOR loop for the index i varying from 2 to n to create a sum called s1 that adds up all the terms in the form of 1/i^d.

What proportion of the population is less : A normal population has a mean of 11.2 and a standard deviation of 3.4. a). Compute the Z associated with 14.3

User Account

All Pages