Advertisement
Guest User

Untitled

a guest
Nov 14th, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.61 KB | None | 0 0
  1. 3
  2. 1)SELECT * FROM `auta` WHERE marka='Ford'
  3. 2)SELECT * FROM `auta` WHERE idauta BETWEEN 2 AND 4
  4. 3)SELECT * FROM `klienci` WHERE miasto='Katowice' AND adres='%Rolna%'
  5. 4)SELECT marka,model FROM auta ORDER BY ubezpieczenie DESC LIMIT 1
  6. 5)SELECT marka,model FROM auta WHERE idauta IN (SELECT idauta FROM wypozyczenia ORDER BY datawyp ASC) LIMIT 1
  7. 6)SELECT imie,nazwisko FROM klienci WHERE idklienta IN (SELECT idklienta FROM wypozyczenia WHERE idauta ='1')
  8. 7)SELECT marka,model FROM auta WHERE idauta IN (SELECT idauta FROM wypozyczenia WHERE idklienta IN( SELECT idklienta FROM klienci WHERE nazwisko = 'Pastewniak') )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement