WHTS IS THE query

Use the Pine Valley database to answer the following questions:

What products lines does Pine Valley sell?

Where are the Pine Valley work centers located?

List the names and address of employees. Order them by state.

List the details of employees whose names begin with an L.

List states where customers of PVFC live in?

List the details of customers who live in CA, TX or CO. Order them by state and name

List the customer ID, Name and Zipcode for customers who live in California or Washington. Order them by zipcode, from high to low.

List the MaterialID, MaterialName, Material, MaterialStandardPrice, and Thickness for all raw materials made of cherry, pine, or walnut. Order the listing by Material, Thickness and StandardPrice.

List all payments which range from $2500 to $3000

List the vendorid, unitprice and cost of 100 units in a new column named costunits100 from the supplies_t table for materialids starting with ADH.