I want to set data from following table group by Weeks in SQL. : Date                               Amount             Product
2018-10-25 05:27:35.9070422         1000                 P1
2018-10-18 05:27:35.9070422         2000                 P2
2018-10-2 05:27:35.9070422          3050                 P3
2018-10-10 05:27:35.9070422         1000                 P4
2018-10-5 05:27:35.9070422          1000                 P5

Let suppose today is 26-05-18

So my result should look like this.


Week                    Amount
 1                       4050
 2                       1000
 3                       2000
 4                       1000