SQL Subquery & CASE Practice: Insurance-Based Admission Cost Analysis

Practice SQL subqueries and CASE statements by analyzing hospital admission costs based on insurance status. In this task: Patients with even patient_ids are assumed to have insurance. Admission costs are: $10 with insurance $50 without insurance Focus Areas: CASE conditions Mathematical filtering (patient_id % 2) Aggregation using GROUP BY Subquery usage for cost classification