The Banner

The top of the shop's website gets a Christmas banner with the biggest gifts: the three most expensive games that are already out. Each game is one line of text, such as Knight's Oath for $60: the title, for $ and the price. Show the lines in one column named banner, the most expensive game first. When two games cost the same, the one whose title comes first in alphabetical order goes first, so that the order is always clear, even at the end of the banner. For now, the banner is:

banner
Knight's Oath for $60
Goal Rush for $50
Ice Hockey Pro for $45

Robot Rebellion isn't out yet, so it can't be on the banner, even if its price goes up.

A tip: think about which column decides the order. The text of the banner starts with the title, so if you sorted by it, the games would come in alphabetical order.

Instructions

Below the comment -- 2. The banner, write the query for the banner.

Start programming for free

By signing up, you agree to the Terms of Service and Privacy Policy.

Or sign up with:

2/3