Course Content
Practice SQL with Cinema Database
Practice SQL with Cinema Database
Cinema for Mary
Task
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema
in lexicographical order.
Task
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema
in lexicographical order.
Everything was clear?
Cinema for Mary
Task
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema
in lexicographical order.
Task
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema
in lexicographical order.
Everything was clear?
Cinema for Mary
Task
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema
in lexicographical order.
Task
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema
in lexicographical order.
Everything was clear?
Task
Mary wants to watch a movie of genres Fantasy or Comedy and with rating >= 7.0. Help her to find cinemas that she could visit according to her preferences. Output the list as the column called cinema
in lexicographical order.