DATABASE LAB #2
 
WRITING SIMPLE QUERIES

Write the following queries using the QUERY option in ACCESS. 

1. List all the males.

2. List all the females.

3. List all persons from KY or from MI.

4. List all the females making more than $30,000. 

5. List all the males making less than $20,000.00.

6. List all the males not from MI.

7. List all the male mathematicians. 

8. List all the females from MI making more than $30,000.00.

Copy and paste into Word the results of each query. In addition, copy and paste each SQL 
statement for each of the queries. Your printouts should look like:

1.  List all the males.

(place the Acopy and pasted@ SQL query for this query here-- e.g., 
SELECT LASTNAME, FIRSTNAME, GENDER, AGE, SALARY
FROM EMPLOYEE
WHERE GENDER = AM@)

(place the Acopy and pasted@ results for the query here)

2.  List all the females

place query here

place answers here

3.  (continue process).

 Turn in the printout with a proper cover sheet.