Need help with RATIO and ROUND

I have a table that I need to extract values, determine their ratio, and then round to the nearest 50.

SELECT NAME, MFG, ROUND((WEIGHT/VOLUME),50) AS WV_RATIO, COUNT(*) OVER (ORDER BY NAME, MFG, WV_RATIO) AS NUMBER_OF_MATCHES FROM MEMBERS;

1. To calculate the ratio, can I just use the "/" symbol in my select statement?
2. I want to ROUND this ratio to the nearest 50. Ie. 0, 50, 100, 150, 200... How can this be accomplished?

Thanks!!

Marc Received on Tue Jun 24 2003 - 22:36:39 CEST