多项选择题
关系模式如下:Product(maker,model,type)PC(model,speed,ram,hd,price)Printer(model,color,type,price)Laptop(model,speed,ram,hd,price)用SQL表达查询所有彩色激光打印机的型号,下面的表达形式正确的是( )。
A.SELECT modelFROM printerWHERE color=”T” and type=“jet”.
B.SELECT modelFROM printerWHERE color=”T” INTERSECTION SELECT modelFROM printerWHERE type=“jet”
C.SELECT modelFROM printerWHERE color=”T” UNION SELECT modelFROM printerWHERE type=“jet
D.SELECT modelFROM printerWHERE color=”T” OR type=“jet