Changes between Version 18 and Version 19 of ImportantUseCase2


Ignore:
Timestamp:
01/11/22 23:14:23 (3 years ago)
Author:
193288
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • ImportantUseCase2

    v18 v19  
    1515[[Image("parking1.png", 75%)]]
    1616{{{#!sql
    17   select count(Broj_na_pmesta) from Parking_mesto
     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
    1820  }}}
    1921
    … …  
    2224[[Image("parking 2.png", 75%)]]
    2325{{{#!sql
    24   select count(Broj_na_pmesta) from Parking_mesto
     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
    2528  }}}
    2629