JUST WRITE SELECT STATEMENT IN MYSQL WORKBENCH

1- For each row in the orders table return the order_id, customer_id, and order_date. Format the order_date so that it displays like this '01/01/99'. Only include orders that don't have a ship_date.

2- Write a select statement that displays each credit card type in the orders table, only display the card type once.

3- Write a select statement that returns the customer_id, line1, line2, and phone_number columns from the addresses table for any customer located in the state of New Jersey or the city of New York. Rename the customer_id column as "NY Area Call List".

4- Write a select statement that returns the product_name and discount percent from the products table. Only return rows with a discount percent greater than or equal to 25 and less than or equal to 30. Don't use <> operators to do this.

5- Write a query that returns the 3 most expensive products in the products table as indicated by list price of the products.

6- Write a select statement that returns the product_id, the product_name, and the first 50 characters of the description from the products table.

7- Write a select statement that returns the product_id, product_name, discount_percent, and list_price columns from the products table, round the discount_percent to one decimal place and the list_price to 0 decimal places

8- Write a select statement that returns all columns from the orders table, but only returns the five newest (most recent) orders in the orders table as shown by the order_date column

9- Write a select statement that returns all columns from the addresses table for customers NOT located in Colorado, California, or Oregon. Use the IN operator to accomplish this

10- List all of the orders in the orders table. Only list orders that have a card type of Visa, a tax amount of 0, and a shipping amount of 5.00 or less

11- Use the REGEXP operator to return all columns and all rows from the addresses table where the street address (line1) column ends in 'Rd.'

12- List only the orders in the orders table that have not been shipped as indicated in the ship_date column.