-- Zapytanie 1
SELECT nr_kat, producent, model, sezon, cena
FROM opony
ORDER BY cena ASC
LIMIT 10;

-- Zapytanie 2
SELECT producent, model, sezon, cena
FROM opony
WHERE nr_kat = 9;

-- Zapytanie 3
SELECT z.id_zam, z.ilosc, o.model, o.cena
FROM zamowienie AS z
JOIN opony AS o ON o.nr_kat = z.nr_kat
ORDER BY RAND()
LIMIT 1;

-- Zapytanie 4
UPDATE opony
SET cena = cena * 0.75
WHERE sezon = 'letnia';
