I have this table and I want to create a view that only shows me the 2 names that sold the most. How can I do it ?
ID | Name | sold | date |
fdsfsd | Eduardo | 10 | 02/20/2022 |
fdsf23 | Jack | 200 | 02/20/2022 |
fdsf54 | Sam | 600 | 02/20/2022 |
fdsf76 | Bill | 200 | 02/20/2022 |
fdsf43 | Eduardo | 200 | 02/20/2022 |
fdsf76 | Bill | 100 | 02/20/2022 |
fdsf65 | John | 20 | 02/20/2022 |
fdsf23 | Sam | 30 | 02/20/2022 |
User | Count |
---|---|
18 | |
10 | |
8 | |
6 | |
5 |