whether a correct answer
I would like to ask if this is a valid answer to interview 3
select CONCAT((x.closed_status * 100 / count(status)), '%') as Percent
from interviews.account_status,
(select count(status) as closed_status from interviews.account_status where date = '2020-01-10' and status = 'closed' ) x
where date = '2020-01-10'
group by x.closed_status;
0 answers ( 0 marked as helpful)