单选题 已知有关系“STUDENT”,则关系运算σANE<80(STUDENT)用SQL语句表示为 (52)

A. SELECT( * )FROM STUDENT WHERE AVE < 80
B. SELECT( * ) FROM STUDENT HAVING AVE < 80
C. SELECT(AVE. FROM STUDENT WHERE AVE < 80
D. SELECT(AVE) FROM STUDENT HAVING AVE < 80
【正确答案】 A
【答案解析】[解析] σAVE<80(STUDENT)表示将关系 STUDENT中满足条件“AVE<80”的元组选择出来。