数据库系统念第三章答案.pptVIP

3 SQL 3-8 a. Select count(*) from license a Where exists(select 1 from owns b,person c where a.car=b.license and b.driver_id=c.drive_id and =‘John Smith’) b. Update license set damage_amount=3000 where report_number=‘AR2197’ and car=‘AABB2000’ 3-9 a. select employee_name from works where company_name=‘First Bank Corporation’ b. select a.employee_name,b.employee_name from employee a,employee b where a.city=b.city and exists( select 1 from works c,works d, company e,company f where a.employee_name=c.employee_name and b.employee_name=d.employee_name and pany_name=pany_name and pany_name=pany_n