Domanda di colloquio di Affirm

Please walk me through how you would solve [business problem] using [some complex SQL query using multiple joins and a counting trick].