List of couriers from Saint Petersburg with at least two incomplete orders

livecode

Task condition

Find all delivery persons working in Saint Petersburg city, for whom the number of orders with a status other than "delivered" is at least two.

CREATE TABLE deliveries (
    id INT,
    rider_id INT,
    status VARCHAR(20)
);

CREATE TABLE riders (
    id INT,
    city VARCHAR(100)
);