HOW TO GET PREVIOUS 7 DAYS DATA FROM TODAY IN SQL SERVER : I have a `DataEntry` Table(`GuestAddressData`) with Users `Data.Columns` are `UserId,EDate` (type `DateTime`)and etc. I need to fetch Count of Users from `Today` to previous `7 Days` .(use for show in Graph)

Query 

    SELECT 
      row_number() over (order by (SELECT 1)) ID,
      count(*) Total,
      LEFT(Datename(weekday, Cast(EDate as date)), 3) Day
    FROM 
      CRM0001GuestAddressData
    WHERE
      EDate >= dateadd(week, datediff(d, -1, 2018-09-25-2)/7, -1)
    GROUP BY
      Cast(EDate as date)
    ORDER BY
      Cast(EDate as date)


but this is not correct?How to SOLVE IT?