subject

Using sakila database, answer the following questions with sql queries and/or subqueries:

1. display the title of the film with the largest number of actors.
2. using "having" to display which customer’s first names have appeared more than once?
3. query the top 5 customer’s names who spent the most on rental films. display customer id, name and the amount spent.
4. what’s the result of this query? and why? select * from film natural join inventory;
5. write an interesting query statement of your own, not shown in the questions. the query should include at least one natural join operator, having clause and aggregation operation. explain your query statement and the answer.

ansver
Answers: 1

Other questions on the subject: Computers and Technology

image
Computers and Technology, 23.06.2019 06:00, 573589
What machine listens for http requests to come in to a website’s domain? a. a router b. a browser c. a server d. a uniform resource locator
Answers: 1
image
Computers and Technology, 23.06.2019 11:00, shawn20034
This chapter lists many ways in which becoming computer literate is beneficial. think about what your life will be like once you’re started in your career. what areas of computing will be most important for you to understand? how would an understanding of computer hardware and software you in working from home, working with groups in other countries and contributing your talents.
Answers: 1
image
Computers and Technology, 24.06.2019 08:00, qveenvslayin
How can smart devices benefit businesses, organizations, and social communities in the global marketplace?
Answers: 1
image
Computers and Technology, 24.06.2019 11:20, isabelperez063
Every telecommunication setup uses two devices: one device to transmit data and one device to receive data. which device transmits frequencies to mobile phones? towers transmit frequencies to mobile phones.
Answers: 1