By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SalesDate | SalesValue |
---|---|
2021-02-25 | 70.00 |
2021-07-12 | 50.00 |
2021-01-22 | 90.00 |
2021-02-24 | 90.00 |
2021-05-19 | 100.00 |
2020-11-29 | 40.00 |
2021-05-21 | 90.00 |
2021-01-16 | 20.00 |
2021-01-06 | 20.00 |
2020-11-12 | 90.00 |
2021-01-18 | 70.00 |
2021-02-19 | 10.00 |
2021-07-01 | 30.00 |
2020-12-02 | 40.00 |
2021-07-08 | 50.00 |
2021-06-03 | 10.00 |
2020-11-02 | 80.00 |
2021-03-13 | 20.00 |
2020-12-05 | 90.00 |
2021-02-16 | 30.00 |
2021-06-21 | 20.00 |
2021-03-31 | 20.00 |
2020-11-26 | 100.00 |
2021-03-15 | 30.00 |
2021-01-13 | 80.00 |
2021-04-02 | 20.00 |
2021-04-20 | 70.00 |
2020-11-08 | 10.00 |
2021-05-12 | 100.00 |
2020-11-26 | 10.00 |
2021-04-18 | 90.00 |
2021-04-18 | 50.00 |
2021-01-31 | 100.00 |
2020-12-24 | 50.00 |
2020-11-27 | 90.00 |
2021-07-12 | 90.00 |
2021-05-27 | 20.00 |
2021-03-17 | 40.00 |
2021-06-05 | 60.00 |
2021-02-21 | 60.00 |
2021-05-30 | 70.00 |
2020-12-22 | 60.00 |
2021-05-10 | 80.00 |
2021-01-16 | 70.00 |
2021-06-04 | 80.00 |
2021-03-07 | 20.00 |
2021-07-20 | 20.00 |
2021-03-12 | 100.00 |
2021-02-09 | 20.00 |
2020-12-20 | 30.00 |
2021-06-19 | 10.00 |
2021-07-11 | 10.00 |
2021-04-15 | 40.00 |
2021-06-01 | 70.00 |
2021-01-23 | 30.00 |
2021-05-05 | 60.00 |
2021-07-16 | 100.00 |
2021-06-15 | 70.00 |
2021-02-26 | 90.00 |
2021-07-21 | 20.00 |
2021-05-05 | 90.00 |
2021-06-11 | 10.00 |
2021-07-17 | 100.00 |
2021-07-04 | 50.00 |
2021-04-13 | 10.00 |
2021-02-13 | 70.00 |
2021-02-15 | 60.00 |
2020-12-03 | 50.00 |
2021-02-24 | 80.00 |
2021-07-23 | 80.00 |
2021-03-05 | 30.00 |
2021-04-30 | 30.00 |
2021-01-16 | 10.00 |
2021-02-24 | 60.00 |
2021-02-03 | 40.00 |
2021-05-29 | 100.00 |
2020-12-09 | 50.00 |
2020-11-06 | 50.00 |
2021-06-26 | 40.00 |
2021-07-19 | 20.00 |
2020-11-04 | 80.00 |
2021-04-19 | 100.00 |
2020-12-30 | 70.00 |
2021-04-20 | 60.00 |
2020-12-19 | 60.00 |
2021-01-08 | 100.00 |
2021-03-14 | 30.00 |
2020-11-11 | 10.00 |
2021-03-18 | 100.00 |
2021-05-03 | 90.00 |
2020-11-22 | 90.00 |
2021-05-04 | 40.00 |
2021-03-04 | 50.00 |
2021-01-26 | 90.00 |
2021-07-22 | 20.00 |
2020-12-02 | 100.00 |
2020-12-30 | 30.00 |
2021-01-04 | 80.00 |
2021-04-24 | 50.00 |
2021-07-21 | 60.00 |
2021-03-29 | 100.00 |
2020-11-08 | 30.00 |
2021-04-07 | 70.00 |
2021-07-07 | 30.00 |
2021-07-13 | 50.00 |
2021-03-26 | 20.00 |
2021-05-18 | 30.00 |
2021-04-25 | 10.00 |
2021-01-07 | 20.00 |
2020-11-25 | 60.00 |
2020-12-20 | 50.00 |
2021-05-26 | 90.00 |
2021-02-08 | 30.00 |
2021-03-18 | 40.00 |
2021-02-26 | 80.00 |
2020-12-19 | 40.00 |
2021-07-15 | 100.00 |
2020-11-12 | 40.00 |
2020-11-25 | 50.00 |
2021-02-12 | 100.00 |
2021-01-19 | 50.00 |
2021-06-11 | 80.00 |
2021-03-24 | 70.00 |
2020-11-09 | 50.00 |
2021-07-27 | 40.00 |
2020-11-14 | 100.00 |
2021-04-20 | 20.00 |
2021-02-23 | 20.00 |
2021-01-29 | 40.00 |
2021-01-04 | 90.00 |
2021-03-01 | 20.00 |
2021-01-02 | 80.00 |
2021-04-29 | 80.00 |
2021-05-23 | 20.00 |
2021-07-10 | 40.00 |
2021-05-10 | 100.00 |
2021-06-22 | 50.00 |
2021-06-03 | 70.00 |
2021-04-26 | 40.00 |
2020-11-16 | 70.00 |
2020-12-10 | 60.00 |
2020-12-25 | 30.00 |
2021-04-16 | 40.00 |
2020-11-26 | 70.00 |
2020-11-14 | 90.00 |
2021-07-27 | 60.00 |
2021-07-23 | 90.00 |
2021-01-07 | 100.00 |
2021-06-28 | 10.00 |
2021-03-18 | 20.00 |
SalesDate | DAYNAME(SalesDate) | SalesValue |
---|---|---|
2021-07-11 | Sunday | 10.00 |
2021-07-04 | Sunday | 50.00 |
2021-05-30 | Sunday | 70.00 |
2021-05-23 | Sunday | 20.00 |
2021-04-25 | Sunday | 10.00 |
2021-04-18 | Sunday | 90.00 |