神奇的Access,神奇的SQL语句

sql 代码

SELECT First([考场安排].[考场]) AS 考场之First, [考场安排].[考场位置], Count([考场安排].[考场位置]) AS 考场位置之Count
FROM 考场安排
GROUP BY [考场安排].[考场位置]
ORDER BY First([考场安排].[考场]);