SELECI shipped_date, DATE_FORMAT(DATE_ADD(shipped_date. INTERVAL 2 MONTHS). '%c/ %e / %') AS '2 months after shipped FROM cust_order: Error Code: 1064. 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 'MONTHS), '%c/%e/%Y') AS '2 months after shipped' FROM cust_order' at line 1 It should read INTERVAL 2 MONTH, without the 'S' on month It should read INTERVALS 2 MONTHS, with the 's on interval There should not be a comma after MONTHS) The data string pattern is not valid Question 11 SELECI shipped_date, DATE_FORMAT(DATE_ADD (shipped_date, INTERVAL 2 MONTH), % / %e / %yD AS '2 months after shipped FROM cust_order; Error Code: 1064. 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 '%c/%e/%y) AS '2 months after shipped' FROM cust_order' at line 1 You need quotes around the format strings You can't have slashes in the date format string You can't have numbers in an alias %c is not a valid date format string Question 12 "Year 2016 SELECT LEFT (product_name, LOCATE('2016', product_name, 1)) AS FROM product ORDER BY product_name WHERE product_name LIKE '%girl%' LIMIT 14; Error Code: 1064. 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 'WHERE product_name LIKE '%girl%' LIMIT 14' at line 4 You can't use two '%' wildcards in LIKE WHERE is spelled wrong The wild card is used with REGEXP not LIKE WHERE clause needs to be placed before ORDER BY clause Question 13 'Year 2016 SELECT product_name FROM product SELECT LEFT (product_name, LOCATE('2016', product_name, 1)) AS FROM product WHERE product_name LIKE '%girl%' ORDER BY product_name LIMIT 14; Error Code: 1064. 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 'SELECT LEFT (product_name, LOCATE('2016', product_name, 1)) AS 'Year 2016' FROM ' at line 4 LEFT is in the wrong place SELECT should not be capitalized The semicolon to end the query before it is missing LEFT has the wrong number of parameters Question 14 'Year 2016 SELECT product_name FROM product; SELECT LEFT (product_name, LOCATE('2016', product_name, 1)) AS FROM product WHERE product_name LIKE '%girl%' ORDER BY product_name LIMIT 14; Error Code: 1146. Table 'art.product' doesn't exist You reversed the table and column name You are using the wrong database OFROM should be before SELECT You misspelled product