Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.35 KB | None | 0 0
  1. select P.IdPrzystanku, count(distinct R.NrLinii), (select count(*) from TypPojazdu TP inner join Pojazd P on P.IdTypu=TP.IdTypu where
  2. TP.NAZWA_TYPU_POJAZDU='autobus' and P.NrPojazdu=R.NrPojazdu
  3.  
  4. from rozklad R inner join Przystanek P on R.IdPrzystanku=P.IdPrzystanku
  5. where R.DzienTygodnia in ('1','2','3','4','5')
  6.  
  7. group by P.IdPrzystanku
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement