Changes between Version 14 and Version 15 of AdvancedDatabaseReports

Timestamp:

01/29/23 19:27:08 (17 months ago)

Author:

181085

Comment:

--

AdvancedDatabaseReports

@@ -25 +25 @@
 
 {{{#!sql:
-SELECT dr.driver_id, dr.email, c.make, c.model, (CASE WHEN num_grades > 2 THEN AVG(de.grade) ELSE NULL END) as driver_grade, COUNT(*) as number_of_drives, 
+SELECT uuid_generate_v4() as id, dr.driver_id, dr.email, dr.first_name as driver_name, dr.surname as driver_surname, c.make, c.model, (CASE WHEN num_grades > 2 THEN AVG(de.grade) ELSE NULL END) as driver_grade, COUNT(*) as number_of_drives, 
 SUM(p.total_sum_payed) as total_money_made, COUNT(DISTINCT de.request_id) as number_of_different_requests,
 COUNT(DISTINCT r.passenger_id) as number_of_different_passengers, (SUM(p.total_sum_payed))/COUNT(DISTINCT de.request_id) as average_money_per_request,
@@ -35 +35 @@
 JOIN payment p ON de.drive_id = p.drive_id 
 LEFT JOIN request r ON de.request_id = r.request_id 
-GROUP BY dr.driver_id, dr.email, c.make, c.model
+GROUP BY dr.driver_id, dr.email, dr.first_name, dr.surname, c.make, c.model
 ORDER BY driver_grade DESC
 }}}