Napište SQL, které vypíše takové uživatele, jež nemají v profilu vyplněno pole WebsiteUrl

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language and Usage Meta

Q&A about the site for linguists, etymologists, and serious English language enthusiasts

SELECT 
          ROUND((COUNT(u.id) * 100.0) / (SELECT COUNT(*) FROM Users), 2) AS Procent_neaktiv_uživatelů
FROM Users u
LEFT JOIN Posts p ON u.id = p.OwnerUserId
WHERE p.OwnerUserId IS NULL;

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results