Building and organizing complex queries_Lesson 6 _Combining rows_

In the mentioned lesson when I run the code from solution. I get error like your code has timed out. I tried multiple times even after closing the browser but still getting same error.

WITH customers_usa_gt_90 AS
(
SELECT * FROM customer_usa

 INTERSECT

 SELECT * FROM customer_gt_90_dollars
)

SELECT
e.first_name || " " || e.last_name employee_name,
COUNT(c.customer_id) customers_usa_gt_90
FROM employee e
LEFT JOIN customers_usa_gt_90 c ON c.support_rep_id = e.employee_id
WHERE e.title = ‘Sales Support Agent’
GROUP BY 1 ORDER BY 1;

1 Like

Hi there @amjad21khan! Sorry you’re experiencing this!

This will be forwarded to @Sahil.

The mission link: https://app.dataquest.io/m/190/building-and-organizing-complex-queries/6/combining-rows-using-intersect-and-except

1 Like

I typed the entire code from solution but the moment I hit run … the connection status turns RED again.

1 Like

Hi @amjad21khan,

Thank you so much for reporting this issue to us. Our engineering team has fixed this issue.

Best,
Sahil