Fills bigger than the tank

Join each fuel transaction to its vehicle by CardNo = DimVehicle FuelCardNo. How many transactions put more Litres into the vehicle than its TankCapacityL?

Expected: One whole number · KPI card
Tables: FactFuelCard, DimVehicle · columns

FactFuelCard
DimVehicle

CardNo
FuelCardNo
Litres
TankCapacityL
Topics: Risk & Controls

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

Join the discussion

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us

Create a free account Sign in