SELECT * FROM pogoda WHERE miasta_id=2 ORDER BY data_prognozy DESC;

SELECT id, temperatura_dzien FROM pogoda WHERE cisnienie<1000;

SELECT data_prognozy, opady, nazwa FROM pogoda JOIN miasta ON pogoda.miasta_id=miasta.id WHERE temperatura_dzien>20;

DELETE FROM pogoda WHERE id=8;