Query Grouping statistics

CREATE TABLE TB
(
ID int,
name varchar (),
categorical int,
encoded int,
user ID int

) INSERT INTO
 
TB VALUES (1, ' A ', 1,1,1111)
insert into terabytes values (2, ' B ', 1,0,3333)
insert into TB values (3, ' C ', 2,0,3333)
INSERT into TB values (4, ' D ', 3,0,3333)
inserts into terabytes values (5, ' E ', 3,0,4444)
insert into TB values (6, ' F ',  3,0,4444)

 

 
 
SELECT user ID,

       sum (case when class = 1 and encoded = 0 Then 1 else 0 end) [Data of Category 1 encoded 0],
       sum (case when class = 1 and encoded = 1 then 1 else 0 end) [Data of Category 1 encoded 1],
       sum (case when class = 2 and encode = 0 Then 1 else 0 end) [Data of Category 2 encoded 0],
       sum ( case when class = 2 and encoded = 1 then 1 else 0 end) [Data of Category 2 coded 1],
       sum (case when class = 3 and encode = 0 Then 1 else 0 end) [Category 3 encoding 0 data],
       sum (case when class = 3 and encoded = 1 then 1 else 0 end) [Data of Category 3 encoded 1] from
TB
GROUP by User ID

SELECT user i D, from


TB
GROUP by User ID