Changes between Version 7 and Version 8 of Ф4

Timestamp:

12/19/23 11:02:30 (9 months ago)

Author:

153135

Comment:

--

Ф4

@@ -25 +25 @@
 ORDER BY total_plans_paid DESC \\
 
+== Извештај за вкупен број на корисници кои имаат и кои немаат лојалити картичка ==
+
+SELECT \\
+'Loyality Card Users' AS user_category,\\
+COUNT (DISTINCT lc.user_id)AS total_users\\
+FROM LoyalityCardUser lc\\
+UNION \\
+SELECT \\
+'Non-Loyality Card Users' AS user_category,\\
+COUNT (DISTINCT nlc.user_id) AS total_users\\
+FROM NoLoyalityCardUser nlc\\
+WHERE nlc.ordinal_user=1\\
 
 
-
-
-