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

Conteúdo do Curso

Practice SQL with Cinema Database

Movie for Phoebe

Tarefa

Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!

Tarefa

Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 1. Capítulo 5

toggle bottom row

Movie for Phoebe

Tarefa

Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!

Tarefa

Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Seção 1. Capítulo 5

toggle bottom row

Movie for Phoebe

Tarefa

Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!

Tarefa

Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Tudo estava claro?

Tarefa

Help Phoebe to find the best movie (based on the rating), if she prefers Gerard Krawczyk, Frank Darabont, and Christopher Nolan directors. Display the label of this movie as label, rating, and director's full_name. Only one record in total!

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

Seção 1. Capítulo 5

Mude para o desktop para praticar no mundo realContinue de onde você está usando uma das opções abaixo

some-alt