Consider the following relational schema and SQL query. The schema captures

information about employees, departments, and company finances.

Emp$($eid$,$ did, salary, category$)$

did, dname, floor, phone$)$

Finance$($did$,$ budget, sales, expenses$)$

Consider the following query:

SELECT D$.$dname, F$.$budget

FROM Emp E$,$ Dept D$,$ Finance F

WHERE E$.$did$=$D$.$did AND D$.$did$=$F$.$did AND D$.$floor$=1$

AND E$.$salary $>59000$ AND E$.$ category $={?}^{\text{'}}{A}^{\text{'}}$

Here are some statistics:

Salary range from $10,000$ to $60,000$

The attribute did in the relation Emp is foreign key.

$,$ category