0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for GenAI enthusiasts and practitioners and those interested in learning more about using GenAI tools

with PocetN as(
     SELECT
      count(1) as poc
    from users u
    where not exists(
    SELECT 1
    FROM POSTS P
    WHERE P.TITLE IS NOT NULL 
    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
;

fork query

edited sep 20

created sep 20 jon.doe45742