Use the database created using orderprocessing.sql Download orderprocessing.sqland create SQL statements for the following.

$1.$ Display a list of customer names who's orders have shipped one day after the order was placed. Your result should have $34$ rows $($Update $12/3/24$: This should be $35$ rows$)$

$2.$ Display the names of customers that have requested "FedEx Ground" for shipping. Hint: Examine the order data for this$$

$3.$ Calculate the total value of all orders placed by customers outside the USA. Round the value to the nearest dollar amount.

$4.$ Display the names of California based customers that have placed orders for products in the Vintage Cars product line. Your result will have $11$ names

$5.$ Display the total number of employees in Sales in all the offices located in USA. Your result will have $8$ rows $($You may display the total number of employees or list the employees$)$

$6.$ Display the names of the employee and their manager. The result must be sorted by Manager's last name. The names for each must be first and last names as a single value. Provide aliases for the columns. Your result will have $22$ rows.

Bonus: $[5$ points$]$

Write a series of statements that will determine if there are more sales positions in US offices or outside US

First, find the count of sales department employees in the USA. Assign that to a variable

Second,$$find the count of sales department employees outside the USA. Assign that to a variable

Compare the two resulting values and display either USA or OTHERS based on the outcome of the comparison