-- Zapytanie 1
SELECT MIN(priorytet) AS najnizszy_priorytet
FROM notatki
WHERE Osoby_id = 3;

-- Zapytanie 2
SELECT nazwa, priorytet
FROM notatki
WHERE nazwa LIKE '%na%';

-- Zapytanie 3
SELECT o.imie, n.nazwa
FROM notatki AS n
JOIN osoby AS o ON o.id = n.Osoby_id
WHERE n.priorytet = 5;

-- Zapytanie 4
SELECT o.imie, COUNT(n.id) AS liczba_notatek
FROM notatki AS n
JOIN osoby AS o ON o.id = n.Osoby_id
GROUP BY o.imie;
