Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2010

    Unanswered: Hi everyone please i need little help

    hello everyone hope u are all good and well

    have little question whether the SQL below is correct or not

    With SQL, how do you find the number of managers and sum of their salaries from a table called STAFF

    SELECT sum(Salary) as ‘Salary Sum’, count(*) as ‘Number of Managers’ FROM Staff WHERE job_title = ‘Manager’

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    Quote Originally Posted by b.llumnica View Post
    whether the SQL below is correct or not
    what happened when you tested it? | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts