| |
| | [No title] (Site not responding. Last check: 2007-10-25) |
 | | ================================================================================== create table benefits (ssn char(11) not null, dep_id integer not null, salary integer, manager char(11), paid_time_off integer, primary key (ssn, dep_id)); Executed Statement: create table benefits (ssn char(11) not null, dep_id integer not null, salary integer, manager char(11), paid_time_off integer, primary key (ssn, dep_id)); Execution completed successfully... |
 | | ================================================================================== (10) update benefits set salary = salary *1.10 where ssn in (select ssn from benefits, department where benefits.ssn = department.dep_manager) and salary * 1.10 |
 | | = 100000; Executed Statement: update benefits set salary = salary *1.10 where ssn in (select ssn from benefits, department where benefits.ssn = department.dep_manager) and salary * 1.10 |
| people.ucsc.edu /~tos/sqlproject1.doc (262 words) |
|