SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE SALES
  (date datetime,
  sales decimal(18,2))
insert into sales(date, sales)
values('2023-03-03 14:47:36.270', 6.66),
  ('2023-03-03 19:20:16.543', 7.18),
  ('2023-03-04 12:56:04.712', 7.18),
  ('2023-03-05 20:10:53.725', 10.00),
  ('2023-03-05 02:17:31.451', 20.00),
  ('2023-03-06 14:44:22.225', 7.18),
('2023-03-10 01:15:46.113', 25.08)
7 rows affected

SELECT
    CASE WHEN weekdays = 1 THEN total_quantity ELSE 0 END as Sunday,
    CASE WHEN weekdays = 2 THEN total_quantity ELSE 0 END as Monday,
    CASE WHEN weekdays = 3 THEN total_quantity ELSE 0 END as Tuesday,
    CASE WHEN weekdays = 4 THEN total_quantity ELSE 0 END as Wednesday,
    CASE WHEN weekdays = 5 THEN total_quantity ELSE 0 END as Thursday,
    CASE WHEN weekdays = 6 THEN total_quantity ELSE 0 END as Friday,
    CASE WHEN weekdays = 7 THEN total_quantity ELSE 0 END as Saturday
FROM(
 SELECT 
    datepart(WEEKDAY, date) as weekdays,
    SUM(sales) as total_quantity
FROM sales
where cast(date as date)between '2023-03-01' and '2023-03-30'
group by datepart(weekday,date))X


Sunday
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday


30.00
0.00
0.00
0.00
0.00
0.00
0.00

0.00
7.18
0.00
0.00
0.00
0.00
0.00

0.00
0.00
0.00
0.00
0.00
38.92
0.00

0.00
0.00
0.00
0.00
0.00
0.00
7.18

Sunday	Monday	Friday	Saturday
30.00	0.00	0.00	0.00
0.00	7.18	0.00	0.00
0.00	0.00	38.92	0.00
0.00	0.00	0.00	7.18