Daily cancellation rate excluding banned users

Tables:

users(id int primary key, banned boolean)

trips(id int primary key, client_id int, driver_id int, status text, request_at date)

status is 'completed', 'cancelled_by_driver' or 'cancelled_by_client'. client_id and driver_id refer to users.id.

For each day, return the cancellation rate: cancelled trips divided by all trips, rounded to 2 decimals. Only count trips where both the client and the driver are not banned. Days with no counted trips are not listed.

Output columns: day, cancellation_rate.

CREATE TABLE users (
  id int PRIMARY KEY,
  banned boolean NOT NULL
);
CREATE TABLE trips (
  id int PRIMARY KEY,
  client_id int NOT NULL,
  driver_id int NOT NULL,
  status text NOT NULL,
  request_at date NOT NULL
);