On 2018/11/25 1:50 PM, Bart Smissaert wrote:
Is it possible to use the aliases diab_count and drug_count directly in a
fourth column to show the percentage?
No.
This doesn't work:
select gp_name,
sum(emis_number in (select emis_number from diabetics)) as diab_count,
sum(emis_number in (select emis_number from diab_on_non_insulin) or
emis_number in (select emis_number from diab_on_insulin)) as drug_count,
drug_count / diab_count as percentage
from patients group by gp_name
order by diab_count asc
But this should work:
SELECT *, drug_count / diab_count as percentage
FROM (select gp_name,
sum(emis_number in (select emis_number from diabetics)) as diab_count,
sum(emis_number in (select emis_number from diab_on_non_insulin) or
emis_number in (select emis_number from diab_on_insulin)) as drug_count
from patients group by gp_name
)
ORDER by diab_count asc
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
