<prompt> Kuandika SQL query cheo sinema kulingana na mapato yao ofisi ya ofisi, na 1 kuwa mapato ya juu.Data seti ina rekodi za mauzo kutoka maduka  <response>: Assuming the relevant columns are movie_title and box_office_revenue in a table called movies_sales, the SQL query would be:SELECT movie_title, box_office_revenue, RANK OVER ORDER BY box_office_revenue DESC AS revenue_rankingFROM movies_sales;This query selects the relevant columns and uses the RANK function to assign a ranking to each movie based on their box office revenue. The OVER clause specifies that the ranking should be calculated over the entire table, and the ORDER BY clause sorts the movies by their revenue in descending order. The result includes columns for movie title, revenue, and the calculated revenue ranking. 