假定student表中有字段grade,grade代表分数,依次统计grade字段的最大值,最小值,平均值的SQL语句是
A. SELECT max(grade),min(grade),average(grade) FROM student;
B. SELECT max(grade),min(grade),avg(grade) FROM student;
C. SELECT min(grade),average(grade),max(grade) FROM student;
D. SELECT min(grade),avg(grade),max(grade) FROM student;
要查询book表中包含“计算机”的书籍情况,可以使用_____语句
A. select * from book where name like ‘计算机*’
B. select * from book where book_name like ‘计算机%’
C. select * from book where name= ‘计算机%’
D. select * from book where name like ‘%计算机%’