FROM CUST
ORDER BY CUST_SUM
3.37.
?
, CUST
SELECT AVG (CUST_SUM)
FROM CUST
3.38.
, , . . , .
SELECT PROD_NAME, PRICE, STORE, (PRICE* STORE)
FROM PROD
5%. :
SELECT PROD_NAME, PRICE, (PRICE*1.05)
FROM PROD
, , .
, , . :
SELECT ORDER_NUM, MONTH (DATE_ORDER), YEAR (DATE_ORDER)
FROM ORDERS
3.39.
. SQL "*".
SELECT *
FROM ORDERS
3.40.
. , , , ORDERS. 3101, 3105, 3103 , , . DISTINCT.
SELECT DISTINCT CUST_NUM
FROM ORDERS
3.41.
. SELECT :
SELECT PROD_ID, MIN (QTY), MAX (QTY)
FROM ORDERS
GROUP BY PROD_ID
: , . QTY , , .
3.42.
HAVING , . . 20.
SELECT PROD_ID, MAX (QTY)
FROM ORDERS
GROUP BY PROD_ID
HAVING SUM (QTY)<=20
, . , 20. .
3.43.
, . , , , . SELECT , ORDERS CUST.
|
|
SELECT ORDER_NUM, CUST_NAME, PROD_ID, QTY, DATE_ORDER
FROM ORDERS, CUST
WHERE CUST.CUST_NUM=ORDERS.CUST_NUM
, -, , FROM , . -, WHERE CUST.CUST_NUM=ORDERS.CUST_NUM . .
, , , . , .
:
UPDATE < >
SET < > = {<> | NULL}
[,SET < > = {<> | NULL}... ]
[WHERE <>]
UPDATE SET , , WHERE.
(NULL), .
3.44.
15% , 100$. , UPDATE, :
UPDATE PROD
SET PRICE=(PRICE*1.15)
WHERE PRICE <=100
:
INSERT INTO < > [(< >)] VALUES (< >)
INSERT INTO < > [(< >)]
< SELECT>
INSERT . , VALUES. < > , < > .
INSERT , SELECT.
3.45.
CUST , . :
INSERT INTO CUST
VALUES ("3110", " ..", NULL)
3.46.
OLDORDERS .
INSERT INTO OLDORDERS (ORDER_NUM, CUST_NUM, PROD_ID, QTY, DATE_ORDER)