Re: sql aggregate functions
Originally Posted by
Xender1
Now I am trying to find only People who have written more than 2 books and have it select the same info (people.name and books.title)
There are two steps here, as your sentence implies:
1. Find people who have written more than two books
2. Show the books written by those people
You'll find it easier to do the first part on its own, then learn to do the second part using the first.
Hints:
1. This is a group by and having query. Just aim to list the names of authors with more than two books.
2. Correlated subquery
Please create new threads for new questions.
Please wrap code in code tags using the '#' button or enter it in your post like this: [code]...[/code].
Bookmarks