コードタイピング
SQLスニペット
SQLタイピング練習。
INNER JOIN
Join customers and orders, project a flat report.
GROUP BY with HAVINGAggregate customer spend and filter high-value accounts.
Window FunctionRank orders by total within each customer.
Recursive CTEWalk a category tree from the root down.
UPSERTInsert or update on conflict (PostgreSQL syntax).
Composite IndexAccelerate a common query with a multi-column index.