87
•Find all authors who wrote at least 10 documents:
•Attempt 1: with nested queries
SELECT DISTINCT Author.name
FROM          Author
WHERE        count(SELECT Wrote.url
                                 FROM Wrote
                                 WHERE Author.login=Wrote.login)
                          > 10
This is
SQL by
a novice