Meta Interview Question

One SQL question is to calculate the CTR.