Mixing two count queries

I've two queries:

select count(*) from my_table where status="accepted"

and

select count(*) from my_table where status="rejected"

I had been to obtain the ratio of recognized/reject so I'm wondering if you can mix the 2 queries and so i do not have to execute two queries

mysql database

select accepted_count, rejected_count, accepted_count/rejected_count ratio
from (
    select sum(CASE WHEN status="accepted" THEN 1 ELSE 0 END) accepted_count,
           sum(CASE WHEN status="rejected" THEN 1 ELSE 0 END) rejected_count
    from my_table 
    ) A

Putting this answer since none offered to date is correct

select count(case when status = "accepted" then 1 end) /
       count(case when status = "rejected" then 1 end) as Ratio
from my_table
where status in ("accepted","rejected")

Should you likewise need the person counts

select count(case when status = "accepted" then 1 end) Accepted,
       count(case when status = "rejected" then 1 end) Rejected,
       count(case when status = "accepted" then 1 end) /
       count(case when status = "rejected" then 1 end) as Ratio
from my_table
where status in ("accepted","rejected")

Note: MySQL doesn't have a divide by zero problem. It returns NULL when Declined is .

I believe this works:

SELECT (Select count(*) from my_table where status="accepted") / (select count(*) from my_table where status="rejected") AS ratio

select status, count(*) from my_table 
where status in ("rejected", "accepted")
group by status;

select sum(case when status='accepted' then 1 else 0 end) as AcceptedCount,
       sum(case when status='rejected' then 1 else 0 end) as RejectedCount
    from my_table

Related