Work around for Count distinct using Partition by

Database

Work around for Count distinct using Partition by

Hi, I realize you can't do a count distinct with partition by so I'm looking for a workaround. How do I combine the 2 tables to give me the result table? Thank you!

Tags (1)