Sobes.tech
Junior — Senior

SQL query: get the names of authors who have more than five books (GROUP BY + HAVING)

livecode

Task condition

Write a query that outputs all authors who have more than five records in the books table. Use two related tables: Author and Book. The Author table contains columns id and name, and the Book table contains id, name, and author_id, where author_id is a foreign key referencing Author. The query should be written in pure SQL using an aggregate function and a HAVING clause.