I'm calculating the change in pain between day 1 and day 2. 
There are two fields, Pain\_Admit\_Comfort and Pain\_48\_Hr\_Comfort, the options in each is Yes/No. 

I need to find everyone that had pain on Admit and is More Comfortable 2 days later. 

This is the query. The first two statements return correct numbers. I can't figure out how to divide using the same statements as numerator and denominator. 

```
 select 
     (select COUNT (PAIN_48_HR_COMFORT_C) 
      FROM CASES WHERE PAIN_48_HR_COMFORT_C='Yes') as Forty_Eight_Hours,

     (SELECT COUNT (PAIN_ADMIT_COMFORT_C)
      FROM CASES WHERE PAIN_ADMIT_COMFORT_C='YES') as Admit_Uncomfort_Yes,

     ((select COUNT (PAIN_48_HR_COMFORT_C) 
       FROM CASES WHERE PAIN_48_HR_COMFORT_C='Yes')
      /
     (SELECT COUNT (PAIN_ADMIT_COMFORT_C) 
      FROM CASES WHERE PAIN_ADMIT_COMFORT_C='YES')) AS Percent_Changed

 from CASES

```

Thanks