Auditor-Fiscal da Receita Federal

Practice session

In a fiscal database containing millions of Electronic Transport Documents (`tb_cte`), an auditor needs to compute the cancellation rate (taxa de cancelamento) per transport carrier (`cnpj_emitente`). In SQL, which conditional aggregation syntax correctly calculates the percentage of cancelled CT-es over total registered CT-es for each carrier?

Loading your practice session…