CREATE PROC TopPublishers(@count INT)
AS
SELECT pub_name FROM pubs..publishers
WHERE pub_id IN

(SELECT TOP(@count) pub_id FROM pubs..titles
ORDER BY ytd_sales DESC)
a
b
