0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for students, teachers, and linguists wanting to discuss the finer points of the Italian language

with PocetN as(
  SELECT
    count(1) poc
  from users u
  where not exists(
  SELECT 1
  FROM POSTS P
  WHERE PostTypeId in (1,2)
  and  p.ownerUserId =u.id)
)
,
PocetC as (
  select count(1) celkem
  from users u
)

select 
convert(char,round(convert(real,poc)/convert(real,celkem),4)*100) + '%' 
  as vysledny_pomer
from PocetN,PocetC
;
--vysledek: 80.68 %

view current version

edited sep 20

created sep 20 jon.doe45742