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

UptoLike

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

20
FROM titles
GROUP BY type
HAVING MAX(price)-MIN(price)>=3
36) SELECT state, COUNT(DISTINCT pub_id)
FROM publishers
GROUP BY state
37) SELECT pub_name, AVG(price) “ävg”,
COUNT(DISTINCT title_id) “count”
FROM titles t JOIN publishers p ON t.pub_id=p.pub_id
GROUP BY pub_name
38) SELECT type, (MIN(price)+MIN(price))/2, AVG(price)
FROM titles
GROUP BY type
HAVING type<> “UNDECIDED”
ORDER BY 2 DESC
39) SELECT type, MIN(pubdate), MAX(pubdate)
FROM titles
GROUP BY type
40) SELECT title, pub_name
FROM titles CROSS JOIN publishers
41) SELECT *
FROM titles, publishers
42) SELECT title, pub_name
FROM titles, publishers
WHERE titles.pub_id=publishers.pub_id
43) SELECT title, pub_name
FROM titles JOIN publishers
ON titles.pub_id=publishers.pub_id
 FROM titles
 GROUP BY type
 HAVING MAX(price)-MIN(price)>=3

36) SELECT state, COUNT(DISTINCT pub_id)
 FROM publishers
 GROUP BY state

37) SELECT pub_name, AVG(price) “ävg”,
 COUNT(DISTINCT title_id) “count”
 FROM titles t JOIN publishers p ON t.pub_id=p.pub_id
 GROUP BY pub_name

38) SELECT type, (MIN(price)+MIN(price))/2, AVG(price)
 FROM titles
 GROUP BY type
 HAVING type<> “UNDECIDED”
 ORDER BY 2 DESC

39) SELECT type, MIN(pubdate), MAX(pubdate)
 FROM titles
 GROUP BY type

40) SELECT title, pub_name
 FROM titles CROSS JOIN publishers

41) SELECT *
 FROM titles, publishers

42) SELECT title, pub_name
 FROM titles, publishers
 WHERE titles.pub_id=publishers.pub_id

43) SELECT title, pub_name
 FROM titles JOIN publishers
      ON titles.pub_id=publishers.pub_id



                           20