Q:

How do I exclude SQL data that is in current Week of Year

Currently I have some SQL which works well, except that I am continuously having to remove the first line of the results, as it only contains (at this point, being Monday 17th) data for part of the week, and being grouped by this field it is showing 'fake data'
Here is the current code:
SELECT
    YEAR(submitted)  YEAR,
    COUNT(request)   Total_Requests,
    DATEPART( wk, submitted) WEEK
FROM
    wv_external_statistics
WHERE
    userid <> 'anonymous'
GROUP BY
    YEAR(submitted),
    DATEPART( wk, submitted)

Here is some sample data:
YEAR | Total_Requests | WEEK
2017 |      361       | 28
2017 |     2486       | 27
2017 |     2860       | 26
2017 |     4521       | 25
2016 |     2600       | 52
2016 |     3028       | 51
....

As you can see the top row is the current week, and as we are only at the first day of the week the data is not complete, so I want to exclude this row from my results... I just tried the below, and immediately zero rows were found, so I am clearly doing something silly, which I am hoping someone can point out?
DATEPART( wk, submitted) <= DATEPART( wk, submitted)-1

NOTE: I need to keep all the data from the year 2016, even though it's week number will be greater than this week, the year will be from previous years. 
Cheers

A:

If you want to remove the current week. Why not just throw this in the where clause...
Where
Datepart( wk, submitted) != datepart(wk,getdate())

