问个关于sql查询表达式的问题

Question

我的查询语句是：SELECT *, [chinese] + [math] + [english] + [history] + [physical] AS tot, <FONT color=#ff0000><STRONG>([chinese] + [math] + [english])/3 AS stuavg</STRONG></FONT>&nbsp; FROM [stureport] ORDER BY [id]，用的是access 2003数据库，我想使 stuavg字段得出来的数字都保留两位小数，查询表达式应该怎么写（chinese,math,english字段都是number型）。

Answer 1

ROUND(([chinese] + [math] + [english])/3,2) AS stuavg