Advertisement
Guest User

Untitled

a guest
Nov 18th, 2017
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.23 KB | None | 0 0
  1. SELECT COUNT(o.id_osoby) AS [liczba mieszkańców], w.kod_woj AS [kod województwa],w.nazwa [nazwa województwa]
  2. FROM woj w JOIN miasta m ON w.kod_woj=m.kod_woj
  3. JOIN osoby o ON o.id_miasta =m.id_miasta
  4. GROUP BY w.kod_woj, w.nazwa
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement