<h3>SQL Queries</h3>
Assuming your "Equipment" Table has the following attributes:
-product_name
-unit_price
-units_on_order
-units_in_stock
And Your "Customer" table has the following attributes:
-first_name
-last_name
-city
-state
<h3>A - </h3>
Solution: Select product_name,unit_price from Equipment where unit_price<50
Explanation: Select product name, unit price from table Equipment where unit price value is less than $50
<h3>B - </h3>
Solution: Select product_name, units_on_order, units_in_stock from Equipment where units_on_order>=0.4*units_in_stock
Explanation: Select product name, unit on order and units in stock from table Equipment where unit on order is greater or equal to 40% of units in stock
<h3>C - </h3>
Solution: Select product_name, units_on_order, units_in_stock from Equipment where units_on_order>=0.4*units_in_stock and units_on_order<=10
Explanation: Select product name, unit on order and units in stock from table Equipment where unit on order is greater or equal to 40% of units in stock as well as units on order is less than or equal to 10 (atmost 10)
<h3>D - </h3>
Solution: Select first_name,last_name,city,state from Customer where state not in("NJ")
Explanation: select first name,last name,city,state from table Customer where state is not present in the following list ("NJ") i.e. New Jersey
<h3>E - </h3>
Solution: Select first_name,last_name,city,state from Customer where state not in("NJ") or first_name="Robert"
Explanation: select first name,last name,city,state from table Customer where state is not present in the following list ("NJ") i.e. New Jersey or first name is Robert
Learn more about SQL: brainly.com/question/25694408
#SPJ4
