Open the MySQL Workbench, and use File$-->$Run SQL script. Navigate to this file on your computer and execute this file. See demonstration from class recording

Answer the following questions using relevant SQL syntax.$$

$1.$ Write a SQL statement that displays the customer name, order number, order date and status for all orders that do NOT have the status 'Shipped'. You must include aliases for each column so that the column name does not get displayed

$2.$ Write a SQL statement that displays customer name, order number, order date and the total value of the order for all orders that have been shipped and where the total value of the order is less than $$10000.($Hint: there can be multiple line items order in the orderdetails table$).$ You must also include aliases to be displayed for each of the columns.$$

$3.$ Write a SQL statement that displays the unique list of product names and the productLine it belongs to that have been purchased by a customer across all orders that have not been shipped. Use an alias for the column name that will be displayed in the result set.

$4.$ Write a SQL statement that displays the distinct list of customer names who placed an order in March $2003$

$5.$ Write a SQL statement that calculates the total sales for each year for all orders which have a status of Shipped

Copy all your queries into a text file called queries.sql