Untitled

SELECT
  TO_CHAR(pa.DELIVERED, 'MM') AS "Delivery month",
  pa.DELIVERED AS "Delivery Day",
  pa.PERIOD AS "Delivery Period",
  SUM(pa.TRADE_VOLUME) AS "P-Trade Volume-MWh",
  pa.TRADE_PRICE AS "P-Trade Price-(£)",
  a.TICKET AS "Ticket",
  a.BUY_SELL AS "Trade Buy Sell",
  a.COUNTERPARTY AS "Counterparty",
  a.MEMO AS "Memo",
  a.MEMO2 AS "Memo2",
  a.BOOK AS "Book",
  t.NAME AS "Trader Name",
  sp.EFA_PERIOD AS "EFA Block",
  a.TRADED_ON AS "Traded on Day"
FROM
  bo_user_uniper.PM_SETTLEMENT_PERIOD sp
  JOIN bo_user_uniper.PM_TRADE_PERIOD_ASOF pa ON sp.SETTLEMENT_DAY = pa.DELIVERED
  JOIN bo_user_uniper.PM_TRADE_ASOF a ON pa.TRADE_ASOF_DATE = a.ASOF_DATE
    AND pa.TICKET = a.TICKET
  JOIN POS_MGNT.BO_TRADER_MV t ON a.TRADER = t.TRADER
WHERE
  a.ASOF_DATE = TO_DATE(:End_Date, 'DD-MON-YYYY') + 1
  AND a.BOOK IN ('UPSL', 'PXHS')
  AND (a.COUNTERPARTY LIKE '%-E' OR a.COUNTERPARTY LIKE 'UPT%')
  AND pa.DELIVERED BETWEEN TO_DATE(:Start_Date, 'DD-MON-YYYY') 
                      AND TO_DATE(:End_Date, 'DD-MON-YYYY')
GROUP BY
  TO_CHAR(pa.DELIVERED, 'MM'),
  pa.DELIVERED,
  pa.PERIOD,
  pa.TRADE_PRICE,
  a.TICKET,
  a.BUY_SELL,
  a.COUNTERPARTY,
  a.MEMO,
  a.MEMO2,
  a.BOOK,
  t.NAME,
  sp.EFA_PERIOD,
  a.TRADED_ON;