This page (revision-28) was last changed on 23-Apr-2022 17:06 by Harry Metske

This page was created on 23-Apr-2022 17:05 by HarryMetske

Only authorized users are allowed to rename pages.

Only authorized users are allowed to delete pages.

Page revision history

Version Date Modified Size Author Changes ... Change note
28 23-Apr-2022 17:06 15 KB Harry Metske to previous
27 23-Apr-2022 17:05 15 KB Harry Metske to previous | to last
26 23-Apr-2022 17:05 15 KB Harry Metske to previous | to last
25 23-Apr-2022 17:05 15 KB Harry Metske to previous | to last
24 23-Apr-2022 17:05 15 KB Harry Metske to previous | to last
23 23-Apr-2022 17:05 14 KB Harry Metske to previous | to last
22 23-Apr-2022 17:05 14 KB Harry Metske to previous | to last
21 23-Apr-2022 17:05 14 KB Harry Metske to previous | to last

Page References

Incoming links Outgoing links
Kruimeltje weetjes
Kruimeltje weetjes

Version management

Difference between version and

At line 26 added 39 lines
!! Jaarlijkse rapportage
De volgende SQL statements zijn handig voor het maken van de jaarlijkse rapportage:
%%small
{{{
# aantal peuters per vestiging voor elke maand:
select "2007-04",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-04-01" and datumlaatstebezoek>"2007-04-30" group by vestiging desc;
select "2007-05",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-05-01" and datumlaatstebezoek>"2007-05-31" group by vestiging desc;
select "2007-06",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-06-01" and datumlaatstebezoek>"2007-06-30" group by vestiging desc;
select "2007-07",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-07-01" and datumlaatstebezoek>"2007-07-31" group by vestiging desc;
select "2007-08",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-08-01" and datumlaatstebezoek>"2007-08-31" group by vestiging desc;
select "2007-09",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-09-01" and datumlaatstebezoek>"2007-09-30" group by vestiging desc;
select "2007-10",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-10-01" and datumlaatstebezoek>"2007-10-31" group by vestiging desc;
select "2007-11",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-11-01" and datumlaatstebezoek>"2007-11-30" group by vestiging desc;
select "2007-12",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-12-01" and datumlaatstebezoek>"2007-12-31" group by vestiging desc;
select "2008-01",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2008-01-01" and datumlaatstebezoek>"2008-01-31" group by vestiging desc;
select "2008-02",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2008-02-01" and datumlaatstebezoek>"2008-02-28" group by vestiging desc;
select "2008-03",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2008-03-01" and datumlaatstebezoek>"2008-03-31" group by vestiging desc;
# dubbelpeuters per vestiging:
select "2007-04",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-04-01" and datumlaatstebezoek>"2007-04-30" and groep2 is not NULL group by vestiging desc;
select "2007-05",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-05-01" and datumlaatstebezoek>"2007-05-31" and groep2 is not NULL group by vestiging desc;
select "2007-06",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-06-01" and datumlaatstebezoek>"2007-06-30" and groep2 is not NULL group by vestiging desc;
select "2007-07",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-07-01" and datumlaatstebezoek>"2007-07-31" and groep2 is not NULL group by vestiging desc;
select "2007-08",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-08-01" and datumlaatstebezoek>"2007-08-31" and groep2 is not NULL group by vestiging desc;
select "2007-09",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-09-01" and datumlaatstebezoek>"2007-09-30" and groep2 is not NULL group by vestiging desc;
select "2007-10",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-10-01" and datumlaatstebezoek>"2007-10-31" and groep2 is not NULL group by vestiging desc;
select "2007-11",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-11-01" and datumlaatstebezoek>"2007-11-30" and groep2 is not NULL group by vestiging desc;
select "2007-12",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2007-12-01" and datumlaatstebezoek>"2007-12-31" and groep2 is not NULL group by vestiging desc;
select "2007-01",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2008-01-01" and datumlaatstebezoek>"2008-01-31" and groep2 is not NULL group by vestiging desc;
select "2007-02",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2008-02-01" and datumlaatstebezoek>"2008-02-28" and groep2 is not NULL group by vestiging desc;
select "2007-03",(select vestiging from groep where groep.nummer=peuter.groep1) as vestiging,count(*) from peuter where datumingeschreven<"2008-03-01" and datumlaatstebezoek>"2008-03-31" and groep2 is not NULL group by vestiging desc;
# $2005_2006.$A$3:$B$16;$2005_2006.$E$3:$E$16;$2005_2006.$H$3:$H$16file:///home/metskem/mySQL/krm1.sql
}}}
%%
This page (revision-28) was last changed on 23-Apr-2022 17:06 by Harry MetskeTop