question: the table show timestamp column, i dont group by them but they show, i want to ask why they show that information but not others?
can you access this link? task 9 to 11
SELECT timestamp, strftime(’%H’, timestamp), round(avg(score)) as avgscore, count(*)
where timestamp is not null
GROUP BY 2
order by 2;