DELETE FROM students WHERE snom =123

DROP TABLE T1

DELETE FROM VYKLAD WHERE VNOM=105

DROP DOMAIN GOD

DROP VIEW WQ2

ALTER TABLE PREDMET ADD CONSTRAINT FK_PREDMET_1 FOREIGN KEY (VNOM) REFERENCES VYKLAD(VNOM) ON DELETE CASCADE ON UPDATE CASCADE

CREATE TABLE PREDMET (PNOM INTEGER NOT NULL PRIMARY KEY, PNAME VARCHAR(15), VNOM INTEGER , GOD INTEGER);

CREATE DOMAIN GOD AS INTEGER DEFAULT 50 CHECK (VALUE > 10)

ALTER TABLE PREDMET (PNOM INTEGER NOT NULL PRIMARY KEY, PNAME VARCHAR(15), VNOM INTEGER, CONSTRAINT FK_PREDMET_1 FOREIGN KEY (VNOM) REFERENCES VYKLAD (VNOM), GOD INTEGER CHECK(GOD>0));

CREATE TABLE PREDMET (PNOM INTEGER NOT NULL PRIMARY KEY, PNAME VARCHAR(15), VNOM INTEGER , ONSTRAINT FK_PREDMET_1 FOREIGN KEY (VNOM) REFERENCES VYKLAD (VNOM), GOD INTEGER)

SELECT VYKLAD.VFAM, PREDMET.PNAME FROM VYKLAD INNER JOIN PREDMET ON VYKLAD.VNOM= PREDMET.PNOM

SELECT PNOM, OCINKA FROM USPISH WHERE OCINKA> (SELECT AVG(OCINKA) FROM USPISH)

SELECT AVG(OCINKA) FROM USPISH GROUP BY SNOM

SELECT VYKLAD.VFAM, PREDMET.PNAME FROM VYKLAD, PREDMET WHERE VYKLAD.VNOM= PREDMET.PNOM

SELECT STUDENTS.SFAM, USPISH.OCINKA FROM STUDENTS INNER JOIN USPISH ON STUDENTS.SNOM=USPISH.SNOM