Report question

Question: Does MySQL optimize subqueries automatically?