Changes between Version 3 and Version 4 of AdvancedDatabaseReports

Timestamp:

12/19/22 17:14:52 (2 years ago)

Author:

181085

Comment:

--

AdvancedDatabaseReports

@@ -8 +8 @@
 
 {{{#!sql:
-SELECT d.driver_id, SUM(d.km_travelled) as km_travelled_with_driver, SUM(pay.total_sum_payed) as total_price_paid 
+SELECT d.driver_id, SUM(d.km_travelled) as km_travelled_with_driver, 
+SUM(pay.total_sum_payed) as total_price_paid 
 FROM request r
 JOIN drive d ON r.request_id = d.request_id 
 JOIN payment pay ON pay.passenger_id = r.passenger_id
-WHERE r.passenger_id = '77d9c766-e0c1-4e53-86d0-bafc3101a1ac' AND d.start_time between now() and now() - interval '2 months' 
+WHERE r.passenger_id = '77d9c766-e0c1-4e53-86d0-bafc3101a1ac' AND 
+d.start_time between now() and now() - interval '2 months' 
 GROUP BY d.driver_id }}}