Junior — Senior
Customers with items in their cart
livecode
Task condition
It is necessary to output a list of clients (id, email) who have at least one product in their cart table (by the amount field).
-- Table "public.carts"
-- Column | Type | Modifiers
-- -----------|-----------------------------|-----------------------------
-- sku | bigint | not null
-- country | country_enum | not null
-- customer_id| bigint |
-- amount | bigint | not null
-- updated_at | timestamp without time zone| default now()
-- Table "public.customer"
-- Column | Type | Modifiers
-- -------|-------|----------------
-- id | bigint| not null
-- email | text | not null