Intermediate
Identify Duplicate Records
Generate a SQL query to find duplicate entries in a table.
📝 プロンプトの内容
Write a SQL query for a table named 'users' with columns 'id', 'email', and 'name'. The query should identify all email addresses that appear more than once in the table, displaying the email and the count of occurrences.