Reference no: EM132231485
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
Sample Table empinfo
furst 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 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 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 Y 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