Meta interview question

SQL question, use join operations, calculate ratio