Changes between Version 12 and Version 13 of AdvancedReports


Ignore:
Timestamp:
01/05/23 01:14:38 (23 months ago)
Author:
201084
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • AdvancedReports

    v12 v13  
    224224
    225225{{{#!sql
    226 select rs.id_repair_shop as rs_id , rs.rs_name as rs_name , count(r2.review_rating) as review_count ,avg(r2.review_rating)::float as review_average
     226select rs.id_repair_shop as rs_id , rs.rs_name as rs_name , coalesce(count(r2.review_rating),0) as review_count , coalesce(avg(r2.review_rating),0)::float as review_average
    227227from project.repair_shop rs
    228228left join project.repair r on r.id_repair_shop = rs.id_repair_shop