Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT count(*) FROM Sale WHERE Città = "Pisa" and Posti > 60;
- SELECT sum(Posti) FROM Sale WHERE Città = "Pisa";
- SELECT Città, count(*) FROM Sale GROUP BY Città;
- SELECT Città, count(*) FROM Sale WHERE Posti > 60 GROUP BY Città;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement