SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test (
  Type VARCHAR(10),
  Value VARCHAR(10)
);
INSERT INTO test VALUES
  ('A', 'String'),
  ('A', 'Int'),
  ('B', 'String'),
  ('B', 'String'),
  ('C', 'Double'),
  ('C', 'Float');
6 rows affected

SELECT Type, [String], [Int], [Double], [Float]  
FROM (
    SELECT Type, Value
    FROM test
) st PIVOT (  
    COUNT(Value)
    FOR Value IN ([String], [Int], [Double], [Float])  
) AS pt;


Type
String
Int
Double
Float


A
1
1
0
0

B
2
0
0
0

C
0
0
1
1


SELECT Type, [String], [Int], [Double], [Float], TotalRow
FROM (
    SELECT Type, Value, COUNT(Value) OVER (PARTITION BY Type) AS TotalRow
    FROM test
) st PIVOT (  
    COUNT(Value)
    FOR Value IN ([String], [Int], [Double], [Float])  
) pt

UNION ALL

SELECT 'Total', SUM([String]), SUM([Int]), SUM([Double]), SUM([Float]), SUM(TotalRow) 
FROM (
    SELECT Type, [String], [Int], [Double], [Float], TotalRow
    FROM (
        SELECT Type, Value, COUNT(Value) OVER (PARTITION BY Type) AS TotalRow
        FROM test
    ) st PIVOT (  
        COUNT(Value)
        FOR Value IN ([String], [Int], [Double], [Float])  
    ) pt
)t;


Type
String
Int
Double
Float
TotalRow


A
1
1
0
0
2

B
2
0
0
0
2

C
0
0
1
1
2

Total
3
1
1
1
6