With reference to the data in below two tables:

Table: Order

OrderID CustomerID EmployeeID OrderDate ShipperID

10308 2 7 1996-09-18 3

10309 37 3 1996-09-19 1

10310 77 8 1996-09-20 2

10319 21 11 1998-09-20 2

Table: Customer

CustomerID CustomerName

3 Ann Kooi

7 Adams Smith

8 Charlie Anthony

Write SQL (use INNER join) to display only Order.OrderId and Customer.CustomerName

Write SQL to display all Orders from Order table even if the corresponding customer rows are not found.

Write SQL to obtain count of total number of rows where OrderDate is older than year 1997.

Write SQL to obtain the row containing the latest order date.

Write a query to update Ann Kooi name to Ann Cooi

Write a query to split CustomerName on First Name and Last Name using the space

Write a query to display CustomerName firstname only. (Eg. Ann, Adams and Charlie)

Note: Please show all the steps and explain all answer