Oracle Sql Download ((install)) -

-- Define report title TTITLE CENTER '========================================' SKIP 1 - CENTER 'EMPLOYEE SALARY REPORT' SKIP 1 - CENTER '========================================' SKIP 2

SELECT TO_CHAR(sale_date, 'YYYY-MM') AS sale_month, COUNT(*) AS total_transactions, SUM(amount) AS total_revenue, ROUND(AVG(amount), 2) AS avg_sale_amount FROM sales WHERE sale_date >= TRUNC(SYSDATE, 'MM') GROUP BY TO_CHAR(sale_date, 'YYYY-MM') ORDER BY sale_month DESC; oracle sql download