Divide One Column From Another

[aftabn10]

I have the following query, but i dont know how i can divide the values of saw_3 by saw_4. Could somebody please help?

 

The following is my query at the moment, but i would like saw_3 to show me values that have been divided by saw_4.

 

SELECT "TEST RE Values Dim"."Queue Name" saw_0, "TEST AHT By Agent"."Agent ID" 
saw_1, "TEST AHT By Agent"."Transaction Time" saw_2, "TEST AHT By Agent"."AHT -OM" 
saw_3, "TEST AHT By Agent"."Number Of OM" saw_4 FROM System_TEST WHERE "TEST 
RE Values Dim"."Queue Name" LIKE 'Queue 1' ORDER BY saw_0, saw_1

 

Thanks in advance.

[fenway]

SELECT 
"TEST RE Values Dim"."Queue Name" saw_0
, "TEST AHT By Agent"."Agent ID" saw_1
, "TEST AHT By Agent"."Transaction Time" saw_2
, "TEST AHT By Agent"."AHT -OM" saw_3
, "TEST AHT By Agent"."Number Of OM" saw_4 
, "TEST AHT By Agent"."AHT -OM" / "TEST AHT By Agent"."Number Of OM" saw_3_div_4 
FROM System_TEST 
WHERE "TEST RE Values Dim"."Queue Name" LIKE 'Queue 1' 
ORDER BY saw_0, saw_1

 

Spaces in table/field names is a bad practice.  and I'm assuming you have ansi mode enabled to be able to use those double-quotes.