Changes between Version 10 and Version 11 of AdvancedReports

Timestamp:

02/12/24 18:42:57 (4 months ago)

Author:

141515

Comment:

--

AdvancedReports

@@ -25 +25 @@
         then 'Eco Tax Relief Possible'
 end
-) as Tax_Relief
+) as Tax_Relief,
+(case
+        when (v.body='Van' or v.body='Truck') and v.status=true
+        then v.price-(v.price*0.19)
+end
+) as Price_For_Companies
 from dealership d
 join vehicle as v on d.tax_nr=v.tax_nr