Feb 18 Activity

1. SELECT customer_name, city, postal_code FROM customer_t WHERE postal_code LIKE '%20%';

2. SELECT DISTINCT state FROM customer_t;

3. SELECT customer_name 'CUSTOMER NAME', state 'CUSTOMER NAME' FROM customer_t WHERE state NOT IN ('NY', 'NJ', 'FL');

4. SELECT product_description 'PRODUCT', product_finish 'FINISH', standard_price 'PRICE' FROM product_t WHERE standard_price<500 AND product_description LIKE '%Table%';

5. SELECT product_description 'PRODUCT' FROM product_t WHERE product_description NOT LIKE '%Table%' AND product_description NOT LIKE '%Desk%';

6. SELECT CONCAT (product_description, ' - the price is ', standard_price, ', ', 700-standard_price, ' below 700') 'PRODUCT' FROM product_t where product_description NOT LIKE '%Table%' AND product_description NOT LIKE '%Desk%' AND standard_price<700;