diff options
| author | lonkaars <loek@pipeframe.xyz> | 2022-09-16 14:28:41 +0200 |
|---|---|---|
| committer | lonkaars <loek@pipeframe.xyz> | 2022-09-16 14:28:41 +0200 |
| commit | d11270807080629f816ed59ece80c4eea17d9176 (patch) | |
| tree | 0aefcfb76b878759c2a4c2dcb7b608906d741077 | |
| parent | df85f06afad20a75d4942dd1f0784a7d0a7ddc0b (diff) | |
alle huiswerk 1.x klaar
| -rw-r--r-- | huiswerk.md | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/huiswerk.md b/huiswerk.md index 4ed078f..fc0681f 100644 --- a/huiswerk.md +++ b/huiswerk.md @@ -20,7 +20,27 @@ |1.16 |`select * from activiteit where actcode = "KLS";`| |1.17 |`select * from activiteit where prijs > 10.0;`| |1.18 |`select * from activiteit where prijs >= 15.0 order by prijs;`| -|1.19 |``| +|1.19 |`select * from opleiding where academie is null;`| +|1.20 |`select * from opleiding where oplcode like "T%";`| +|1.21 |`select * from opleiding where academie = "AII" order by oplcode;`| +|1.22 |`select * from activiteit where actomschr like "P%" and prijs < 10.0 order by actcode desc;`| +|1.23 |`select * from student where oplcode = "IN" or oplcode = "TI";`| +|1.24 |`select * from student where oplcode != "WTB";`| +|1.25 |`select * from student limit 3;`| +|1.26 |`select prijs from activiteit order by prijs limit 4;`| +|1.27 |`select datum from planning order by datum desc limit 1;`| +|1.28 |`select * from activiteit order by actcode limit 1,3;`| +|1.29 |`select * from activiteit order by prijs desc limit 1,1;`| +|1.30 |`select count(*) as aantal_studenten from student;`| +|1.31 |`select min(datum) as vroegste_datum, max(datum) as laatste_datum from planning;`| +|1.32 |`select min(datum) as vroegste_datum_KLS from planning where actcode = "KLS";`| +|1.33 |`select avg(prijs) as gemiddelde_prijs from activiteit;`| +|1.34 |`select sum(prijs) as totale_prijs from activiteit;`| +|1.35 |`select sum(prijs) as totale_prijs_actcode_P from activiteit where actcode like "P%";`| +|1.36 |`select count(distinct academie) as aantal_academies from opleiding where academie is not NULL;`| +|1.37 |`select count(distinct oplcode) as aantal_opleiding_met_student from student;`| +|1.38 |`select count(actcode) as aantal_studenten_KRS from belangstelling where actcode = "KRS";`| +|1.39 |`select count(*) from inschrijving where planningsnr >= 4 and planningsnr <= 9 and betaald = 0;`| ## 1.07 |