By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table YourTable(
[User] varchar(10),
Day varchar(10)
)
insert into YourTable values
('User1', 'Monday'),
('User2', 'Monday'),
('User3', 'Monday'),
('User2', 'Tuesday'),
('User3', 'Tuesday')
select [User],
SUM(case when Day = 'Monday' then 1 else 0 end) Monday,
SUM(case when Day = 'Tuesday' then 1 else 0 end) Tuesday
from YourTable
group by [User]
| User | Monday | Tuesday |
|---|---|---|
| User1 | 1 | 0 |
| User2 | 1 | 1 |
| User3 | 1 | 1 |