following the Data Science Path I got stuck doing the Cumulative SQL Project at the end of the ‘SQL:Intermediate’ part. The problem occurs at task 4 with the following line of code:
CREATE TABLE inactive_patients AS (SELECT * FROM patients WHERE Status = "inactive");
which throws a syntax error near the first parenthesis. This is very confusing since the code does obey SQL syntax. Moreover, this is the same syntax as in the hint given for this task. What’s wrong here?
Here is a screenshot:
I am using an early 2011 MacBook Pro with Mac OS High Sierra and Safari 12.0.