单项选择题
A.select sum(profit)from profits where region in (select region froms regions where reg_head in (‘SMITHERS’,‘FUJMORI’,‘LAKKARAJU’))and product =’TOYS’;
B.select sum(profit)from profits where region like (select region froms regions where reg_head in (‘SMITHERS’,‘FUJMORI’,‘LAKKARAJU’)and product =’TOYS’);
C.select sum(profit)from profits where region =(select region froms regions where reg_head in (‘SMITHERS’,‘FUJMORI’,‘LAKKARAJU’))and product =’TOYS’;
D.select sum(profit)from profits where region is (select region froms regions where reg_head in (‘SMITHERS’,‘FUJMORI’,‘LAKKARAJU’))and product =’TOYS’;