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

 ORDER BY city DESC

10) SELECT DISTINCT state
 FROM authors
 ORDER BY state

11) SELECT DISTINCT country
 FROM publishers
 ORDER BY country DESC

12) SELECT AVG(price), AVG(DISTINCT price)
 FROM titles

13) SELECT *
 FROM titles

14) SELECT au_lname, au_fname
 FROM authors
 WHERE state= “CA”

15) SELECT type, title_id, price
 FROM titles
 WHERE price*ytd_sales < advance

16) SELECT au_id, city, state
 FROM authors
 WHERE state= “CA” OR city= “Palo Alto”

17) SELECT title_id, price
 FROM titles
 WHERE price between $5 AND $15

18) SELECT title_id, price
 FROM titles
 WHERE type IN (“mod_cook”, “trad_cook”, “business”)




                         17