mySQL查询，有什么问题吗？

Question

我被要求为数据库创建一个查询，该查询是创建: 显示名字、姓氏、电子邮件和年级(文本标题)的员工列表，其中他们拥有包含“视频”一词的技能(即使员工拥有多种视频技能，每个员工也只能有一个条目)

到目前为止我已经这样做了:

SELECT Employee.FirstName, Employee.LastName, Employee.Email, Grade.Title,
FROM Employee INNER JOIN
     Grade
     ON Grade.GradeID = Employee.GradeID INNER JOIN
     EmployeeSkill
     ON EmployeeSkill.EmployeeID = Employee.EmployeeID INNER JOIN
     Skill
     ON Skill.SkillID = EmployeeSkill.SkillID
WHERE Skill.Title LIKE "%video%"

但是我不断收到 1064 错误，我不确定我做错了什么，请帮忙。

Answer 1

查询的 SELECT 部分中有一个多余的逗号

    SELECT Employee.FirstName,
           Employee.LastName,
           Employee.Email,
           Grade.Title, -- Remove the comma here 
      FROM Employee
INNER JOIN Grade
        ON Grade.GradeID = Employee.GradeID
INNER JOIN EmployeeSkill 
        ON EmployeeSkill.EmployeeID = Employee.EmployeeID 
INNER JOIN Skill 
        ON Skill.SkillID = EmployeeSkill.SkillID
     WHERE Skill.Title LIKE "%video%"