Sobes.tech
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