FunctionRacerProblemsRace

Between Two Prices

BeginnerSQLSQLite

Return the id and price of the trades priced from 10 to 20, both ends included. Rows may come in any order.

Example 1

trades
idsymbolqtyprice
1KO1010.0
2KO520.0
3XOM720.5
4XOM215.25
5KO19.99
returns
idprice
110.0
220.0
415.25

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