SQLTeam.com | Weblogs | Forums

Help me to write the sql query. I'm an linux admin


#1

555555
1.Write a SQL query that returns the names of workers in age, above average department:
name of the department;
the average age of workers by department;
first and last name;
the workers age.

  1. Write a SQL query that returns the number of workers with the last name green/greens in the context departments (for departmets with such workers more than one):
    the name of the unit;
    firstname and lastname of the menager department ;
    the number of workers.
    To sort the data by name of Department, firstname and lastname of the menager department.

Help me please. It is very difficult for me as nuclear physics.