Testing

0

Please login or register to vote for this query.

(click on this box to dismiss)

Craft CMS

Q&A for administrators, end users, developers and designers for Craft CMS

-- total Questions : 16867398
select datepart(year,creationdate) Years, count(*) QuestionsYearly,
(count(*)/cast(16867398 as float))*100 as percentage,
cast(round((count(*)/cast(16867398 as float)*100 ),2) as NUMERIC(15,2)) percentageRound,
cast(count(*) as varchar(20))+ CHAR(13) + CHAR(10) +'(' 
+cast( cast(round((count(*)/cast(16867398 as float)*100 ),2) as NUMERIC(15,2))   as varchar(20))+
'%)' StringPercentatge  FROM posts
where posttypeid = 1 and datepart(year,creationdate) <= 2018
group by datepart(year,creationdate)

Enter Parameters

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