Changes between Version 2 and Version 3 of Advanced Database Reports (SQL and Stored Procedures)

Timestamp:

08/28/25 22:58:23 (5 days ago)

Author:

221531

Comment:

--

Advanced Database Reports (SQL and Stored Procedures)

@@ -42 +42 @@
 SELECT
     u.user_id,
-    u.first_name || ' ' || u.last_name AS customer_name,
-    TO_CHAR(o.order_date, 'YYYY-MM') AS year_month,
-    COUNT(DISTINCT o.order_id) AS num_orders,
+    u.first_name || ' ' || u.last_name AS customer_name,\\
+    TO_CHAR(o.order_date, 'YYYY-MM') AS year_month,\\
+    COUNT(DISTINCT o.order_id) AS num_orders,\\
     SUM(oi.total_price) AS total_spent
 FROM app_user u\\