0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

select
  *,
  format(cast(Closed as float)/cast(Total as float) * 100,'N2') as [% Closed],
  format(cast(Deleted as float)/cast(Total as float) * 100,'N2') as [% Deleted]
from
(
  select
    sum(iif(ClosedDate is not null, 1, 0)) as Closed,
    sum(iif(DeletionDate is not null, 1, 0)) as Deleted,
    count(*) as Total
  from
    postswithdeleted
  where
    (1=1)
    and posttypeid = 1
    and tags like '%<' + ##Tag:string## + '>%'
) as sub

fork query

edited dec 29

created dec 29 0Valt