Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Managers Income
Task
Swipe to start coding
Now, can you output the managers who earned the biggest amount of money? Count the total sales from cinemas for each manager and present a rating of top-3 the richest managers. Print the data under columns full_name
and income
.
Solution
Everything was clear?
Thanks for your feedback!
Section 3. Chapter 6
Managers Income
Task
Swipe to start coding
Now, can you output the managers who earned the biggest amount of money? Count the total sales from cinemas for each manager and present a rating of top-3 the richest managers. Print the data under columns full_name
and income
.
Solution
Everything was clear?
Thanks for your feedback!
Section 3. Chapter 6