java - SQLite 平均分

Question

PreStatement = myConnection.prepareStatement(""
                        + "SELECT Game1.AVG(Score),Students.FirstName,Students.LastName "
                        + "FROM Game1 " 
                        + "INNER JOIN Students " 
                        + "ON Game1.StudentID = Students.StudentID " 
                        + "ORDER BY Students.FirstName ASC;");

这不起作用。 (错误肯定是AVG分数部分)
但这确实如此。

PreStatement = myConnection.prepareStatement(""
                        + "SELECT AVG(Score),
                        + "FROM Game1 " 

我是否做错了什么，或者我是否需要做两个陈述才能得到我的平均分数。

Answer 1

试试这个。

PreStatement = myConnection.prepareStatement(""
                        + "SELECT AVG(Game1.Score),Students.FirstName,Students.LastName "
                        + "FROM Game1 " 
                        + "INNER JOIN Students " 
                        + "ON Game1.StudentID = Students.StudentID " 
                        + "ORDER BY Students.FirstName ASC;");