ClicktheExhibitbuttontoexaminethestructuresoftheEMPLOYEESandTAXtables. Youneedtofindthepercentagetaxapplicableforeachemployee.WhichSQLstatementwouldyouuse?()
A. SELECTemployee_id,salary,tax_percentFROMemployeeseJOINtaxtONe.salaryBETWEENt.min_salaryANDt.max_salary;
B. SELECTemployee_id,salary,tax_percentFROMemployeeseJOINtaxtWHEREe.salary>t.min_salaryAND
C. SELECTemployee_id,salary,tax_percentFROMemployeeseJOINtaxtON(MIN(e.salary)=t.min_salaryANDMAX(e.salary)=t.max_salary);
D. Youcannotfindtheinformationbecausethereisnocommoncolumnbetweenthetwotables.