Changes between Version 3 and Version 4 of AdvancedReports

Timestamp:

02/05/24 15:59:40 (13 months ago)

Author:

141515

Comment:

--

AdvancedReports

@@ -7 +7 @@
   d.d_name name,
   count(a.a_id),
-  sum(amount) from dealership d
-  left join agreement as a on d.tax_nr=a.tax_nr
-  left join payment as p on p.a_id=a.a_id
+  sum(amount)
+from dealership d
+left join agreement as a on d.tax_nr=a.tax_nr
+left join payment as p on p.a_id=a.a_id
 where amount>3000
 group by d.d_name