Answered You can hire a professional tutor to get the answer.
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.
- 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.
- List the top 10 countries (CountryName) with highest total import and total export, respectively, from 2000 to 2016 (including 2000 and 2016).
- 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.
- 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.
- 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.