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)/(SELECT COUNT(*) FROM Users)*100, 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