SELECT DISTINCT column_1, column_2 FROM table_1 JOIN table_2 ON table_1.column_1 = table_2.column_1 WHERE table_1.column_2 > 100 -- constraint_expression GROUP BY table_1.conlumn_1 -- column HAVING COUNT(table_1.column_1) > 1 -- constraint_expression ORDER BY table_1.conlumn_1 ASC LIMIT count; 실행순서 FROM > JOIN > ON > WHERE > GROUP BY > HAVING > SELECT > DISTINCT > ORDER BY > LIMIT