What is wrong with my code?  See area circled in red

 

SQL Fiddle MySQL 5.6 Build Schema View Sample Fiddle 1 Create Table employee ( 2 employee_id INTEGER NOT NULL, 3 first_name VARCHAR(30) NOT NULL, 4 last_name VARCHAR (30) NOT NULL, 5 hire_date DATE NOT NULL, 6 job_title VARCHAR(30) NOT NULL, 7 shop_id INTEGER NOT NULL, 8 PRIMARY KEY (employee_id) 9 FOREIGN KEY (shop_id) REFERENCES coffee shop (shop_id) 10 ); C Clear Edit Fullscreen" Browser > Text to DDL Run SQL Please build schema. Edit Fullscreen" [:] D [:] * You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FOREIGN KEY (shop_id) REFERENCES coffee_shop (shop_id) )' at line 9