Hi,

You are correct, the question appears to be flawed, and includes a situation that could not happen, but adjusting at this stage may cause everyone who attempted and got it right to have to re-do it at this late stage. the answer is still achievable though, but just doesn't work as intended.

A better question would have been:

Find the item_ids that are either 'INK-RESIN' (IRN) or 'INK-WRSOL' (IWS) from the po_orders table, but exclude any items that are also present in the po_deliveries table. Use UNION and EXCEPT operations to filter the results.

Thanks, Adam.

ANONYMOUS wrote:

I am having trouble to understand the questions too. In particular, the second part.

In the given data (po_items), IRN appears on the two rows as below:

004/CCC/IRN/4 006/GGG/IRN/2

and IWS appears on one row as below:

002/AAA/IWS/2

In which situation, both item_ids (IRN and IWS) appear in the po_items table? Can anyone please give an example?

Thanks.