Зміст курсу
Practice SQL with Cinema Database
Practice SQL with Cinema Database
James Cameron Movies Sales
Завдання
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.
Завдання
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.
Все було зрозуміло?
James Cameron Movies Sales
Завдання
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.
Завдання
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.
Все було зрозуміло?
James Cameron Movies Sales
Завдання
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.
Завдання
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.
Все було зрозуміло?
Завдання
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.