Advertisement
Guest User

Untitled

a guest
Dec 11th, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. INSERT INTO Lokalizacja (id,nazwa,adres) VALUES (3,"KATI","Katowice,Korfantego 105")
  2. SELECT id FROM Pogoda WHERE temperatura>20
  3. SELECT l.id, pr.dataProg FROM Lokalizacja AS l, prognoza AS pr, pogoda AS po WHERE pr.Lokalizacja_id=l.id AND pr.Pogoda_id=po.id AND po.Wilgotnosc>50
  4. SELECT l.Nazwa, po.id FROM Lokalizacja AS l, Pogoda AS po, Prognoza AS pr WHERE pr.Lokalizacja_id=l.id AND pr.Pogoda_id=po.id AND pr.dataProg="2015-07-02"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement