Meta interview question

One SQL question is to calculate the CTR.