Thanks; this works fine:
select PLACE,
sum(ID not in (select ID from ATTENDED)),
count(ID)
from PERSONS group by PLACE
But if I add the aliases I get:
near "All": syntax error
Result of sqlite3_prepare16_v3: 1
select PLACE, sum(ID not in (select ID from ATTENDED)) Not_Attended,
count(*) All from PERSONS group by PLACE
Otherwise very neat indeed though!
RBS
On Thu, Mar 14, 2019 at 12:21 AM Igor Tandetnik <[email protected]> wrote:
> On 3/13/2019 8:08 PM, Bart Smissaert wrote:
> > But I would like the result to be in 3 columns, so result in this case
> > would be:
> >
> > Place Not_Attended All
> > -------------------------------
> > A 3 7
> > B 2 3
>
> Something like this (not tested):
>
> select PLACE,
> sum(ID not in (select ID from ATTENDED)) Not_Attended,
> count(*) All
> from PERSONS group by PLACE;
>
> --
> Igor Tandetnik
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
