Changes between Version 2 and Version 3 of AdvancedReports

Timestamp:

02/05/24 15:53:42 (13 months ago)

Author:

141515

Comment:

--

AdvancedReports

@@ -5 +5 @@
 {{{
 select
- 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
+  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
 where amount>3000
 group by d.d_name