Работа с базами данных в архитектуре клиент-сервер. Дубинин В.Н. - 30 стр.

UptoLike

ВУЗ: 

ПГУ | Пенза

Составители: 

Рубрика: 

30
WHERE EXISTS
(SELECT *
FROM titles t
WHERE p.pub_id=t.pub_id)
AND $22>ALL
(SELECT price
FROM titles t
WHERE p.pub_id=t.pub_id
AND price IS NOT NULL)
GROUP BY state
ORDER BY state ASC
90) SELECT state
FROM publishers p1
GROUP BY state
HAVING COUNT(DISTINCT pub_name)=
(SELECT COUNT(*)
FROM publishers p2
WHERE EXISTS
(SELECT *
FROM titles t
WHERE p2.pub_id=t.pub_id)
AND $22.5>ALL
(SELECT price
FROM titles t
WHERE p2.pub_id=t.pub_id
AND price IS NOT NULL)
GROUP BY state
HAVING p1.state=p2.state)
91) SELECT p1.pub_id
FROM titles t1, publishers p1
WHERE t1.pub_id=p1.pub_id
GROUP BY p1.pub_id
HAVING COUNT(DISTINCT title)=
(SELECT COUNT(*) 
 WHERE EXISTS
         (SELECT *
         FROM titles t
         WHERE p.pub_id=t.pub_id)
     AND $22>ALL
                (SELECT price
                FROM titles t
                WHERE p.pub_id=t.pub_id
                     AND price IS NOT NULL)
 GROUP BY state
 ORDER BY state ASC

90) SELECT state
 FROM publishers p1
 GROUP BY state
 HAVING COUNT(DISTINCT pub_name)=
          (SELECT COUNT(*)
          FROM publishers p2
          WHERE EXISTS
                     (SELECT *
                     FROM titles t
                     WHERE p2.pub_id=t.pub_id)
                    AND $22.5>ALL
                     (SELECT price
                     FROM titles t
                     WHERE p2.pub_id=t.pub_id
                          AND price IS NOT NULL)
          GROUP BY state
          HAVING p1.state=p2.state)

91) SELECT p1.pub_id
 FROM titles t1, publishers p1
 WHERE t1.pub_id=p1.pub_id
 GROUP BY p1.pub_id
 HAVING COUNT(DISTINCT title)=
      (SELECT COUNT(*)



                       30

Страницы