Advertisement
Guest User

Untitled

a guest
Jan 24th, 2018
98
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.23 KB | None | 0 0
  1. SELECT count(*) FROM Sale WHERE Città = "Pisa" and Posti > 60;
  2. SELECT sum(Posti) FROM Sale WHERE Città = "Pisa";
  3. SELECT Città, count(*) FROM Sale GROUP BY Città;
  4. SELECT Città, count(*) FROM Sale WHERE Posti > 60 GROUP BY Città;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement