ROUND(SUM(CASE WHEN L.status != 'completed' THEN 1 ELSE 0 END) /COUNT(1),2) AS 'Cancellation Rate' ...

SUM(CASE WHEN operation = 'Buy' THEN price ELSE 0 END) AS total_buy, SUM(CASE WHEN operation = 'Sell' THEN price ELSE 0 END) AS total_sell ...