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 power users of web applications

SELECT 
          COUNT(*) AS Počet_uživatelů
FROM Users u
LEFT JOIN Posts p ON u.id = p.OwnerUserId
WHERE p.OwnerUserId IS NULL;;

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