Publishers with multiple titles — DBMS OPPE Question
Publishers with multiple titles
00:00
Using the book_catalogue table, find the publishers that have more than one title in the catalogue. Return publisher and the number of titles as num_titles, including only publishers above the threshold.
Order the result by num_titles (highest first), then by publisher.
Database schema
primary keyforeign keyarrow points to the referenced columndrag to pan