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

UptoLike

ВУЗ: 

ПГУ | Пенза

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

Рубрика: 

28
WHERE country= “USA”)
83) SELECT pub_name, COUNT(*)
FROM titles t, publishers p
WHERE t.pub_id=p.pub_id
GROUP BY pub_name
HAVING COUNT(*)>=ALL
(SELECT COUNT(*)
FROM titles tt, publishers pp
WHERE tt.pub.id=pp.pub_id
GROUP BY pub_name)
84) SELECT pub_name, city, state, country
FROM publishers p
WHERE EXISTS
(SELECT *
FROM titles t
WHERE t.pub_id=p.pub_id)
AND 20>ALL
(SELECT price
FROM titles t
WHERE t.pub_id=p.pub_id
AND price IS NOT NULL)
85) SELECT state, SUM(price)
FROM titles t, publishers p
WHERE t.pub_id=p.pub_id
GROUP BY state
HAVING state NOT IN (“TN”, “MA”, “TX”)
AND SUM(price)>
(SELECT SUM(price)
FROM titles tt, publishers pp
WHERE tt.pub.id=pp.pub_id
AND pp.city= “Boston”)
86) SELECT pub_name, MIN(price) 
                 WHERE country= “USA”)

83) SELECT pub_name, COUNT(*)
 FROM titles t, publishers p
 WHERE t.pub_id=p.pub_id
 GROUP BY pub_name
 HAVING COUNT(*)>=ALL
            (SELECT COUNT(*)
            FROM titles tt, publishers pp
            WHERE tt.pub.id=pp.pub_id
            GROUP BY pub_name)

84) SELECT pub_name, city, state, country
 FROM publishers p
 WHERE EXISTS
          (SELECT *
          FROM titles t
          WHERE t.pub_id=p.pub_id)
         AND 20>ALL
          (SELECT price
          FROM titles t
          WHERE t.pub_id=p.pub_id
                AND price IS NOT NULL)

85) SELECT state, SUM(price)
 FROM titles t, publishers p
 WHERE t.pub_id=p.pub_id
 GROUP BY state
 HAVING state NOT IN (“TN”, “MA”, “TX”)
      AND SUM(price)>
                  (SELECT SUM(price)
                  FROM titles tt, publishers pp
                  WHERE tt.pub.id=pp.pub_id
                        AND pp.city= “Boston”)

86) SELECT pub_name, MIN(price)



                           28

Страницы