Back to problems

How to improve complaint resolution

SQL · Wayfair · Medium

An online home-goods retailer has provided three related tables from its customer-support system. complaints complaint_id STRING customer_id STRING order_id STRING product_category STRING issue_type STRING complaint_channel STRING complaint_created_at TIMESTAMP region STRING resolutions complaint_id STRING resolution_type STRING first_response_at TIMESTAMP resolved_at TIMESTAMP agent_id STRING escalated_flag BOOLEAN refund_amount DECIMAL(10,2) replacement_sent_flag BOOLEAN…

Checking your access…