Write a single sql query that lists for each decade


Problem: Write a single SQL query that lists, for each decade, the name of the decade (in the format detailed below) and the title and rating of the highest rated movie (or movies, if there is more than one equally best rated) that premiered in that decade, listed in increasing order of decade. For this purpose, a decade refers to a 10-year time-span, such as 1920-1929, 1930-1939, and continuing until 2020-2029. Refer to each decade using the strings 1920s, 1930s, and so on.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write a single sql query that lists for each decade
Reference No:- TGS03253687

Expected delivery within 24 Hours