Using a CTE, compute each doctor's total revenue (sum of billing amounts from their visits). Then rank doctors by revenue within their department using DENSE_RANK. Return department name, doctor full name, total_revenue, and dept_revenue_rank. Order by department name, rank.