-- Database schema
| city : city_id [ INTEGER ] primary_key , city_name [ TEXT ] , state [ TEXT ] , population [ INTEGER ] , area [ REAL ] | customer : cust_id [ INTEGER ] primary_key , cust_name [ TEXT ] , annual_revenue [ INTEGER ] , cust_type [ TEXT ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip [ REAL ] , phone [ TEXT ] | driver : driver_id [ INTEGER ] primary_key , first_name [ TEXT ] , last_name [ TEXT ] , address [ TEXT ] , city [ TEXT ] , state [ TEXT ] , zip_code [ INTEGER ] , phone [ TEXT ] | truck : truck_id [ INTEGER ] primary_key , make [ TEXT ] , model_year [ INTEGER ] | shipment : ship_id [ INTEGER ] primary_key , cust_id [ INTEGER ] shipment.cust_id = customer.cust_id , weight [ REAL ] , truck_id [ INTEGER ] shipment.truck_id = truck.truck_id , driver_id [ INTEGER ] shipment.driver_id = driver.driver_id , city_id [ INTEGER ] shipment.city_id = city.city_id , ship_date [ TEXT ] |
-- -- What is the address of the driver that delivers the shipment for the customer lives at 7052 Carroll Road, San Diego, California?

SELECT T3.address FROM shipment AS T1 INNER JOIN customer AS T2 ON T1.cust_id = T2.cust_id INNER JOIN driver AS T3 ON T3.driver_id = T1.driver_id WHERE T2.address = '7052 Carroll Road' AND T2.city = 'San Diego' AND T2.state = 'CA';