0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for designers and implementers of computer programming languages

SELECT 
    COUNT(U.Id) AS "Počet uživatelů",
    ROUND(100.0 * COUNT(U.Id) / (SELECT COUNT(*) FROM Users), 2) AS "Procet uživatelů bez postu"
FROM Users U
LEFT JOIN Posts P ON U.Id = P.OwnerUserId
WHERE P.OwnerUserId IS NULL

fork query

edited aug 10

created aug 10 anonymous