Changes between Version 11 and Version 12 of AdvancedDatabaseReports

Timestamp:

12/21/22 16:51:47 (2 years ago)

Author:

181085

Comment:

--

AdvancedDatabaseReports

@@ -14 +14 @@
 {{{#!sql:
 SELECT d.driver_id, SUM(d.km_travelled) as km_travelled_with_driver, 
-SUM(pay.total_sum_payed) as total_price_paid, SUM(d.km_travelled)/SUM(pay.total_sum_payed) as price_per_km
+SUM(pay.total_sum_payed) as total_price_paid, SUM(pay.total_sum_payed)/SUM(d.km_travelled) as price_per_km
 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 = '87da7c89-fc2e-44a0-9bfa-d89de68c2a22'
 GROUP BY d.driver_id 
-ORDER BY price_per_km ASC 
+ORDER BY price_per_km ASC
 }}}
 
@@ -51 +50 @@
 JOIN drive d ON r.request_id = d.request_id 
 JOIN payment pay ON d.drive_id = pay.drive_id 
-WHERE d.driver_id = '2219f3ad-48dc-4b6a-9877-143b05d6b608' 
+WHERE d.driver_id = '7c183cbe-bfb3-4e16-b831-e4f73c4f4937' 
 GROUP BY p.passenger_id , p.email 
 ORDER BY earnings_per_km DESC