title: SQL Calculate week number from a date column
body: <p>I have the following database schema
  Facts(ReportNo, ReportName, Load_Date)</p>
  
  <p><strong>Load_Date</strong> is a column of (<strong>number</strong> type) and has
  records of date in YYYYMMDD Format.</p>
  
  <p>I need to print the week number for each row using the already existing dates
  in Load_Date. Since it is already of type <strong>number</strong>, I do not have to convert it from date to char.</p>
  
  <p>Output should be
  **Week Number | ReportNo | ReportName</p>