SQL Arena
#1141

Abandoned carts

Find users who added an item to the cart (kind = cart) but never made a purchase (kind = purchase). Return user_id ascending, without duplicates.

Expected output sample

This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables.

user_id
2
Sign in to submit

Your query result will appear here