Practice SQL with Cinema Database

Practice SQL with Cinema Database

0%

1. Aggregating Data

This is the first list of SQL tasks.

Cinema's database

Old vs New Movies

The Best & Worst Movies

Best Selling Movies

Movie for Phoebe

Top-3 Most Selling Genres

Movies in 5th Cinema

2. Ordering Data

This is the second list of SQL tasks.

Cinema for Mary

James Cameron Movies Sales

Most Popular Genres

Movies for George

Sales of Genres in Cities

Sales Based on Rating

3. Join Data

This is the third list of SQL tasks.

Top-3 Selling Movies

Cinema for Margot

Cinemas Like 'Central'

Rating of Directors

Directors Income

Managers Income

Two Most Popular Movies

Course Content

Practice SQL with Cinema Database

Managers Income

Task

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.

Task

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.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 3. Chapter 6

toggle bottom row

Managers Income

Task

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.

Task

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.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Section 3. Chapter 6

toggle bottom row

Managers Income

Task

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.

Task

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.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Everything was clear?

Task

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.

Switch to desktop for real-world practiceContinue from where you are using one of the options below

Section 3. Chapter 6

Switch to desktop for real-world practiceContinue from where you are using one of the options below

some-alt