Results 1 to 2 of 2

Thread: Need Help

  1. #1
    Join Date
    Jul 2011
    Posts
    1

    Unanswered: Need Help

    How can I write querys for the following?

    A list of employee's registered for a job role. This should include the job role and employee’s first name and surname for each role. The employee’s names should be displayed in a single column.

    A list of job roles showing the number of employees of each gender registered for each job role.

    Alphabetical list of employee together with the name and phone number of their employer.
    The list must have the first name and surname for each employee and the title, firstname, surname and phone number for their employer. The employer's title and name should be displayed in a single column. The listing should be sorted alphabetically by employee’s surname, first name.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    how? by paying attention in SQL class

    sorry, mate, we won't do your homework for you
    rudy.ca | @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
  •