68 456
Assignments Done
98,6%
Successfully Done
In December 2018

Databases | SQL | Oracle | MS Access Answers

Questions: 225

Free Answers by our Experts: 140

Ask Your question

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Search & Filtering

Name Region Area Population GDP
Afghanistan South Asia 652225 260000000
Albania Europe 28728 3200000 6656000000
Algeria Middle East 2400000 32900000 75012000000
Andorra Europe 468 64000
Bangladesh South Asia 143998 152600000 67144000000
United Kingdom Europe 242514 59600000 2022824000

Now based on the above table

a) Write a query that shows the name, region and population of the smallest country in each region.

b) Select the code that shows the countries with population smaller than Russia but bigger than Denmark

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)
First of all go to https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all.
This is the link to W3Schools MySQL Tryit Editor
and the sample database we are using.

Questions:
1. Write a query that lists the first name and the number of sales of each
employee including the ones that has not received any orders yet.
2. Write a query that calculates and lists the total price of each order.
3. Write a query that lists the name of each different product shipped by
Speedy Express.
How many levels of abstraction a typical database should hold
Write a SQL query for the following:

1. I need to know which of our sales reps don’t have any customers, all regions. (Hint: This is a different type of JOIN. Also, test for nulls and eliminate the managers.)

2. tell me which region managers are responsible for those sales reps who don’t have customers in all regions. Display the region ID, I can get the full name separately. (Hint: You’ll need to see the entire employee/customer list to provide this answer)
I want a list of employees in the east and west regions and I need the full region name, not just the region ID.
each bank customer can have several types of accounts and each type of account can only be owned by a customer
I am trying to figure out the formula for this question. I tried but i can't figure it out:

create a calculated field with the column label Discount Price that subtracts the Price times the Current Discount from the Price.

Construct an er diagram for a university registrar office
Submit
Privacy policy Terms and Conditions