Please answer the following p 27 2 p 3132 24 32 QUERIES FROM

3.2. QUERIES FROM A SINGLE TABLE P.21 Exercises for Section 3.2 For each query below, do the following Indicate what set is belng used as the universal set U write the SOL that would be used to retrieve the approgriate the two tables with the following felds eontaining indormatka kot leeused anven in Infractions nenID-Unique record ID Number Driver\'s ID wumber FirstName Driver\'s first name Warming Yes if a warning was and LastName Driver\'s last name Fine Amount of lae, is DOB Driver\'s date of birth Delayary Yes if the driver was lajured Yes if a 01hlnyary Yes if others were injured PropDamage Y veroperty damaged Class Class of the lieemse (A-D possible) Repeat Yes if this is a repeat offense City Driver\'s city a) List all the drivers who are over 25 and have a Claus D liomse b) List all the drivers who do not have a Class D license. c) List all the male drivers who are under 21. or Wilbrahana. d) List all the drivers who live in Springfield nor have a Clas D leesse. e) List all the drivers who neither live in Agawam Gimon 2. There are two tables with the following fields containing information for employees working CompluvlD Uwique record ID Employees EmplD Unique record ID Type Equipment type (computer, printer, etc) Employee ID Employee\'s ID number Manufacturer Manufacturer of the equipment First Name Employee\'s first name MI- Employee\'s middle initial MAC Mac address, if applicable LastName Employee\'s last name Dept Employee\'s office building Office Building Employee\'s number Office Number Employee\'s office a) List all employees whose department is Accounting, the Deake building whose department is and have an obsce in department d) ist all employees whose office located in the Marshall b the Mocounting neither in the building nor work in e) List all who work

Solution

where is page 27 and image is not so clear

i have provided anser to 31-32 pagw problem 1,2,4

1)
a)select FirstName from Drivers where class=\'D\' and Age>25;

b)select FirstName from Drivers where Class Not In(D);

c)select FirstName from Drivers where Sex=\'male\' and Age<21;

d)select FirstName from Drivers where City=\'Springfield\' or City=\'Wilbeluae\';

e)select FirstName from Drivers where City Not In(Agawarn) Union
select FirstName from Drivers where Class Not In(D);

2)a)

select FirstName from Employees where Dept=\'Accounting\';

b)select FirstName from Employees where Dept=\'Accounting\' or dept=\'Research\';

c)select FirstName from Employees where Dept=\'Reseach\' and OfficeBuilding=\'Deak Building\';

d)select FirstName from Employees where OfficeBuilding NOT IN(Marshall building);

e)select FirstName from Employees where OfficeBuilding NOT IN(Patnara building) union

select FirstName from Employees where Dept NOT IN(Accounting);

4)
a)select name from Movies where genre=\'drama\';

b)select name from Movies where year=2012 or year =2013;

c)select firstName from Actors where lastname=\'Smith\';

d)select firstName from Actors where firstname like \'J%\';

e)select name from Movies where genre not in(action) UNION

select name from Movies where year not in(2014);