> course1 number-of-people-involved-in-course1
number-of-tasks-involved-in-course1
> course2 number-of-people-involved-in-course2
number-of-tasks-involved-in-course2
> course3 number-of-people-involved-in-course3
number-of-tasks-involved-in-course3
> course4 number-of-people-involved-in-course4
number-of-tasks-involved-in-course4
This can be produced by:
select crs.id
, crs.name
, (select count(id) from people pe where pe.course = crs.id) as
num_people
, (select count(id) from tasks ta where ta.course = crs.id) as
num_tasks
from courses crs
;
Result:
14 starter course 2 2
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
