Queries calulating ratio

[Lifeseeker]

Hi,

I have a simple query like below.

SELECT [score_admit] / SELECT [score_discharge] AS Ratio, facility_type
FROM tbl_test
group by facility_type;

It's really just based on one table, but what I'm trying to do is to calculate the ratio for the scores, then arrange the result based on facility types.

The error I get is a syntax error the SELECT statements.

Can anyone help out?

Thanks

 

[JHB]

Remove the second select.

SELECT [score_admit]/[score_discharge] AS Ratio, facility_type FROM tbl_test group by facility_type;

 

[CJ_London]

You have two problems

You don't need the second select
you have grouped by facility type but not stated whether it is the sum or average for ratio or the sum of score admit/sum or score discharge (have assumed this is what you want

SELECT sum([score_admit]) / sum([score_discharge]) AS Ratio, facility_type
FROM tbl_test
group by facility_type;

 

[Lifeseeker]

thanks, it works.