Mid-Sized Pickup Truck Depreciation Estimate

SELECT mk.id as makeId, mk.name as makeName, m.id as modelId, m.name as modelName ,md.* FROM vehicleCategoryMapping vcm, makes mk, models m LEFT JOIN modelDepreciation md ON m.id=md.id WHERE vcm.modelId=m.id AND m.makeId=mk.id AND vcm.categoryId=9 AND m.active=1 ORDER BY makeName, modelName

Chevrolet Colorado (no data)
Honda Ridgeline (no data)
Nissan Frontier (no data)
Toyota Tacoma [remove ]

Note: These depreciation rates are third-party estimates calculated by analyzing the used car market in the United States. We offer no guarantee that your vehicle will depreciate at the rate we have estimated. Sale prices and depreciation rates can vary significantly between trim lines, seller location, and time of year. For our figures, we calculate an "average selling price" for each model/year combination. This value is compared to used car listing prices to estimate the depreciation rate for a model. This methodology slightly underestimates depreciation by assuming the asking price for used car listings reflects the amount of money a person selling a used car can expect.