From Sole Bushbaby, 9 Months ago, written in Plain Text, viewed 129 times.
URL http://codebin.org/view/45248a14 Embed
Download Paste or View Raw
  1. SELECT st.last_name AS employee_last_name,
  2.        cl.customer_id AS all_customers
  3. FROM staff AS st
  4. LEFT OUTER JOIN client AS cl ON st.employee_id = cl.support_rep_id
  5. GROUP BY st.employee_id, all_customers
  6. ORDER BY employee_last_name, all_customers DESC;

Reply to "Untitled"

Here you can reply to the paste above