(b) Calculate Alvaro Pelorus’s capital gains tax liability for the tax year 2006／07 on the

Examine the structures of the EMPLOYEES and TAX tables.EMPLOYEESEMPLOYEE_ID NUMBER NOT NULL, PrimaryKeyEMP_NAME VARCHAR2 (30)JOB_ID VARCHAR2 (20)SALARY NUMBERReferencesMGR_ID NUMBEREMPLOYEE_IDcolumnDEPARTMENT_ID NUMBER Foreign key toDEPARTMENT _IDcolumn of theDEPARTMENT tableTAXMIN_SALARY NUMBERMAX_SALARY NUMBERTAX_PERCENT NUMBERPercentage tax for givensalary rangeYou need to find the percentage tax applicable for each employee. Which SQL statement would you use?（）

A. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary BETWEEN t.min _ salary AND t.max_salary

B. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE e.salary > t.min_salary, tax_percent

C. SELECT employee_id, salary, tax_percent FROM employees e, tax t WHERE MIN(e.salary) = t.min_salary AND MAX(e.salary) = t.max_salary

D. You cannot find the information because there is no common column between the two tables.

A．错误

B．正确

A.which

B.that

C.what

As early as 1647 Ohio made a decision that free, tax-supported schools must be established in every town __________ 50 households or more.

A) having B) to have

C) to have had D) having had

如下程序的输出结果是______。

include＜iostream＞

using namespace std；

class Wages{ //“工资”类

double base； //基本工资

double bonus； //奖金

double tax； //税金

public：

Wages(double CBase，double CBonus，doable CTax)：

base(CBase)，bonus(CBonus)，tax(CTax){ }

double getPay( )const； //返回应付工资额

Wages operator+(Wages w)cons[； //重载加法

}；

double Wages::getPay( )cons[{return base+bonus-tax；}

Wages Wages::operator+(Wages w)const{return Wages(base+w．base，bonus+w．bonus，tax+w．tax)；}

int main( ){

Wages wl(2000，500，100)，w2(5000，1000，300)；

eout＜＜(wl+w2)．getPay( )＜＜endl；

return 0；

}