FunctionRacerProblemsRace

Cheapest First

BeginnerSQLSQLite

Return the id and price of every trade, the cheapest first. Trades at the same price go in order of id, smallest first.

Example 1

trades
idsymbolqtyprice
3AAPL1020.0
1MSFT535.5
2AAPL720.0
4KO19.75
returns
idprice
49.75
220.0
320.0
135.5

Constraints

Race itor take your time

Write it in your browser, against the clock. The model query, with a note on each piece of it, comes after.

More SQL problems