Требуется сформулировать запрос “Найти названия издательств и имена авторов, которые опубликовали в данном издательстве самую дорогую книгу”. Какие из приведенных ниже формулировок являются правильными?

SELECT PUBLISHERS.PUB_NAME, AUTHOR_NAMEFROM AUTHORS, AUTHORS-BOOKS, BOOKS, PUBLISHERSWHERE AUTHORS.AUTHOR_ID =  AUTHORS-BOOKS.AUTHOR_ID  AND AUTHORS-BOOKS.ISBN = BOOKS.ISBN  AND BOOKS.PUB_ID = PUBLISHERS.PUB_ID  AND NOT EXISTS (SELECT *                   FROM BOOKS BOOKS1,                      PUBLISHERS PUBLISHERS1                   WHERE BOOKS1.PUB_ID =                     PUBLISHERS1.PUB_ID                     AND PUBLISHERS1.PUB_ID =                       PUBLISHERS.PUB_ID                     AND BOOKS1.PRICE >                       BOOKS.PRICE);

SELECT PUBLISHERS.PUB_NAME, AUTHOR_NAMEFROM AUTHORS, AUTHORS-BOOKS,     BOOKS, PUBLISHERSWHERE AUTHORS.AUTHOR_ID =  AUTHORS-BOOKS.AUTHOR_ID  AND AUTHORS-BOOKS.ISBN = BOOKS.ISBN  AND BOOKS.PUB_ID = PUBLISHERS.PUB_ID  AND BOOKS.PRICE = (SELECT MAX (BOOKS1.PRICE)                      FROM BOOKS BOOKS1,                          PUBLISHERS PUBLISHERS1                      WHERE BOOKS1.PUB_ID =                        PUBLISHERS1.PUB_ID                        AND PUBLISHERS1.PUB_ID =                          PUBLISHERS.PUB_ID);