1.Write a query that returns all UNIQUE customer IDs and contact types from the developer contact table using specific comparison operators. Use the > and < to restrict the customer ids to numbers greater than 1 and less than 4 (exclusively). Also, use the IN operator to restrict the query to return only the contact type that is equal to phone.

2.Type the command that displays the column information (name, nullable, type) for the contact table.

3. Select all customerIDs who do NOT live in San Antonio, Dallas and New Orleans and who have a nickname that is not null.

4. Select all information from the contact table that contain the LAND in the remarks. Also, include rows that have a contact type of EMAIL. Sort the columns by the 2nd column, but do not specify the column name in the ORDER BY statement.

5.Create and assign the value EMAIL to the variable ctype. Then run a query that uses this variable to select all rows in the contact table with this contact type.

6.Select all contact information data and allow the user to apply the where condition. Thus, You must prompt the user to enter a where condition such as NOT by phone or other.

7.Select all salesperson information who were hired on August 10, 2006. Your SQL must prompt the user for a sales persons lastname and firstname. When it prompts the user, you should enter Tina Smith for the first and last name.

8.Select the maximum, minimum and average wage rate of salespersons where the rate is more than 13. Also, you must prompt the user to enter the rate (e.g. 13).

9.Select customer first name and last name who has a null value in the nickname or the nickname ends with a. Also, restrict the rows to Sort the result set by customer last name descending then first name ascending.

Please I need help on this DATABASE