Вариант 3

/*Вариант 3 */


/*2ра задача */
SELECT JOB_TITLE , MIN_SALARY
FROM JOBS
WHERE MIN_SALARY > 15000
ORDER BY 2, 1 DESC

SELECT FNAME , JOB_TITLE
FROM EMPLOYEES E JOIN JOBS J
ON E.JOB_ID = J.JOB_ID

SELECT O.ORDER_ID , ORDER_DATE, COUNT(PRODUCT_ID)
FROM ORDERS O JOIN ORDER_ITEMS OI
ON O.ORDER_ID = OI.ORDER_ID
GROUP BY O.ORDER_ID, ORDER_DATE
HAVING COUNT(PRODUCT_ID) > 7



/*3та задача */
CREATE VIEW GLEDKA
AS
SELECT FNAME , LNAME , NAME
FROM CUSTOMERS C RIGHT JOIN COUNTRIES CO
ON C.COUNTRY_ID = CO.COUNTRY_ID

SELECT * FROM  GLEDKA




/*1ва задача */
CREATE DATABASE POLT4ETA
USE POLT4ETA
CREATE TABLE FLIGHTS
(
FLIGHT_ID INT PRIMARY KEY,
DEPT DATETIME NOT NULL,
PLANE_TYPE CHAR(1) NOT NULL
)

CREATE TABLE PASSENGERS
(
PASS_ID INT PRIMARY KEY,
PASS_NAME VARCHAR(64) NOT NULL
)

CREATE TABLE RESERVATIONS
(
FLIGHT_ID INT FOREIGN KEY REFERENCES FLIGHTS ON DELETE CASCADE,
PASS_ID INT FOREIGN KEY REFERENCES PASSENGERS ON DELETE CASCADE,
DATE DATETIME NOT NULL,
SEAT INT NOT NULL
PRIMARY KEY(FLIGHT_ID, PASS_ID)
)

ALTER TABLE PASSENGERS
ADD NATIONALITY VARCHAR(32)


INSERT INTO FLIGHTS VALUES (6450, '2013-6-15', 'K')
INSERT INTO PASSENGERS VALUES (1877 , 'KORONA', 'BIRA')
INSERT INTO RESERVATIONS VALUES (6450, 1876, '2018-05-14', 4)

UPDATE RESERVATIONS
SET SEAT = 21
WHERE FLIGHT_ID = 6447 AND PASS_ID = 1876

DELETE FROM RESERVATIONS
WHERE DATE > '2010-11-10'