var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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%
oh, man, that's too bad
Originally Posted by jaypee007
my advice: get off the internet and re-read your books and course notes, then get a good night's sleep