SQL Query

[Nod]

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.

[Nod]

doesn't matter figured it out myself lol can delete if you want

[Nod]

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

[seaneyb]

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

mate sql is horrible!!! if u wait till tonight i can give u the answer got it all written down, havent done any sql in bout 7 months haha.

[Nod]

Cool thanks.

[silent_thunder89]

all sorted or not?

[Nod]

Yeah I have

SELECT [first name], [surname], ROUND( ( ( [salary] * 1.03 ) / 12 ), 2 ) AS [Monthly Wage]
FROM Workers