Part $2$ Create the Following SQL Statements

$1.$ Show a list of customers and the orders they generated during $2014.$ Display customer ID$,$ order ID$,$ order date and date ordered.

$2.$ Using the ALTER TABLE statement, add a new field $($Active$)$ in the tblcustomer. Default it to True.

$3.$ Show all orders purchased before September $1,2012.$ Display company name, date ordered and total amount of order $($include freight$).$