Sobes.tech
Junior — Senior

SQL query: users who added products 101 and 102 but not 104

livecode

Task condition

It is necessary to obtain a list of unique user identifiers who, in their actions, added products with identifiers 101 and 102 to the cart, but did not add a product with identifier 104.


Data and description:
Table stage.lo_events with fields:
user_id - user ID
event_name - event name
 view_item - view product
 add_to_cart - add product to cart
event_datetime - event time
product_id - product ID
order_type - order method (delivery / pickup)