Answer to Question #83362 in Databases | SQL | Oracle | MS Access for Nicole Baker

Question

Write the queries that will do the following:

1. Select the top 10 countries with the most number of ip blocks allocated to it and the number of address blocks in it. Order if from greatest to least.

2. Select the top 10 cities with the most number of ip blocks in the united states and the number of address blocks in it. Order it from greatest to least.

3. Select the cities in the united states that have between 4,000 - 5,000 ip address blocks ordered from least to greatest.

4. Select the average number of ip blocks that would be found in a city for each state. Order it by state from least to greatest or A-Z.

The relational tables are below:

Countries
id(pk)
name
code

CityByCountry
city(pk)
country(fk pointing to id in countries table)
name
state

ip4
ip
country(fk pointing to id in countries table)
city(fk pointing to city in CityByCountry table)

Answer 1

Dear Nicole Baker, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order