Using the tables at the bottom, create a query to answer each question. Use the template found in this week's supporting PowerPoints to submit your responses.

Questions:

1. Display the count of employees from the empinfo table

2. Display the average age of employees from the empinfo table

3. Display the sum of salaries from the empsal table

4. Display the minimum age from the empinfo table

5. Display the maximum salary from the empsal table

6. Display the count of employees who are greater than 35 years old

7. Display the highest total compensation (salary + bonus) for an employee (hint: see page 455)

Sample Table: empinfo
first	last	id	age	city	state
John	Jones	99980	45	Payson	Arizona
Mary	Jones	99982	25	Payson	Arizona
Eric	Edwards	88232	32	San Diego	California
Mary Ann	Edwards	88233	32	Phoenix	Arizona
Ginger	Howell	98002	42	Cottonwood	Arizona
Sebastian	Smith	92001	23	Gila Bend	Arizona
Gus	Gray	22322	35	Bagdad	Arizona
Mary Ann	May	32326	52	Tucson	Arizona
Erica	Williams	32327	60	Show Low	Arizona
Leroy	Brown	32380	22	Pinetop	Arizona
Elroy	Cleaver	32382	22	Globe	Arizona
Sample Table: empsal
id	suprvsr	salary	bonus	bonus amt	office
99980	92001	45600	Y	3000	Arizona
99982	92001	47000	Y	3000	Arizona
88232	92001	52500	N		California
88233	92001	49300	Y	3000	Arizona
98002	92001	52200	Y	3000	Arizona
92001	88888	65000	Y	5000	California
22322	32380	46800	Y	3000	Arizona
32326	32380	50900	N		Arizona
32327	32380	48300	Y	3000	Arizona
32380	32380	53400	Y	3000	Arizona
32382	32380	55600	Y	3000	Arizona