diff options
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); + |