How do I write a query that gives me 2 results from the same table?
Answer provided by mustaccio in a comment:
COUNT(uniqueid) Total_Dialed_Calls, 
COUNT(CASE disposition WHEN 'ANSWERED' THEN 1 END) Total_Connected_Calls...