多表查询（跨表查询不及格的学生）

SELECT dbo.B.xuehao AS 学号, dbo.A.name AS 姓名, dbo.C.fenshu AS 分数
FROM dbo.A INNER JOIN
dbo.B ON dbo.A.id = dbo.B.id INNER JOIN
dbo.C ON dbo.A.id = dbo.C.id
WHERE (dbo.C.fenshu < 60) 

要求输出学号、姓名及分数