Hello everyone ,
Why on this mission:
I write the following code:
WITH 'inter' AS ( SELECT * FROM customer_usa INTERSECT SELECT * FROM customer_gt_90_dollars ) SELECT e.first_name|| ' ' || e.last_name 'employee_name', COUNT(inter_e.customer_id) 'customers_usa_gt_90' FROM employee 'e' LEFT JOIN inter 'inter_e' ON inter_e.support_rep_id = e.employee_id GROUP BY employee_name HAVING e.title = 'Sales Support Agent' ORDER BY employee_name;
And the result is: ‘The value for result doesn’t look right.’, although the value/result is right!!
I checked it running the answer in the solution and the resuld is exactly the same as with my code. First I thought it could be because I am not using the WHERE clause but the HAVING. Changing it resulted in the same outcome: ‘The value for result doesn’t look right.’
Then I changed the name of the subquery to the same as the on the in the answer ‘customers_usa_gt_90’ but the result was still the same: ‘The value for result doesn’t look right.’
I only get the validation once I copy paste the answer proposed in the exercise! Why is that when my produces exactly the same result, exactly the same table?!?
Thanks for your help