odp do Ćwiczenie 2

1.
CREATE TABLE Produkt (id SMALLINT UNSIGNED, name VARCHAR(20), price NUMERIC(6,2), amount SMALLINT UNSIGNED, DATE DATE);
INSERT INTO Produkt VALUES ('5','Spodnie','100','5','2011-02-01');
INSERT INTO Produkt VALUES ('6','Bluza','60','2','2011-02-12');
2
SELECT * FROM Produkt WHERE price>25 OR amount>=5;
3.
SELECT id,name,price FROM Produkt WHERE name LIKE "%a%" AND price LIKE "%.%";
4.
SELECT name,price,amount FROM Produkt WHERE amount IN (3,4,5,6);
5.
SELECT AVG(amount) FROM Produkt WHERE price>40;
6.
SELECT id,name FROM Produkt LIMIT 0,4;
7.
SELECT SUM(amount) FROM produkt WHERE MONTH(DATE)=02;