Screen Link:
My Code:
SELECT
c.*
FROM chinook.invoice i
INNER JOIN chinook.customer c ON i.customer_id = c.customer_id
GROUP BY 1
HAVING SUM(i.total) > 90;
SELECT * FROM chinook.customer_gt_90_dollars; ```
What I expected to happen:
The code to run
What actually happened:
(sqlite3.OperationalError) table customer_gt_90_dollars already exists
[SQL: CREATE VIEW chinook.customer_gt_90_dollars AS SELECT c.* FROM chinook.invoice i INNER JOIN chinook.customer c ON i.customer_id = c.customer_id GROUP BY 1 HAVING SUM(i.total) > 90;]
(Background on this error at: http://sqlalche.me/e/e3q8)
<!--Enter other details below: -->
I saw a similar question regarding python not running despite a copy & pasted solution being used. I tried refreshing my page as suggested in that thread, to no avail.