Question
Please use the sakila database. You may choose necessary fields to display (in addition to those indicated) and sort the data as you deem appropriate.
Please use the sakila database. You may choose necessary fields to display (in addition to those indicated) and sort the data as you deem appropriate. You may find the entity-relationship diagram listing the tables with various fields and relationships among tables useful in thinking through the queries. Each of these queries should take no more than 10 minutes to formulate. Feel free to contact me if you need any assistance. It may be convenient to write the query on paper and then try it on the MySql database. One or more of the queries may not return any records because there may not records that match all the conditions. You should also learn how to export the results of MySQL query to a html file and copy paste it if required.
Display the names of staff members who work in store #1. Sort the results in alphabetical order of staff member names.
Display payment details such as payment date and payment amount for the customer DOROTHY TAYLOR. Sort the results by payment date.
Display the names of actors in the film EASY GLADIATOR. Sort the results in alphabetical order of actor names.
Display the first name, last name, email, address (lines 1 and 2), city name, postal code, country name, phone for the customers with the last name LEE.
Display the names and emails of customers who rented the movie SIDE ARK. Sort the results in alphabetical order of customer names.
Create two queries of your own that answers interesting business questions that may help in decision making. These queries should use more than one table and must be different from the ones we have seen in class or assignments.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started