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

UptoLike

ВУЗ: 

ПГУ | Пенза

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

Рубрика: 

18
19) SELECT au_lname, au_fname, city, state
FROM authors
WHERE city like “San%”
20) SELECT type, title_id, price
FROM titles
WHERE title_id like “B_2075”
21) SELECT type, title_id, price
FROM titles
WHERE title_id like “B[AUN]7832”
22) SELECT AVG(price) “AVG”
FROM titles
WHERE type= “business”
23) SELECT AVG(price) “avg” SUM(price) “sum”
FROM titles
WHERE type IN (“business”, “mod_cook”)
24) SELECT COUNT(*)
FROM authors
WHERE state= “CA”
25) SELECT COUNT(*)
FROM titles
WHERE LIKE “Co%s”
26) SELECT title
FROM titles
WHERE ytd_sales IS NULL
27) SELECT au_lname “Фамилия”, au_fname “Имя”
FROM authors
WHERE contract=1 AND phone LIKE “408____-__2_” 
19) SELECT au_lname, au_fname, city, state
 FROM authors
 WHERE city like “San%”

20) SELECT type, title_id, price
 FROM titles
 WHERE title_id like “B_2075”

21) SELECT type, title_id, price
 FROM titles
 WHERE title_id like “B[AUN]7832”

22) SELECT AVG(price) “AVG”
 FROM titles
 WHERE type= “business”

23) SELECT AVG(price) “avg” SUM(price) “sum”
 FROM titles
 WHERE type IN (“business”, “mod_cook”)

24) SELECT COUNT(*)
 FROM authors
 WHERE state= “CA”

25) SELECT COUNT(*)
 FROM titles
 WHERE LIKE “Co%s”

26) SELECT title
 FROM titles
 WHERE ytd_sales IS NULL

27) SELECT au_lname “Фамилия”, au_fname “Имя”
 FROM authors
 WHERE contract=1 AND phone LIKE “408____-__2_”




                           18

Страницы