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)