処理の順番

https://qiita.com/k_0120/items/a27ea1fc3b9bddc77fa1

SELECT文の実行順序

FROM句
↓
JOIN句
↓
WHERE句
↓
GROUP BY句
↓
HAVING句
↓
SELECT句
↓
ORDER BY句
↓
LIMIT句