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

           AND (city LIKE “[CPR]%” OR city LIKE “%San%”)
           AND (title LIKE “% the %” OR title LIKE “The %”
            OR title LIKE “% a %” OR title LIKE “A %”)

51) SELECT DISTINCT au_lname, au_fname
 FROM authors a JOIN titleauthor ta ON a.au_id=ta.au_id
      JOIN titles t ON ta.title_id=t.title_id
      JOIN publishers p ON p.pub_id=t.pub_id
 WHERE p.state= “CA”
 ORDER BY au_lname, au_fname

52) SELECT pub_name
     FROM publishers p JOIN titles t ON p.pub_id=t.pub_id
 WHERE $15>price AND type= “psychology”
     ORDER BY pub_name

53) SELECT pub_name, AVG(price)
 FROM titles t, publishers p
 WHERE t.pub_id=p.pub_id
 GROUP BY pub_name

54) SELECT pub_name, AVG(price)
 FROM titles t JOIN publishers p ON t.pub_id=p.pub_id
 GROUP BY pub_name

55) SELECT au_lname, au_fname, title
 FROM authors a, titles t, titleauthor ta
 WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
      AND type= “popular_comp”

56) SELECT au_lname, au_fname, title
 FROM authors a JOIN titleauthor ta ON a.au_id=ta.au_id
      JOIN titles t ON ta.title_id=t.title_id
 WHERE type= “psychology”

57) SELECT au_lname, au_fname, pub_name, COUNT(*)
 FROM authors a, titles t, titleauthor ta, publishers p


                          22