Changes between Version 24 and Version 25 of ImportantUseCase2


Ignore:
Timestamp:
01/25/22 11:17:28 (3 years ago)
Author:
193288
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ImportantUseCase2

    v24 v25  
    1515[[Image("parking1.png", 75%)]]
    1616{{{#!sql
    17   select I.lokacija count(p.Broj_na_pmesta) from Ime_na_parking as I,
    18   join Zona as z on I.id_ime=z.Ime_na_parking_Id_Ime,
    19   join Parking_mesto as p on z.Id_zona=p.IdZona
     17  select I.lokacija, count (p.broj_na_pmesta) from Ime_na_parking as I
     18  join zona as z on I.id_ime=z.Ime_na_parking_Id_Ime
     19  join parking_mesto as p on z.Id_zona=p.IdZona
     20  group by I.lokacija
    2021  }}}
    2122
    … …  
    2425[[Image("parking 2.png", 75%)]]
    2526{{{#!sql
    26   select z.Id_zona  count(p.Broj_na_pmesta) from Zona as z,
    27   join Parking_mesto as p on z.Id_zona=p.IdZona
     27    select z.Id_zona,  count(p.broj_na_pmesta) from zona as z
     28  join parking_mesto as p on z.Id_zona=p.IdZona
     29  group by z.id_zona
    2830  }}}
    2931