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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!