SQL query to find duplicate values in a scenario

• Use the GROUP BY clause to group the values

• Use the HAVING clause to filter out groups with count greater than 1

• Select the columns with duplicate values