SQL and Relational Databases
Tables of rows linked by keys, queried with SQL.
Easy
SELECT sensor, AVG(value) FROM readings
WHERE taken_at > now() - interval '1 day'
GROUP BY sensor;
Learn joins, indexes, transactions and normalisation.
Spotted a mistake or want to add detail? Suggest an improvement — Content Contributors' edits are reviewed by editors before they go live.
Discussion (0)
Sign in or join free to ask questions and discuss this topic.