ВУЗ:
Составители:
Рубрика:
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
Страницы
- « первая
- ‹ предыдущая
- …
- 18
- 19
- 20
- 21
- 22
- …
- следующая ›
- последняя »