List first_name, last_name, name_count of the patients, including only people who share the same first and last name (each shown once). name_count is the number of duplicates for each full name. The displayed results are sorted alphabetically by first_name and last_name.
Expected Output
Query Editor
User Output Ready
Execute a query or press Ctrl+Enter to view results...
Databases & Questions
Hint
Group by both name columns and keep the groups that occur more than once.