Стас, 8 задание

--8.1
CREATE TABLE user1_table AS SELECT * FROM Clients
WHERE CNUM IS NOT NULL AND CNAME  IS NOT NULL AND CITY  IS NOT NULL AND RATING  IS NOT NULL AND SNUM IS NOT NULL;

--8.2
CREATE VIEW user1_view AS
SELECT CNAME,CITY FROM user1_table;

--8.3
DROP TABLE USER1_TABLE;

--8.4
SELECT * FROM USER1_VIEW;

-- 8.5
CREATE TABLE user1_table AS SELECT * FROM Clients
WHERE CNUM IS NOT NULL AND CNAME  IS NOT NULL AND CITY  IS NOT NULL AND RATING  IS NOT NULL AND SNUM IS NOT NULL;
SELECT * FROM USER1_VIEW;