i am working for e school project about a parking car system. Im using jsp and mysql database. I already have made the code but missing statistics.
Its the first time i have to make query about statistics so i need some help. I have this tables: Street(ID,Name,Sides) free_slots(ID, street_ID) invalid_slots(ID,slots_ID,Street_ID) and occupied_slots(ID,slots_ID,Street_ID).
I have to compute statistics about the parking slots in a specified street (% of free slots, % of occupied slots, % invalid slots).
I really need some help! Thank you