In some scenarios, we may need to count distinct values based on more complex conditions that can’t be easily handled …

specify list a column list and omit your auto_incremented column from it as njk suggested.   That would be the best app…