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

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for expert genealogists and people interested in genealogy or family history

SELECT 
          COUNT (*) AS Počet_uživatelů
FROM Users u 
WHERE u.id NOT IN (SELECT p.OwnerUserId FROM Posts p);

edited may 27

created may 27

anonymous

Options: Text-only results Include execution plan

Switch to main site

Hold tight while we fetch your results

Results[:current/:total] Messages Graph Execution Plan

Download CSV Download XML

:records returned in :time ms:cached