doesn't matter figured it out myself lol can delete if you want
Right i'm ill with the Flu so not at class today so i'm just doing my work from home.
Would anyone able to tell me how to make two calculations in the same query example to add a 3% bonus to a monthly Salary using the Annual salary. Would anyone be able to tweak this to help me.
I have done the multiplication as 1.03 but now I need to divide it by 12 but im unsure as how to do this as it doesn't mention it in the notes
SELECT [first name], surname, (salary * 1.03) AS Monthly_Wage
FROM Workers
WHERE town = "Bonnyrigg"
Thank you very much if you can help.
doesn't matter figured it out myself lol can delete if you want
infact I have another problem I can't seem to round it to two decimal places here's what i've got so far, I'm aware of the round function but can't seem to get it to work correctly, anyone got any ideas? Please bare in mind im completely new to SQL.
SELECT [first name], surname, (salary * 1.03) / 12 AS [Monthly Wage]
FROM Workers
Cool thanks.
all sorted or not?
Yeah I have
SELECT [first name], [surname], ROUND( ( ( [salary] * 1.03 ) / 12 ), 2 ) AS [Monthly Wage]
FROM Workers