Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2006
    Posts
    14

    Unanswered: Exam Tommorrow Help me please

    Hi there I have an exam tommorrow and i am studying for my SQL which I havent done in months and cant even work out how to do my revision problems.

    DELEGATE: course coude, employee num, date, attended
    EMPLOYEE: employee num, forename, surname,address,DOB,joined,department
    DEPARTMENT: department num, department name, manager, email
    SALARY: salary grp, salary

    Could someone please help me with the code for these two queries it would be greatly appreciated.

    1. List the number of ppl in each department who attended a training course (attended = yes). output department name and count only.

    2. Calculate a bonus for every member of staff, if they joined more than 10 years ago they get a 5% on their salary, else they get 2.5%

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by jaypee007
    Hi there I have an exam tommorrow and i am studying for my SQL which I havent done in months
    oh, man, that's too bad

    my advice: get off the internet and re-read your books and course notes, then get a good night's sleep
    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
  •