Question

Q3: Find the top 2 accounts with the maximum number of unique patients on a monthly
basis.
Patient logs table
Account Id | date | Patient Id
1 2-1-2020 100
1 27-1-2020 200
2 1-1-2020 300
2 21-1-2020 400
2 21-1-2020 300
2 1-1-2020 500
3 20-1-2020 400
1 4-3-2020 500
sample output Month | Account ID | no of unique patients
January 2 3
January 1 2
March 3 1
*Note: Prefer the Account Id with the least value in case of same number of unique patients

Answer 1

Explanation:

cxo-dsux-enx com grl join