Witam. Bardzo proszę o sprawdzenie, czy dobrze wykonałem zadania, bo nie jestem pewny i ewentualne poprawienie mnie. Zadania są w załączniku.
6. SELECT Bo_Code, Bo_Title, Bo_Price FROM BOOK WHERE Bo_Type IN ('FIC','MYD','ART') ORDER BY Bo_Title;
7. SELECT Count(Bo.Code) AS Book, Avg(Bo_Price) AS AvgPrice,
Min(Bo_Price) AS MinimumPrice, Max(Bo_Price) AS MaksimumPrice FROM BOOK GROUP BY Bo_Type;
8.SELECT B_Name, B_Location, FROM BRANCH
WHERE B_Employees = (SELECT MAX(Price) from BRANCH);
9. SELECT Bo_Code, Bo_Title JOIN PUBLISHER ON BOOK.Publisher = PUBLISHER.P_Code
WHERE Book.Bo_Price <5 AND Publisher.P_City NOT IN 'NEW_YORK';
10. UPDATE BOOK INNER JOIN PUBLISHER ON BOOK.Publisher = PUBLISHER.P_Code
SET BOOK.Bo_Price = BOOK.Bo_Price*0,97 WHERE P_Name = 'Bantan Books';
11. DELETE FROM BOOK WHERE Bo_Type = 'HOR';
12. INSERT INTO AUTHOR (A_Number, A_Last ,A_First) VALUES(100, 'Wrayt', 'Robert');