MySQL query explainer

Explain and understand query for MySQL.