There were two tables -\n1. \'Orders\' with - order_id(PK), item id, quantity, order_date [Transactional Table]\n\n2. \'Catalog\' with-item id, product group, location [Dimension Table]\n\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

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