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

UptoLike

ВУЗ: 

ПГУ | Пенза

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

Рубрика: 

1
6
EM, дать содержательную интерпретацию результатам выполнения
SQL-запросов.
1) SELECT au_lname, au_fname
FROM authors
2) SELECT au_lname, au_fname
FROM authors
ORDER BY au_lname
3) SELECT au_lname, au_fname
FROM authors
ORDER BY au_lname, au_fname
4) SELECT title_id, price, ytd_sales,
price*ytd_sales “ytd dollar sales”
FROM titles
ORDER BY price*ytd_sales
5) SELECT title_id, price, ytd_sales,
price*ytd_sales “ytd dollar sales”
FROM titles
ORDER BY price*ytd_sales DESC
6) SELECT title_id, type, ytd_sales
FROM titles
ORDER BY type ASC, ytd_sales DESC
7) SELECT AVG(price)
FROM titles
8) SELECT DISTINCT type
FROM titles
ORDER BY type ACS
9) SELECT DISTINCT city
FROM authors 
EM, дать содержательную интерпретацию результатам выполнения
SQL-запросов.

        1) SELECT au_lname, au_fname
         FROM authors

        2) SELECT au_lname, au_fname
         FROM authors
         ORDER BY au_lname

        3) SELECT au_lname, au_fname
             FROM authors
             ORDER BY au_lname, au_fname

        4) SELECT title_id, price, ytd_sales,
                    price*ytd_sales “ytd dollar sales”
         FROM titles
         ORDER BY price*ytd_sales

        5) SELECT title_id, price, ytd_sales,
                    price*ytd_sales “ytd dollar sales”
         FROM titles
         ORDER BY price*ytd_sales DESC

        6) SELECT title_id, type, ytd_sales
         FROM titles
         ORDER BY type ASC, ytd_sales DESC

        7) SELECT AVG(price)
         FROM titles

        8) SELECT DISTINCT type
         FROM titles
         ORDER BY type ACS

        9) SELECT DISTINCT city
         FROM authors


                                   16

Страницы