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

UptoLike

ВУЗ: 

ПГУ | Пенза

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

Рубрика: 

2
6
WHERE pub_id IN
(SELECT pub_id
FROM titles
WHERE type= “psychology”)
75) SELECT pub_name
FROM publishers p
WHERE 15>SOME
(SELECT price
FROM titles t
WHERE p.pub_id=t.pub_id
AND type= “trad_cook”)
76) SELECT pub_name, state
FROM publishers
WHERE pub_id NOT IN
(SELECT pub_id
FROM titles)
77) SELECT title
FROM titles
WHERE pub_id NOT IN
(SELECT pub_id
FROM publishers)
78) SELECT title
FROM titles t
WHERE price>=
(SELECT AVG(price)
FROM titles tt, publishers pp
GROUP BY pub_id
HAVING t.pub_id=pp.pub_id)
79) SELECT au_lname, au_fname, price
FROM authors a, titles t, titleauthor ta, publishers p
WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id 
      WHERE pub_id IN
              (SELECT pub_id
              FROM titles
              WHERE type= “psychology”)

    75) SELECT pub_name
     FROM publishers p
     WHERE 15>SOME
              (SELECT price
              FROM titles t
              WHERE p.pub_id=t.pub_id
                    AND type= “trad_cook”)

    76) SELECT pub_name, state
     FROM publishers
     WHERE pub_id NOT IN
                    (SELECT pub_id
                    FROM titles)

    77) SELECT title
     FROM titles
     WHERE pub_id NOT IN
                     (SELECT pub_id
                     FROM publishers)

    78) SELECT title
     FROM titles t
     WHERE price>=
                (SELECT AVG(price)
                FROM titles tt, publishers pp
                GROUP BY pub_id
                HAVING t.pub_id=pp.pub_id)

79) SELECT au_lname, au_fname, price
     FROM authors a, titles t, titleauthor ta, publishers p
     WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id



                                 26

Страницы