HW1

0

Please login or register to vote for this query.

(click on this box to dismiss)

Joomla

Q&A for Joomla! administrators, users, developers and designers

SELECT COUNT(Id) FROM Posts
Select MIN(CreationDate) from Posts
Select Max(CreationDate) From Posts
select avg(Score) from Posts



select year(CreationDate), month(CreationDate), count(Id)
from Posts
group by year(CreationDate), month(CreationDate)
order by year(CreationDate), month(CreationDate)


select PostTypeId, count(PostTypeId) as cnt, year(CreationDate) as yr, 
       month(CreationDate) as m
from Posts
group by PostTypeId, year(CreationDate), month(CreationDate)
order by PostTypeId, cnt desc


select top 20 count(Name) as cnt, Name
from Badges
group by Name
order by cnt, Name

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results