select id, NewsHeadline as news_headline, NewsText as news_text, state, CreatedDate as created_on from News WHERE CreatedDate>=DATEADD(DAY,-7,GETDATE())