SELECT data

Here are some examples of basic queries.

Return the number of entries written to the table in the last 12 hours:

Get information about the weather conditions at each location, for each 15-minute period within the last 3 hours. Calculate the number of measurements taken, the maximum temperature, and the maximum humidity. Order the results by maximum temperature.

Count the number of distinct locations with air conditioning that have reported data in the last day: