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

 WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
    AND t.pub_id=p.pub_id
 GROUP BY au_lname, au_fname, pub_name

58) SELECT MIN(price)
 FROM titles t, publishers p
 WHERE t.pub_id=p.pub_id
 GROUP BY country
 HAVING country=’USA’

59) SELECT pub_name, COUNT(*)
 FROM titles t, publishers p
 WHERE t.pub_id=p.pub_id
      AND (type= ‘mod_cook’ OR type=’trad_cook’)
 GROUP BY pub_name

60) SELECT pub_name, COUNT(*)
 FROM publishers p, titles t
 WHERE p.pub_id=t.pub_id AND price>$15
 GROUP BY pub_name
 ORDER BY pub_name DESC

61) SELECT title, COUNT(DISTINCT a.au_id)
 FROM titles t JOIN titleauthor ta ON t.title_id=ta.title_id
      JOIN authors a ON ta.au_id=a.au_id
      JOIN publishers p ON p.pub_id=t.pub_id
 GROUP BY title

62) SELECT state, COUNT(DISTINCT p.pub_id)
     FROM publishers p JOIN titles t ON p.pub_id=t.pub_id
     GROUP BY state

63) SELECT title
 FROM titles
 WHERE pub_id=
            (SELECT pub_id



                             23