SQL查询: 模糊查找包含'pwd'或'pass'的列并按数量排序

以下是模糊查找包含'pass'字段的SQL查询语句，并按列的数量从大到小排序并显示出来：

SELECT table_schema, table_name, column_name, COUNT(*) as column_count FROM information_schema.columns WHERE column_name LIKE '%pwd%' OR column_name LIKE '%pass%' GROUP BY table_schema, table_name, column_name ORDER BY column_count DESC;