Rank the dealerships by 2018 revenue, join in their 2018 tar…
Rank the dealerships by 2018 revenue, join in their 2018 target, and mark each as “met” or “missed.” Return the ranked list, then write a three-to-four sentence summary a manager could read: who led, who lagged, and whether leading on revenue meant meeting target.Hint: build the 2018 per-dealership revenue in a CTE, join dealership_targets for the 2018 target, then rank and compare in an outer query.