carolinemcsherry / SCAD

Software Engineering Methods Coursework Assessment
Apache License 2.0
1 stars 0 forks source link

User Story 21 - As a City Administrator, I need to view all cities within my district, sorted by population from largest to smallest, to monitor population dynamics, plan public services, and address urbanization challenges effectively. #65

Closed djackson001 closed 9 months ago

djackson001 commented 9 months ago

tasks to complete Connect to the existing database. Add function to retrieve data on population Add function to retrieve data on Cities Generate report

carolinemcsherry commented 9 months ago

User Story 21 All the cities in a district organised by largest population to smallest.

select * from city where city.District = 'Zytomyr' #This will be user defind var order by city.Population desc;