LASTNAME FIRSTNAME AREACODE PHONE ST ZIP

--------------- ---------------- -------- -------- -- ------

BUNDY AL 100 555-1111 IL 22333

MEZA AL 200 555-2222 UK

MERRICK BUD 300 555-6666 CO 80212

MAST JD 381 555-6767 LA 23456

BULHER FERRIS 345 555-3223 IL 23332

PERKINS ALTON 911 555-3116 CA 95633

BOSS SIR 204 555-2345 CT 95633

1 Given two tables (PART1 and PART2) containing columns named PARTNO, how would you find out which part numbers are in both tables? Write the query.

Use the INTERSECT. Remember that INTERSECT returns rows common to both queries.

2 What shorthand could you use instead of WHERE a >= 10 AND a <=30?

3 What will this query return?

SELECT FIRSTNAME

FROM FRIENDS

WHERE FIRSTNAME = 'AL'

AND LASTNAME = 'BULHER';

4 Using the FRIENDS table, write a query that returns the following:

NAME PHONE

-------------------------- ------------

MERRICK, BUD 300-555-6666

MAST, JD 381-555-6767

BULHER, FERRIS 345-555-3223