PWC SQL Interview Question 2024 | Time Series Data I Find the Average Temperature for Each Day

[@Iamthebestthing]

Solve more questions on join and analytical functions

[@datasciencecorner]

@Manifestion_kannada sure. will do that. Thank you :)

[@Harini-x7t]

select reading_time,round(avg(temperature),2) as average_temperature
from temperature_readings
group by reading_time

[@datasciencecorner]

Great to see that you're practicing well Keep it up! Our best wishes to you :)

[@Iamthebestthing]

Date ( reading_ time ) is it work in Oracle SQL developer

[@datasciencecorner]

@Manifestion_kannada will check and let you know

[@theinsightminer08]

SELECT
DATE(reading_time) AS reading_date,
ROUND(AVG(temperature),2) AS avg_temperature
FROM temperature_readings
GROUP BY reading_date;

[@datasciencecorner]

Great :)

[@madhusudhanreddyt2838]

IN SQL SERVER (SSMS)
select
CAST(reading_time as date) as reading_date,
CAST(AVG(temperature) as decimal(10, 2)) as avg_temperature
from temperature_readings
group by
CAST(reading_time as date);

[@datasciencecorner]

Keep rocking :)