add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SalesDate SalesValue
2021-02-17 100.00
2021-01-18 20.00
2021-01-31 20.00
2020-11-28 30.00
2021-03-08 90.00
2021-06-18 60.00
2021-06-14 30.00
2021-03-21 100.00
2021-01-26 50.00
2020-11-28 90.00
2021-06-12 90.00
2021-06-27 60.00
2021-02-22 50.00
2020-12-08 10.00
2021-06-27 80.00
2021-06-28 30.00
2021-07-03 90.00
2021-06-19 10.00
2021-05-05 10.00
2021-04-09 80.00
2021-06-08 40.00
2021-07-06 60.00
2020-11-07 10.00
2021-01-24 60.00
2020-11-26 80.00
2021-03-12 50.00
2020-11-19 40.00
2021-02-01 80.00
2021-06-25 50.00
2021-05-11 20.00
2021-05-17 10.00
2021-06-22 20.00
2021-05-06 90.00
2020-11-13 20.00
2021-06-19 80.00
2021-04-11 50.00
2021-07-17 50.00
2021-01-31 90.00
2021-04-21 10.00
2021-03-16 30.00
2021-07-01 80.00
2020-12-29 100.00
2021-04-28 100.00
2021-02-03 60.00
2020-11-22 40.00
2021-02-02 100.00
2021-04-15 70.00
2020-11-06 50.00
2021-07-13 40.00
2021-04-22 90.00
2021-04-17 50.00
2021-07-20 40.00
2021-04-22 80.00
2020-11-21 80.00
2020-11-10 90.00
2021-02-26 100.00
2021-01-14 20.00
2021-05-03 40.00
2021-03-04 30.00
2021-04-18 40.00
2021-07-04 20.00
2021-01-10 30.00
2021-03-28 90.00
2021-03-14 10.00
2020-12-18 100.00
2020-12-12 70.00
2021-02-21 100.00
2021-07-09 10.00
2021-03-27 70.00
2021-01-10 10.00
2021-02-20 100.00
2021-03-31 30.00
2021-03-18 50.00
2020-12-09 100.00
2021-05-08 80.00
2021-06-30 30.00
2021-04-06 90.00
2020-12-15 20.00
2020-12-12 50.00
2021-05-31 100.00
2021-02-13 70.00
2021-06-02 70.00
2021-06-07 70.00
2021-02-07 20.00
2021-03-26 100.00
2020-12-03 30.00
2021-02-06 80.00
2021-06-12 100.00
2021-02-01 70.00
2020-11-16 70.00
2021-07-13 30.00
2021-01-07 40.00
2020-12-23 40.00
2021-06-29 40.00
2020-11-10 50.00
2021-07-12 70.00
2020-12-17 10.00
2021-04-19 100.00
2021-01-21 80.00
2021-07-13 70.00
2021-02-02 30.00
2021-07-19 90.00
2021-05-01 10.00
2021-03-07 10.00
2021-06-16 100.00
2021-07-15 50.00
2020-11-09 30.00
2021-07-08 70.00
2021-06-17 60.00
2021-01-25 20.00
2021-01-31 30.00
2021-05-27 60.00
2021-02-08 90.00
2021-02-09 10.00
2021-04-29 70.00
2021-03-27 40.00
2021-02-20 70.00
2020-11-09 60.00
2021-04-06 30.00
2020-12-30 30.00
2021-02-04 70.00
2021-02-27 100.00
2020-12-01 30.00
2021-06-08 90.00
2021-03-26 50.00
2021-04-13 70.00
2021-04-30 80.00
2021-01-26 60.00
2021-05-01 80.00
2020-11-20 50.00
2020-11-06 60.00
2020-12-01 90.00
2020-12-08 50.00
2021-01-08 10.00
2021-04-24 40.00
2021-06-22 100.00
2021-07-13 90.00
2021-06-26 20.00
2020-11-09 20.00
2021-01-15 100.00
2021-04-09 20.00
2021-05-12 50.00
2021-04-05 40.00
2021-01-17 50.00
2021-06-10 80.00
2021-06-06 30.00
2020-12-17 80.00
2021-06-17 50.00
2021-04-13 10.00
2020-11-05 90.00
SalesDate DAYNAME(SalesDate) SalesValue
2021-07-04 Sunday 20.00
2021-06-27 Sunday 60.00
2021-06-27 Sunday 80.00
2021-06-06 Sunday 30.00
2021-04-18 Sunday 40.00
2021-04-11 Sunday 50.00
SalesDate Dayn SalesValue rn
2021-07-09 Friday 10.00 1
2021-06-25 Friday 50.00 2
2021-06-18 Friday 60.00 3
2021-04-30 Friday 80.00 4
2021-04-09 Friday 80.00 5
2021-04-09 Friday 20.00 6
2021-07-19 Monday 90.00 1
2021-07-12 Monday 70.00 2
2021-06-28 Monday 30.00 3
2021-06-14 Monday 30.00 4
2021-06-07 Monday 70.00 5
2021-05-31 Monday 100.00 6
2021-07-17 Saturday 50.00 1
2021-07-03 Saturday 90.00 2
2021-06-26 Saturday 20.00 3
2021-06-19 Saturday 10.00 4
2021-06-19 Saturday 80.00 5
2021-06-12 Saturday 90.00 6
2021-07-04 Sunday 20.00 1
2021-06-27 Sunday 60.00 2
2021-06-27 Sunday 80.00 3
2021-06-06 Sunday 30.00 4
2021-04-18 Sunday 40.00 5
2021-04-11 Sunday 50.00 6
2021-07-15 Thursday 50.00 1
2021-07-08 Thursday 70.00 2
2021-07-01 Thursday 80.00 3
2021-06-17 Thursday 60.00 4
2021-06-17 Thursday 50.00 5
2021-06-10 Thursday 80.00 6
2021-07-20 Tuesday 40.00 1
2021-07-13 Tuesday 40.00 2
2021-07-13 Tuesday 30.00 3
2021-07-13 Tuesday 70.00 4
2021-07-13 Tuesday 90.00 5
2021-07-06 Tuesday 60.00 6
2021-06-30 Wednesday 30.00 1
2021-06-16 Wednesday 100.00 2
2021-06-02 Wednesday 70.00 3
2021-05-12 Wednesday 50.00 4
2021-05-05 Wednesday 10.00 5
2021-04-28 Wednesday 100.00 6