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%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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment