Why is this answer not accepted?

Q&A
#1

Screen Link:

My Code: 

WITH customer_usa_gt_90 AS(
SELECT * FROM customer_usa
    INTERSECT
SELECT * FROM customer_gt_90_dollars)

SELECT e.last_name || ' ' || e.first_name AS employee_name, COUNT(c.customer_id) customer_usa_gt_90
FROM employee e
LEFT JOIN customer_usa_gt_90 c  ON e.employee_id = c.support_rep_id
WHERE e.title = 'Sales Support Agent'
GROUP BY e.employee_id
ORDER BY employee_name DESC

What I expected to happen:

What actually happened:

Replace this line with the output/error
1 Like
#2

I guess you have not put a semi-colon at the end. Try this.

Other than that, if there is problem in the code then kindly provide the screen link?