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 
          u.id,
          COUNT(p.id) AS Počet_postů
FROM Users u
LEFT JOIN Posts p ON u.id = p.OwnerUserId
GROUP BY u.id

Enter Parameters

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