Here is the definition of a view, but MySQL stubbornly does not want to compile it. Apparently, it contains some mistakes. How many syntax errors does the view definition contain?
CREATE VIEV v
BY SELECT city AS c,
SUM(status) AS ST
FROM s
GROUP AS city;