Homework:

Write a SQL statement to insert a new record into the customer table with the following information:

CustomerID $=100$

CustomerName $=$ Salem Saleem

ZipCode $=214$

Retrieve all employees whose last name is null.

Write a SQL statement to retrieve the actual order date and customer ID for all customers who ordered more than $2$ orders.

Write a SQL statement to retrieve the last names of all employees who have both an $"$a$"$ and an $"$e$"$ in their last name.

Write a SQL statement to retrieve the last name and first name for all employeesSort data in descending order of last name.

Write a SQL statement to retrieve all Ordersltems that are priced between $10$ and $50.$

Write a query to count order items for every order.

Write a query to retrieve order items when the order have more than $3$ items