Posted on:

28 Sept 2021

0

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)

Submit an answer