Skip to content

Instantly share code, notes, and snippets.

@parzibyte

parzibyte/12.sql Secret

Created December 29, 2020 03:09
Show Gist options
  • Save parzibyte/e5c3b6ad511311bd6db7b28361285dbc to your computer and use it in GitHub Desktop.
Save parzibyte/e5c3b6ad511311bd6db7b28361285dbc to your computer and use it in GitHub Desktop.
Download ZIP
Raw
12.sql
# Mostrar el promedio de la temperatura pero solo para el día 24 de diciembre del 2020
SELECT AVG(temperature)
FROM dht_log
WHERE date >= "2020-12-24 00:00:00"
AND date <= "2020-12-24 23:59:59";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment