Answered You can hire a professional tutor to get the answer.

QUESTION

I need the SQL commands for Microsoft Access 2016. What is the total import and export in each continent in 2016?

I need the SQL commands for Microsoft Access 2016.

  1. What is the total import and export in each continent in 2016? Please display the continent name as well as the total import and total export in two queries. 
  2. List the top 10 countries (CountryName) with highest total import and total export, respectively, from 2000 to 2016 (including 2000 and 2016).
  3. What is the total trade (Import + Export) between US and each country since 1985? Please display the country name as well as the total trade in the query. 
  4. List the bottom 5 countries (CountryName) with lowest total import in Asia. Also, the country must have been in trade with US for over 10 years.
  5. What is the trade deficit in each year for China, Mexico and Canada? Please display the year as well as the total trade in the three queries.
Show more
LEARN MORE EFFECTIVELY AND GET BETTER GRADES!
Ask a Question