Advertisement
Guest User

Untitled

a guest
Nov 21st, 2019
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. 1)
  2. INSERT INTO Osoby
  3. (1, N'Paul', N'Erodos', M,)
  4. INsert INTO Obywatelstwo
  5. (1, N'Wegry')
  6.  
  7. 2)
  8. SELECT DISTINCT o.Id_Osoby, o.Imie, o.Nazwisko o.Plec, FROM
  9. Osoby o JOIN Obywatelstwo n
  10. ON o.Id_Osoby=n.Id_Osoby
  11. WHERE
  12. ((n.Kraj = 'Gruzja' AND o.Nazwisko NOT LIKE '%dze' AND o.Nazwisko NOT LIKE '%szwili') OR
  13. (n.Kraj = 'Izrael' AND o.Nazwisko = 'Cohen' AND o.Nazwisko = 'Gadol'))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement