Re: sql aggregate functions
There are two steps here, as your sentence implies:
Originally Posted by Xender1
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.
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].