FunctionRacerProblemsRace

Low and High

EasySQLSQLite

Return each symbol once with low, the lowest price among its trades, and high, the highest. Rows may come in any order.

Example 1

trades
idsymbolqtyprice
1AAPL10190.5
2MSFT5410.0
3AAPL7188.0
4AAPL1193.0
returns
symbollowhigh
AAPL188.0193.0
MSFT410.0410.0

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