MYSQL DATABASE:

1) Create two SELECT statements, one which returns product name (prod_name) from the Products table for all products priced 10 or more, and the other which returns the same information for products made by vendor id (vend_id) DLL01. Write a single statement that combines these two statements using a UNION.

2) Rewrite number 1 to use a single SELECT statement.

products table:

Columns:

prod_id	char(10) PK
vend_id	char(10)
prod_name	char(255)
prod_price	decimal(8,2)
prod_desc	text