Ah, yes, of course. Thanks. RBS
On Sun, Nov 25, 2018 at 12:24 PM R Smith <ryansmit...@gmail.com> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
