Task: Text to Code
Input (English): Step 1: find the number of rows of each value of name in user_profiles table.
Step 2: find name, email in user_profiles table whose corresponding value in step 1 is greater than 1
Output (English): SELECT name , email FROM user_profiles GROUP BY name HAVING Count ( * ) > 1