-- Zapytanie 1
SELECT imie, miot
FROM swinki
WHERE MONTH(data_ur) = 7;

-- Zapytanie 2
SELECT DISTINCT s.data_ur, s.miot, r.rasa
FROM swinki AS s
JOIN rasy AS r ON r.id = s.rasy_id
WHERE r.id = 1;

-- Zapytanie 3
SELECT imie, cena, opis
FROM swinki
WHERE rasy_id = 1;

-- Zapytanie 4
SELECT rasa
FROM rasy
ORDER BY id;
