对于以星期二开始的日期名称，排序日期的SQL查询将是什么？

SELECT date_column
FROM table_name
ORDER BY CASE WHEN DATE_FORMAT(date_column, '%W') = 'Tuesday' THEN 1
              WHEN DATE_FORMAT(date_column, '%W') = 'Wednesday' THEN 2
              WHEN DATE_FORMAT(date_column, '%W') = 'Thursday' THEN 3
              WHEN DATE_FORMAT(date_column, '%W') = 'Friday' THEN 4
              WHEN DATE_FORMAT(date_column, '%W') = 'Saturday' THEN 5
              WHEN DATE_FORMAT(date_column, '%W') = 'Sunday' THEN 6
              ELSE 7
         END, date_column;