1.1
-----------------------------
CREATE OR REPLACE TRIGGER izbrisi_ulogi
BEFORE DELETE ON vraboteni
FOR EACH ROW
BEGIN
    DELETE FROM Ulogi WHERE v = :old.v;
END;



1.2
------------------------------
SELECT COUNT(*)
FROM (SELECT *
	FROM Vraboteni
	JOIN Ulogi ON Vraboteni.v = Ulogi.v
     )
WHERE imev='Tana Mimeska'


1.3
------------------------------
DELETE
FROM Vraboteni
WHERE imev='Tana Mimeska'



2.1
-------------------------
ALTER TABLE Teatri
ADD VkupnoPretstavi int




2.2
-----------------------------
UPDATE Teatri SET VkupnoPretstavi=(
			SELECT COUNT(DISTINCT Bileti.p)
			FROM Bileti
			WHERE Teatri.t = Bileti.t)



2.3
----------------------------
CREATE OR REPLACE TRIGGER update_vkupno_pretstavi
AFTER INSERT OR DELETE ON Bileti
FOR EACH ROW
BEGIN
	UPDATE Teatri SET VkupnoPretstavi=(SELECT COUNT(DISTINCT Bileti.p)
				 FROM Bileti WHERE Teatri.t = Bileti.t);
END;




2.3
------------------------
INSERT INTO Bileti(t, p, status, scena, cena, prodadeni)
	    VALUES('14', '43', 'gostuva', 'golema_scena', '150', '200')




2.4
------------------------
DELETE FROM Bileti WHERE t=15 AND p=27;





DOPOLNITELNO 2
--------------------
ALTER TABLE Orders
ADD VkupnoProizvodi int


CREATE OR REPLACE TRIGGER update_vkupno_proizvodi
AFTER INSERT OR DELETE ON OrderDetails
FOR EACH ROW
BEGIN
	UPDATE Orders
        SET vkupnoProizvodi=(SELECT SUM(OrderDetails.quantity)
			     FROM OrderDetails
                             WHERE Orders.orderid = OrderDetails.orderid);
END;



DOPOLNITELNO 1
--------------------
CREATE OR REPLACE TRIGGER save_order_data
AFTER DELETE ON Consultants
FOR EACH ROW
BEGIN
	INSERT INTO ORDERDETAILSDELETED
        SELECT *
        FROM ORDERDETAILS
        WHERE (SELECT DISTINCT ORDERID
               FROM ORDERS
               WHERE Consultant.CONSULTANTID = Orders.CONSULTANTID)
        LIKE ORDERDETAIls.ORDERID
END;