I have the data source below:
I'm having a hard time figuring out how will I able to find out the percentage of duplicates on the first column.
I tried using COUNTDISTINCT and GROUPBY but no success.
Can anyone help or provide me guidance on this?