sql语句以字母顺序排列和计数

SELECT 
  TABLE_SCHEMA,
  TABLE_NAME,
  COLUMN_NAME,
  DATA_TYPE,
  COUNT(*) AS COUNT,
  ROW_NUMBER() OVER (ORDER BY DATA_TYPE) AS RANK
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_SCHEMA = 'your_schema'
  AND TABLE_NAME = 'your_table'
GROUP BY
  TABLE_SCHEMA,
  TABLE_NAME,
  COLUMN_NAME,
  DATA_TYPE
ORDER BY
  RANK,
  TABLE_SCHEMA,
  TABLE_NAME,
  COLUMN_NAME,
  DATA_TYPE;

SELECT 
  TABLE_SCHEMA,
  TABLE_NAME,
  COUNT(*) AS COUNT,
  ROW_NUMBER() OVER (ORDER BY COUNT(*) DESC) AS RANK
FROM
  INFORMATION_SCHEMA.TABLES
WHERE
  TABLE_SCHEMA = 'your_schema'
  AND TABLE_NAME = 'your_table'
GROUP BY
  TABLE_SCHEMA,
  TABLE_NAME
ORDER BY
  RANK,
  TABLE_SCHEMA,
  TABLE_NAME;