Dear All Friend Please find result
| Date | Name | Age | Category |
| 6-Oct-19 | Name_1 | 12 | 1 |
| 6-Oct-19 | Name_2 | 12 | 2 |
| 7-Oct-19 | Name_3 | 3 | 1 |
| 7-Oct-19 | Name_4 | 4 | 1 |
| 10-Oct-19 | Name_5 | 5 | 2 |
| 10-Oct-19 | Name_6 | 5 | 2 |
| 10-Oct-19 | Name_7 | 6 | 2 |
| 10-Oct-19 | Name_8 | 12 | 3 |
| 10-Oct-19 | Name_9 | 32 | 3 |
| 5-Oct-19 | Name_10 | 50 | 4 |
| 5-Oct-19 | Name_11 | 34 | 4 |
| 5-Oct-19 | Name_12 | 23 | 4 |
| 5-Oct-19 | Name_13 | 1 | 5 |
| 5-Oct-19 | Name_14 | 2 | 5 |
| 5-Oct-19 | Name_15 | 1 | 5 |
Output Result
| 1 | 2 | 3 | 4 | 5 |
| Name_1 12 6-Oct-19 | Name_2 12 6-Oct-19 | Name_8 12 10-Oct-19 | Name_10 50 5-Oct-19 | Name_13 1 5-Oct-19 |
Name_3 3 7-Oct-19 | Name_5 5 10-Oct-19 | Name_9 32 10-Oct-19 | Name_11 34 5-Oct-19 | Name_14 2 5-Oct-19 |
Name_4 4 7-Oct-19 | Name_6 5 10-Oct-19 | | Name_12 23 5-Oct-19 | Name_15 1 5-Oct-19 |
| | Name_7 6 10-Oct-19 | | | |
use
SQL Server Query