diff options
| author | lonkaars <loek@pipeframe.xyz> | 2022-09-29 14:36:40 +0200 |
|---|---|---|
| committer | lonkaars <loek@pipeframe.xyz> | 2022-09-29 14:36:40 +0200 |
| commit | 8510d3aec5fb5e5ff4f7a37f2450c9a250745043 (patch) | |
| tree | 80584164167f2cf3a6386e161012019f64621fc6 /opdracht-1/q5.sql | |
| parent | 4e1edb93cc47a616b89fa5188eb444eb665e0160 (diff) | |
beginsels opdracht 1
Diffstat (limited to 'opdracht-1/q5.sql')
| -rw-r--r-- | opdracht-1/q5.sql | 36 |
1 files changed, 36 insertions, 0 deletions
diff --git a/opdracht-1/q5.sql b/opdracht-1/q5.sql new file mode 100644 index 0000000..88fd2a3 --- /dev/null +++ b/opdracht-1/q5.sql @@ -0,0 +1,36 @@ +insert into `Order` (KlantID, Besteldatum, Status) values ( + 1, + '2022-09-29', + "Besteld" +); + +insert into `Order` (KlantID, Besteldatum, Status) values ( + 2, + '2014-03-10', + "Geleverd" +); + +insert into `Order` (KlantID, Besteldatum, Status) values ( + 2, + '2018-12-29', + "Geleverd" +); + +insert into `Order` (KlantID, Besteldatum, Status) values ( + 3, + '2023-07-25', + "Besteld" +); + +insert into `Order` (KlantID, Besteldatum, Status) values ( + 3, + '2018-02-20', + "Geleverd" +); + +insert into OrderProduct (OrderID, ProductID, Aantal) values (1, 1, 20); +insert into OrderProduct (OrderID, ProductID, Aantal) values (2, 2, 12); +insert into OrderProduct (OrderID, ProductID, Aantal) values (3, 3, 6); +insert into OrderProduct (OrderID, ProductID, Aantal) values (4, 4, 11); +insert into OrderProduct (OrderID, ProductID, Aantal) values (5, 5, 3); + |