0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for enthusiasts and scholars of mythology and folklore

select count(id) as num_of_posts, min(CreationDate) as min_date, max(CreationDate) as max_date, avg(Score) as avg_score from posts;
select len(month(creationdate)) from posts;
select concat_ws('-', year(creationdate), (case when len(month(creationdate))<2 then concat('0', month(creationdate)) else month(creationdate) end)) as year_month from posts;

view current version

edited sep 19

created sep 19 anonymous