Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
James Cameron Movies Sales
Task
James Cameron's movies are very popular, but are they such in each city? Create a list of cities, containing info about sales of James Cameron's movies.
Print records with two columns: city
and sales
(containing the total sales of James Cameron's movies). Order records by city
in lexicographical order.
Task
James Cameron's movies are very popular, but are they such in each city? Create a list of cities, containing info about sales of James Cameron's movies.
Print records with two columns: city
and sales
(containing the total sales of James Cameron's movies). Order records by city
in lexicographical order.
Everything was clear?
James Cameron Movies Sales
Task
James Cameron's movies are very popular, but are they such in each city? Create a list of cities, containing info about sales of James Cameron's movies.
Print records with two columns: city
and sales
(containing the total sales of James Cameron's movies). Order records by city
in lexicographical order.
Task
James Cameron's movies are very popular, but are they such in each city? Create a list of cities, containing info about sales of James Cameron's movies.
Print records with two columns: city
and sales
(containing the total sales of James Cameron's movies). Order records by city
in lexicographical order.
Everything was clear?
James Cameron Movies Sales
Task
James Cameron's movies are very popular, but are they such in each city? Create a list of cities, containing info about sales of James Cameron's movies.
Print records with two columns: city
and sales
(containing the total sales of James Cameron's movies). Order records by city
in lexicographical order.
Task
James Cameron's movies are very popular, but are they such in each city? Create a list of cities, containing info about sales of James Cameron's movies.
Print records with two columns: city
and sales
(containing the total sales of James Cameron's movies). Order records by city
in lexicographical order.
Everything was clear?
Task
James Cameron's movies are very popular, but are they such in each city? Create a list of cities, containing info about sales of James Cameron's movies.
Print records with two columns: city
and sales
(containing the total sales of James Cameron's movies). Order records by city
in lexicographical order.