Question

You need to generate a report that displays the IDs or all products in the COSTS table whose unit
han the unit cost. The details should be displayed in the descending order of 25% of the unit cos
query:

Answer 1

SELECT prod_id
FROM costs
    WHERE unit_price >= unit_cost*1.25
    ORDER BY unit_cost*0.25 DESC;