Menu
mediumPwC · subqueryGlobal · hiring in Asia

Pick the largest transactions for audit sampling

For each subsidiary, the audit sample is every transaction larger than 90% of that subsidiary's own average transaction size.

Return subsidiary, txn_id and amount for every transaction that qualifies.

Schema

transactions
txn_idINT
subsidiaryTEXT
amountNUMERIC

Example input

transactions
↑ Read the question

Keep going

Company names are trademarks of their respective owners, used here only to describe practice material. mahir_data is not affiliated with, endorsed by, or sponsored by any company named on this site. Terms.