-- Zapytanie 1
SELECT nazwa, styl, cena FROM meble WHERE czyNowy = 1 AND cena <= 1000 ORDER BY cena;

-- Zapytanie 2
CREATE VIEW komody AS SELECT idMeble, nazwa, kategoria, cena FROM meble WHERE kategoria = 3;

-- Zapytanie 3
SELECT ROUND(AVG(cena)) AS "Średnia cena komód", MIN(cena) AS "Minimalna", MAX(cena) AS "Maksymalna" FROM komody;

-- Zapytanie 4
DELETE FROM klienci WHERE imie = 'Tomasz' AND nazwisko = 'Nowak';
