1. List customer name and phone number together with the customer's assigned representative's first and last name for all customers that have a representative that works in Building H.

2. List customer name and phone together with customer's customer representative's last name, first name, and department name for those customers that have an industry code of 2952, 5047, or 7379.

3. List customer name, product name, product line name, sales for last year and year to date, and percentage change of sales from last year to this year for all customer - product pairs where customer has a zip code that starts with digits '80' and product's product line includes the word 'drive' (regardless of case).

4. List vendor's name, phone, and city together with product line name, date of last meeting between the vendor and product line leadership, and the number of full days from the last meeting for those vendors and product lines that collaborate but have not had a meeting in the last five years. Limit the answer further to those vendors that are located in a city that has the word "new" (regardless of case) in their name.

5. List product name, product line name, average product cost and price, and average gross profit margin for all products that belong to a product line with the color code "Cyan" and have gross profit margin that is higher than 15%.

6. List customer name and the customer's representative's number and name for those customers whose representative works for a department the name of which includes the word "large" in it (regardless of case). Include in the answer also those employees who do not serve as customer representative for any customer.

7. List customer name, address (city, state, and zip), sum of last year's sales, and the number of separate products sold for those customers whose purchases last year were at least 80000 or the number of products purchased was at least 7.

8. List vendor number, name, and zip code for those vendors that are located in a zip code that also includes at least one customer that has an annual goal that exceeds 300000 or has an industry code that visibly ends with the digit 5. Note that CUST_INDUSTRY_CODE has the data type CHAR(6).

9. List product name, product line name, and product price for all products that have a sales price that is at least twice as high as the average sales price in the product's own product line is.

10. List product line number, and product line's last year's sales retrieved both from the product line table and the Sale Total table (in two separate columns) for those product lines where the two last year's sales figures are different.