Need help with a CASE query?

Question

SQL

Hello, guys, who will tell you how to write such a request that considered the conversion,
for example, there is a field ID, STATUS
STATUS has the following values ​​1,2,3,4,5
1 - this is a successful status
!= 1 all unsuccessful
, here's how I can calculate the conversion using CASE help plz because i ended up with this

SELECT
COUNT(*)FILTER(WHERE STATUS = 1) SUCCESS,
COUNT(*)FILTER(WHERE STATUS != 1) UNSUCCESS,
FROM TABLE

The arithmetic is:
success / (success+fail) * 100

Answer 1

Subquery?

SELECT SUCCESS * 100 / (SUCCESS + UNSUCCESS) FROM (
  SELECT
  COUNT(*)FILTER(WHERE STATUS = 1) SUCCESS,
  COUNT(*)FILTER(WHERE STATUS != 1) UNSUCCESS,
  FROM TABLE
) AS T