FunctionRacerProblemsRace

Trade Value

BeginnerSQLSQLite

The value of a trade is its quantity times its price. Return the id of every trade and its value. Rows may come in any order.

Example 1

trades
idsymbolqtyprice
1AAPL10190.5
2MSFT5410.0
3KO30061.25
returns
idvalue
11905.0
22050.0
318375.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