SQLite 3.27

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select @@version;
unrecognized token: "@"

create table t (Item varchar(10), Result varchar(244));
INSERT INTO t values('A', 'Pass'),('B', 'Pass'),('A', 'Fail'),('B', 'Fail');
select * from t


Item
Result


A
Pass

B
Pass

A
Fail

B
Fail


/* Using pivot - Does not work*/

/*
SELECT 
    item, 
    total, 
    CONCAT(Pass,'(', CAST((Pass*1.0/total*1.0)*100.0 AS DECIMAL),'%)') AS Accept, 
    CONCAT(Fail,'(', CAST((Fail*1.0/total*1.0)*100.0 AS DECIMAL),'%)') AS Reject
FROM 
    (
     SELECT 
         Item, 
         result,
         COUNT(result) OVER(PARTITION BY item ORDER BY result ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS total
     FROM t
    ) AS j
PIVOT
(
  COUNT(Result)
  FOR Result
  IN([Pass], [Fail])
) AS pvt

*/


Item
Result


A
Pass

B
Pass

A
Fail

B
Fail


not an error

SELECT 
    item, 
    total, 
    SUM(Pass)||'('|| CAST((SUM(Pass)*1.0/total*1.0)*100.0 AS DECIMAL)||'%)' AS Accept, 
    SUM(Fail)||'('|| CAST((SUM(Fail)*1.0/total*1.0)*100.0 AS DECIMAL)||'%)' AS Reject
FROM 
    (
     SELECT 
         Item, 
         result,
         COUNT(result) OVER(PARTITION BY item ORDER BY result ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING) AS total,
         CASE
           WHEN Result = 'Pass' then 1
           ELSE 0
         END AS Pass,
         CASE
           WHEN Result = 'Fail' then 1
           ELSE 0
         END AS Fail
     FROM t
    ) AS j
GROUP BY item, total


Item
total
Accept
Reject


A
2
1(50.0%)
1(50.0%)

B
2
1(50.0%)
1(50.0%)