Medium
SQL Duplicate Finder
Generate a SQL query to identify duplicate records in a database table.
📝 プロンプトの内容
Write a SQL query for a PostgreSQL database to find all duplicate email addresses in the 'users' table. Display the email address and the count of how many times it appears. Sort the results by the count in descending order.