Testing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Drones and Model Aircraft Meta

Q&A for experienced flyers, pilots, and builders of drones and model aircraft

select datepart(year,creationdate) Years, count(*) Question  from posts 
where posttypeid = 1 and score = 0 and datepart(year,creationdate) <= 2018
group by datepart(year,creationdate) 


/*


select resultTable.Years, (cast(count(resultTable.OwnerUserId) as float)/
(SELECT cast(count(*) as float) FROM users 
where datepart(year,creationdate) = 2018))*100 ActiveUserOf2018Yearly
from (
    select datepart(year,creationdate) Years,OwnerUserId, count(*) 
    NoOfQuestionPost
    from Posts where OwnerUserId in 
    (SELECT  Id  FROM users
    where datepart(year,creationdate) = 2018)
    and posttypeid = 2 and datepart(year,creationdate) between 2018 and 2018
    group by datepart(year,creationdate), OwnerUserId 
    having count(*) > 5
) resultTable 
group by resultTable.Years
order by resultTable.Years



SELECT datepart(year,creationdate) Years, count(*) Questions FROM posts
where posttypeid = 1 and datepart(year,creationdate) <= 2018
group by datepart(year,creationdate) 
*/

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results