Finding the Average Salaries for Each Employee's Gender

1

image
image1808×297 43.1 KB

2

I am not sure how to join specific columns from two tables together

3

This language will be PostgreSQL here.

4

I have to join the two genders ( 'F' & 'M' ) from gender column of employees table with the
average of salary column from salaries for each gender.