You have been asked to create a Spring program to interact with the MySQL World Database. This Database is made up of 3 tables which represent:
- country: Information about countries of the world.
- city: Information about some of the cities in those countries.
- countrylanguage: Languages spoken in each country.
You will need to use Spring JPA to connect and communicate with the Database Along with basic CRUD operations, you will need to provide methods which answer the following:
- Which countries have no Head of State?
- What percentage of a given countries population lives in its largest city
- Which country has the most cities? How many cites does it have?
- which 5 districts have the smallest population?
- For a given country, approximately how many people speak its most popular official language?
Think carefully about the use of a service layer in your application