Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

SELECT ROUND(volume_in,1) as 'Volume In',ROUND(volume_out,1) as 'Volume Out'
FROM reports.excel_yearly_volumes
WHERE project='GEANT2'
AND circuit_usage='Interconnect'
AND period = 201706 201707;

** Pay attention to the concatenated year and month values in the SQL statement

...