88
•Find all authors who wrote at least 10 documents:
•Attempt 2: SQL style (with GROUP BY)
SELECT       Author.name
FROM          Author, Wrote
WHERE       Author.login=Wrote.login
GROUP BY Author.name
HAVING     count(wrote.url) > 10
This is
SQL  by
an expert
No need for DISTINCT: automatically from GROUP BY