By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
2 rows affected
1 rows affected
2 rows affected
6 rows affected
3 rows affected
4 rows affected
1 rows affected
PRICEID | PRODID | PRICE | VALIDFROM | VALIDTO |
---|---|---|---|---|
1 | 1 | 10 | 16-JAN-21 | 24-JAN-21 |
2 | 1 | 12 | 24-JAN-21 | 29-JAN-21 |
3 | 1 | 14 | 29-JAN-21 | 01-JAN-99 |
4 | 2 | 100 | 16-JAN-21 | 24-JAN-21 |
5 | 2 | 90 | 24-JAN-21 | 31-JAN-21 |
6 | 2 | null | 31-JAN-21 | 01-JAN-99 |
ORDERLINEID | ORDERID | PRODID | PRODQUANTITY |
---|---|---|---|
1 | 1 | 1 | 3 |
2 | 1 | 2 | 2 |
3 | 2 | 2 | 10 |
4 | 3 | 2 | 10 |
ORDERID | CUSTOMERID | STOREID | ORDEREDAT | TOTAL | TOTALPAID |
---|---|---|---|---|---|
1 | 1 | 1 | 21-JAN-21 | 230 | null |
2 | 2 | 1 | 21-JAN-21 | 1000 | 500 |
3 | 2 | 1 | 25-JAN-21 | 900 | null |