dvdrental_query.in 357 Bytes
Newer Older
haoyuz3's avatar
haoyuz3 committed
1
select address.phone from (select a.phone as phone, a.address_id as address_id from (select c.address_id as address_id from rental as r join customer as c on r.customer_id = c.customer_id and r.staff_id = 1) as first join address as a on first.address_id = a.address_id and a.city_id > 100) as second join address on second.address_id = address.address_id;