1. select * from pogoda where miasta_id = 2 ORDER BY data_prognozy desc;
2. select id, temperatura_dzien from pogoda where cisnienie < 1000;
3. select p.data_prognozy, p.opady, m.nazwa from pogoda p, miasta m where p.miasta_id = m.id and p.temperatura_dzien > 20;
4. delete from pogoda where id = 8;