A 4-table relational rideshare database analysis using multi-table JOINs, LEFT JOIN chaining, and CTEs to prevent fan-out and optimize driver supply.