Database: advertising_agencies
Question: What are the agency ids and agency details for all agencies who have a client?
SQL:
SELECT T1.agency_id ,  T1.agency_details FROM Agencies AS T1 JOIN Clients AS T2 ON T1.agency_id  =  T2.agency_id