Zadania SELECT

-- SELECT * FROM Samochody order by rocznik desc, spalanie asc
-- SELECT * FROM samochody where marka in ('Honda','Mazda') and spalanie between 9 and 11
-- SELECT * FROM samochody where kolor='czerwony' and marka like '___%'
-- SELECT * FROM samochody where cena is not null
-- SELECT * FROM samochody where kolor in ('niebieski','zielony') and cena is not null order by marka asc, spalanie desc
-- SELECT * FROM samochody where model like '_o%'
-- UPDATE samochody SET kolor='zółty' where kolor='żółty'

-- SELECT * FROM samochody where spalanie between 5 and 10 and kolor not in ('różowy','fioletowy')
-- SELECT * FROM kierowca where imie not like '%a' and imie not in ('Kuba','Jennefer','Karen','Alice')
-- SELECT * FROM kierowca where imie like '%a' and imie in ('Jennefer','Karen','Alice') and imie not in ('Kuba')
-- SELECT * FROM samochody where marka in ('Mercedes','BMW') and spalanie>9 order by marka asc, spalanie desc
-- SELECT * FROM kierowca where miasto in ('Kraków','Łask')
-- SELECT marka, model, spalanie, kolor FROM samochody where marka in ('Ford','Fiat') and spalanie between 7 and 12
-- SELECT distinct marka FROM samochody
-- SELECT * FROM samochody where model like '__0'
-- SELECT * FROM samochody where kolor='czarny' and spalanie>10 order by spalanie desc