select CONVERT(DATE,a.Date_PK) as Week_End_Date, CASE WHEN a.weekno=2 then  'Week 1'
WHEN a.weekno=3 then  'Week 2'
WHEN a.weekno=4 then  'Week 3'
WHEN a.weekno=5 then  'Week 4'
WHEN a.weekno=6 then  'Week 5'
WHEN a.weekno=7 then  'Week 6'
WHEN a.weekno=8 then  'Week 7'
WHEN a.weekno=9 then  'Week 8'
WHEN a.weekno=10 then 'Week 9'
WHEN a.weekno=11 then 'Week 10'
WHEN a.weekno=12 then 'Week 11'
WHEN a.weekno=13 then 'Week 12'
WHEN a.weekno=14 then 'Week 13'
WHEN a.weekno=15 then 'Week 14'
WHEN a.weekno=16 then 'Week 15'
WHEN a.weekno=17 then 'Week 16'
WHEN a.weekno=18 then 'Week 17'
WHEN a.weekno=19 then 'Week 18'
WHEN a.weekno=20 then 'Week 19'
WHEN a.weekno=21 then 'Week 20'
WHEN a.weekno=22 then 'Week 21'
WHEN a.weekno=23 then 'Week 22'
WHEN a.weekno=24 then 'Week 23'
WHEN a.weekno=25 then 'Week 24'
WHEN a.weekno=26 then 'Week 25'
WHEN a.weekno=27 then 'Week 26'
WHEN a.weekno=28 then 'Week 27'
WHEN a.weekno=29 then 'Week 28'
WHEN a.weekno=30 then 'Week 29'
WHEN a.weekno=31 then 'Week 30'
WHEN a.weekno=32 then 'Week 31'
WHEN a.weekno=33 then 'Week 32'
WHEN a.weekno=34 then 'Week 33'
WHEN a.weekno=35 then 'Week 34'
WHEN a.weekno=36 then 'Week 35'
WHEN a.weekno=37 then 'Week 36'
WHEN a.weekno=38 then 'Week 37'
WHEN a.weekno=39 then 'Week 38'
WHEN a.weekno=40 then 'Week 39'
WHEN a.weekno=41 then 'Week 40'
WHEN a.weekno=42 then 'Week 41'
WHEN a.weekno=43 then 'Week 42'
WHEN a.weekno=44 then 'Week 43'
WHEN a.weekno=45 then 'Week 44'
WHEN a.weekno=46 then 'Week 45'
WHEN a.weekno=47 then 'Week 46'
WHEN a.weekno=48 then 'Week 47'
WHEN a.weekno=49 then 'Week 48'
WHEN a.weekno=50 then 'Week 49'
WHEN a.weekno=51 then 'Week 50'
WHEN a.weekno=52 then 'Week 51'
WHEN a.weekno=53 then 'Week 52'
 else NULL end AS Week_No from
(
SELECT DATEPART(week,Date_pk) as week,Date_PK,ROW_NUMBER () over (order by date_pk desc) as weekno
FROM dbo.Dim_Date
WHERE Date_PK BETWEEN DATEADD(Week,-53,GETDATE()) AND GETDATE() and datename(dw,Date_pk)='Friday'
)a
where a.weekno not in (1)
order by Week_End_Date desc

Emai           First_Name     AccessDate.
USER1@GMAIL      ABC          14-02-2019
USER1@GMAIL      ABC          12-02-2019
USER1@GMAIL      ABC          06-02-2019
USER1@GMAIL      ABC          01-02-2019
USER2@GMAIL      CDE          11-01-2019
USER2@GMAIL      CDE          10-02-2019
USER2@GMAIL      CDE          02-02-2019
USER2@GMAIL      CDE          27-01-2019
USER3@GMAIL      EFG          13-02-2019
USER3@GMAIL      EFG          11-02-2019
USER3@GMAIL      EFG          08-02-2019
USER3@GMAIL      EFG          07-02-2019

USER_Email   FIRST_ACCESS_DATE  SECOND_ACCESS_DATE  WEEK_NUMBER    WEEK_END_DATE
USER1@GMAIL      14-02-2019       12-02-2019           WEEK 1       15-02-2019
USER1@GMAIL      06-02-2019       01-02-2019           WEEK 2       08-02-2019
USER2@GMAIL      11-01-2019       10-02-2019           WEEK 1       15-02-2019
USER2@GMAIL      02-02-2019       27-01-2019           WEEK 2       08-02-2019
USER3@GMAIL      13-02-2019       11-02-2019           WEEK 1       15-02-2019
USER3@GMAIL      08-02-2019       07-02-2019           WEEK 2       08-02-2019
USER4@GMAIL      12-02-2019       09-02-2019           WEEK 1       15-02-2019
USER4@GMAIL      07-02-2019       01-02-2019           WEEK 2       08-02-2019