Question: Q10. In the table below, using database statistical functions, count all the female engineers, calculate their average salary, and list the oldest and the youngest
Q10. In the table below, using database statistical functions, count all the female engineers, calculate their average salary, and list the oldest and the youngest in four separate rows of the worksheet.
| FIRST NAME | LAST NAME | AGE | GENDER | OCCUPATION | INCOME |
| Randy | Smith | 55 | M | Professor | $90,000 |
| Fay | Brown | 22 | F | Engineer | $75,000 |
| Adam | Mills | 37 | M | Engineer | $55,000 |
| Andrea | Harris | 29 | F | Teacher | $31,000 |
| Moe | Santos | 44 | M | Officer | $49,000 |
| Bob | Sakas | 39 | M | Engineer | $72,000 |
| Vicki | Hashim | 22 | F | Teacher | $34,000 |
| Paula | Schlosser | 66 | F | Nurse | $56,000 |
| Jack | Negrete | 51 | M | Artist | $32,000 |
| Mary | Fisher | 27 | F | Teacher | $33,000 |
| Sue | Hayward | 26 | F | Engineer | $61,000 |
| Jacky | Chipres | 77 | F | Engineer | $52,000 |
| Lora | Heredia | 26 | F | Nurse | $48,000 |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
