SQL Lab 2
Please Note: This lab requires that you understand how to write queries that were given in Lab 1 and also did hands-on work writing and running those queries. If not, you should please do Lab 1 (posted in Canvas with solutions) before working on Lab 2. Your next homework is based on these two labs.
Chapters 7 and 8 in the Coronel/Rob textbook use the database for a hardware store called SaleCo. Please review the following SaleCo relational diagram –you’ll need to refer to it when writing SQL queries.

NOTES: (1) The LINE table stores data about details of each transaction. Suppose an invoice is for three different products that the customer purchased, the LINE table associated with that invoice will contain three lines with each line number listing invoice number, line number, product code, quantity of the product purchased (under LINE_UNITS column), and price of the product (under LINE_PRICE column). (2) In the PRORDUCT table, the P_QOH column indicates quantity on hand (quantity in stock) for each product; P_MIN column lists the minimum quantity, i.e., when quantity on hand gets down to this level, the product needs to be re-ordered; the P_DISCOUNT column lists price discount for the product - for example .07 would indicate a 7% discount.
QUERY #1: Display vendor code and name for vendors from the following two States: Florida (FL) and Tennessee (TN). Sort the output in ascending order of vendor name. A sample (partial) query output looks like the following – your query should generate similar but complete output.
MS Access:
SELECT v_code as [Vendor Code], v_name as [Vendor Name]
FROM VENDOR
WHERE v_state = 'FL' OR v_state = 'TN';

MySQL:

QUERY #2: Display product code, price, and dollar amount of discount on each product. The P_PRICE column in the PRODUCT table contains base price of the product and P_DISCOUNT column contains percent