Co NTI MEF PLO TIN /S, CTS SELECT otbl.order_id AS 'Order ID', otbl.order_date AS 'Order Date', otbl.order_total_revenue AS 'Revenue', SUM(oltbl.quantity) AS 'Volume FROM orders otbl INNER JOIN inner join order_line_item olitbl ON otbl.order_id = olitbl.order_id GROUP BY otbl.order_id AS 'Order ID', otbl.order_date AS 'Order Date otbl.order_total_revenue AS 'Revenue