Kodewick
Start learning →
SQL

SQL

For people just starting SQL, on a little shop's data. Write right away; get one wrong and Wick shows you how your code really runs.

0 / 3 solved
SQLSQL 3PyPython starterPyPython next stepsCC starterC++C++ starterGoGo starter

SELECT Pick the rows and columns0 / 1

#001Under twentyThe cheap things: name and priceStarterSELECT2 min

ORDER BY, LIMIT Order, and only the first few0 / 1

#002The top threeDearest first, only the first threeStarterORDER BY, LIMIT3 min

GROUP BY Group by kind0 / 1

#003How many of eachGroup by kind and countBasicGROUP BY Aggregates4 min