There seems to be an error with the question 1 on lab 3, where it ask a query where items.on_hand is more than or equal to 100, but if you use the equal to the answer is incorrect, so its only more than. (:

Yeah even with the provided data, the assertion somehow seems impossible. Or maybe others who got it done can elaborate. item_id|descr|on_hand|price P9|9KG PAPER|300|25.25 P12|12KG PAPER|700|49.99 P18|18KG PAPER|100|100 IRN|INK-RESIN|3|500 IWS|INK-WRSOL|5|350 CBD|CARDBOARD|47|15

Seems like you have to ignore the "(or equal to)" part so it can use 300 * 25.25

I suggest you double-check the question's wording in the lab materials to ensure there's no misunderstanding.

Was anyone still having issues? If you want to break the question down into what it is asking for each part of the SQL statement: for the SELECT part, it is asking to use one of the aggregate functions (https://www.w3schools.com/sql/sql_aggregate_functions.asp), to get two columns, one showing the smallest of all of the on_hand multiplied by the price of the item, and then the largest of the same type of calculation its FROM the items table, so nothing too fiddly there and in the WHERE section, it wants you to limit to results where the on_hand is greater than or equal to 100. remember you can do this check in one operation. Hope this helps. Adam. "Daniel Cartagena Nunez" <24*9*8*9@s*u*e*t*u*a*e*u*a*> wrote:

This question doesn't make sense, according to that data table, the correct answer (min value) is either 3*500 or 100 *100 depending the somewhat open interpretation for the question. Another way of looking at it is asking for the min total cost. The answer is in line with the latter.