Part A: WORLD (CountryName (text), Continent

Part A:
WORLD (CountryName (text), Continent (text), Area (number), Population (number), GDP (number))

Write an SQL statement allowing you to list the countries and their per capita GDP levels, rounded to 2 decimal places, sorted by per capita GDP in descending order (i.e. the richest, per person, first).

Part B
ITEMS_ORDERED (CustomerID (number), OrderDate (date), ItemName (text), Quantity (number), Price (number))

CUSTOMERS (CustomerID (number), CustomerName (text), CustomerPhone (text), CustomerState (text))

Write an SQL statement allowing you to display states and total quantities sold of each item in each state, ordered by state, by quantity sold (descending).

Part C:
Create an SQL Server database to hold information about a book collection. The tables should include at least the following:

Table
Book:
info should include title, author(s), subject(s), publisher
Author:
Publisher:
Subject:

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.