There were two tables -\n\'Orders\' with - order_id(PK), item id, quantity, order_date [Transactional Table]\n\'Catalog\' with-item id, product group, location [Dimension Table]\nThey asked to write a SQL code that will return the product groups of US that has no sale in any unit(i.e all the item id from an individual product group has no sale).\n\nI know i can join on item id here but in my interview, location was present in orders table also. It was like an item \'A22\' is present in US , UK & Japan in catalog table and present in couple of countries in Orders. In such case , do i need to put join as composite join(inclusive of location as well as item id because item-id alone won\'t make any sense as it can be present in multiple locations).\n\nDid someone else came across this problem? Please help.

There were two tables -\n\'Orders\' with - order_id(PK), item id, quantity, order_date [Transactional Table]\n\'Catalog\' with-item id, product group, location 