SQLTeam.com | Weblogs | Forums

Finding the Average Salaries for Each Employee's Gender

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

This language will be PostgreSQL here.

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.