FunctionRacerProblemsRace

Orders With Names

EasySQLSQLite

orders only knows its customer by number. Return, for every order, its id, the customer's name and the amount. Rows may come in any order.

Example 1

customers
idname
1Ada
2Ben
3Cy
orders
idcustomer_idamount
10250.0
11120.5
1227.0
returns
idnameamount
10Ben50.0
11Ada20.5
12Ben7.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