ВУЗ:
Составители:
Рубрика:
21
44) SELECT *
FROM titles t, publishers p
WHERE t.pub_id=p.pub_id
45) SELECT t.*, pub_name
FROM titles t, publishers p
WHERE t.pub_id=p.pub_id
46) SELECT a.city, a.state
FROM authors a, publishers p
WHERE a.city=p.city AND a.state=p.state
47) SELECT au_lname, au_fname
FROM authors a JOIN titleauthor ON a.au_id=ta.au_id
JOIN titles t ON ta.title_id=t.title_id
WHERE au_lname LIKE “R%”
AND state IN (“CA”, “TX”, “NY”, “OR”, “UT”)
AND (title LIKE “_h_ %” OR title LIKE “% _h_ %”
OR title LIKE “% _h_”)
48) SELECT title, type
FROM authors a, titles t, titleauthor ta, publishers p
WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
AND t.pub_id=p.pub_id AND p.city=a.city
49) SELECT au_lname, au_fname, title
FROM authors a, titles t, titleauthor ta, publishers p
WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
AND t.pub_id=p.pub_id
AND ((p.country= ‘USA’ AND t.type=’popular_comp’)
OR (p.country=’France’ AND t.type=’psychology’))
50) SELECT au_lname, au_fname, city
FROM authors a, titles t, titleauthor ta
WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id
44) SELECT * FROM titles t, publishers p WHERE t.pub_id=p.pub_id 45) SELECT t.*, pub_name FROM titles t, publishers p WHERE t.pub_id=p.pub_id 46) SELECT a.city, a.state FROM authors a, publishers p WHERE a.city=p.city AND a.state=p.state 47) SELECT au_lname, au_fname FROM authors a JOIN titleauthor ON a.au_id=ta.au_id JOIN titles t ON ta.title_id=t.title_id WHERE au_lname LIKE “R%” AND state IN (“CA”, “TX”, “NY”, “OR”, “UT”) AND (title LIKE “_h_ %” OR title LIKE “% _h_ %” OR title LIKE “% _h_”) 48) SELECT title, type FROM authors a, titles t, titleauthor ta, publishers p WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id AND t.pub_id=p.pub_id AND p.city=a.city 49) SELECT au_lname, au_fname, title FROM authors a, titles t, titleauthor ta, publishers p WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id AND t.pub_id=p.pub_id AND ((p.country= ‘USA’ AND t.type=’popular_comp’) OR (p.country=’France’ AND t.type=’psychology’)) 50) SELECT au_lname, au_fname, city FROM authors a, titles t, titleauthor ta WHERE ta.title_id=t.title_id AND a.au_id=ta.au_id 21
Страницы
- « первая
- ‹ предыдущая
- …
- 19
- 20
- 21
- 22
- 23
- …
- следующая ›
- последняя »