0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for researchers, developers, and users of Tor

-- 20241010 uživatelů bez příspěvku
-- pct
-- -------
-- 25349160
with
tx as (
  -- select count(*) qty from (
    -- top 10
    -- select distinct id from users u
    -- union
    select OwnerUserId from Posts
    group by OwnerUserId
    having count(OwnerUserId) > 10
  -- )
),
ty as (
  -- select count(*) qty from (
    select distinct id from users
  -- )
),
x as (select count(*) qty from tx),
y as (select count(*) qty from ty)
select
  x.qty -- , y.qty,
  -- round((x.qty/y.qty)*100,2) pct
  -- convert(varchar,round((x.qty/y.qty)*100,2)) pct
from x; -- ,y;
  
-- convert(varchar,convert(decimal(8,2),something))

fork query

edited oct 10 jon.doe45967

created oct 10 anonymous