https://www.jooq.org/img/sakila.png

Type the command use sakila; to change to the database

Tasks

Query Description	Query Statement
Find the unique identification, first name, and last name of all staff members. Result set should look like:
Find all the film ratings and remove duplicates. Result set should look like:
Find all the film ratings, do not remove duplicates. Result set should look like: Depending upon which table you use you may also receive
Find all data about the stores. Result set should look like:
Select the literal value Haka as an attribute without a from clause. Result set should look like:
Select the literal value Haka as an attribute giving the column name parrot without a from clause. Result set should look like:
Select the literal value Haka as an attribute with the from clause table store. Result set should look like:
Find the film category and average sales for each category between the two stores. Result set should look like:
Find the film category and average sales for each category between the two stores, rename the average as store_average. Result set should look like:
Find the unique identifier for country United States. Result set should look like:
Find the film name and description where rating is G and the length is less than 50 minutes. Result set should look like:
Generate the Cartesian product based on tables staff_list and store. Result should look like:

Find the name, city, and country of the staff who manage the two stores. Result set should look like:
Find film titles where the title starts with wo. Result set should look like:
Find film titles that are only eight characters long. Result set should look like:
List in alphabetical order film titles that start with z. Result set should look like:
List in descending alphabetical order film titles that start with z. Result set should look like:
Find payment amounts between the values of 8 and 12 with duplicates removed. Result set should look like:
Using an aggregate function, find the average amount paid for film rentals. Result set should look like:
Using an aggregate function, find the average amount paid for film rentals for each store manager. Result set should look like:
Using an aggregate function, find the total amount paid for film rentals for each store manager. Result set should look like: