SQL 75

#1 Outlier Patient Height Search SELECT & WHERE Google Easy #2 Allergy Alert for Penicillin WHERE Clause Amazon Easy #3 East Coast Patient Base IN Operator Meta Easy #4 Active Asthma Patient Search Logical Operators Apple Easy #5 High-Cost Admissions Audit Comparison Operators Netflix Easy #6 Patients with No Allergy Records IS NULL Microsoft Easy #7 Allergy-Specific Patient Cohorts Wildcards & LIKE Stripe Medium #8 Patient Weight-to-Height Outliers CASE & Arithmetic Uber Medium

#9 Global Patient Directory Count COUNT Google Easy #10 Extreme Weight Metrics MIN & MAX Amazon Easy #11 Inpatient Stay Cost Metrics AVG & SUM Meta Easy #12 Hospital Admissions Count by Gender GROUP BY Apple Easy #13 Metropolitan Patient Concentration GROUP BY & HAVING Netflix Medium #14 Average Inpatient Cost by Diagnosis GROUP BY Microsoft Medium #15 Province Allergy Breakdown Group and Aggregation Stripe Medium #16 Attending Doctor Patient Counts GROUP BY & COUNT Uber Medium #17 Height Statistics by Province Multi Grouping Airbnb Medium #18 Diagnosis Outliers Analysis Multiple Aggregation Outliers Snowflake Hard

#19 Patient and Province Mapping INNER JOIN Google Easy #20 Attending Physician and Patient details Multi INNER JOIN Amazon Easy #21 Admissions with Associated Doctor Specialties INNER JOIN Meta Easy #22 Patient Province List INNER JOIN & GROUP BY Apple Easy #23 High Cost Admissions with Doctor Specialties JOIN & Filter Netflix Easy #24 Unmatched Patients Analysis LEFT JOIN Microsoft Medium #25 Doctors with Zero Inpatients LEFT JOIN Stripe Medium #26 Same-Allergy Geographic Co-location Self Join Uber Medium #27 Financial Metrics per Medical Specialty INNER JOIN & Grouping Airbnb Medium #28 Cross-Provincial Specialty Availability CROSS JOIN Snowflake Medium #29 Outlier Treatment Auditing Multi-Join Filtered ByteDance Hard #30 Patient Multi-Admission History Self Join & Aggregation Pinterest Hard

#31 Above Average Height Demographics Scalar Subquery Google Easy #32 High Cost Admissions with Scalar Filter Scalar Subquery Amazon Easy #33 Doctors with Attended Cases IN Operator Meta Easy #34 Gender-Specific Height Outliers Correlated Subquery Apple Medium #35 Patient's Peak Admission Cost Correlated Subquery Netflix Medium #36 Doctors who Only Treated Allergy-Free Patients NOT EXISTS Microsoft Medium #37 High Average Weight Cities HAVING Subquery Stripe Medium #38 Patient Birth Date Provincial Outliers Correlated Subquery Uber Medium #39 Doctors Complex Allergy Cases Correlated EXISTS Airbnb Hard #40 Admission Cost Deviation per Diagnosis Correlated Subquery Snowflake Hard

#41 Obese Patient Analysis using CTE Basic CTE Google Easy #42 Admissions Summary CTE Basic CTE Amazon Easy #43 Province Costs Exceeding Average CTE & Subquery Meta Medium #44 High Volume Doctor Load CTE with Join Apple Medium #45 Most Frequent Diagnosis CTE CTE Max Filter Netflix Medium #46 Monthly Revenue Distribution Date String CTE Stripe Medium #47 Identify Premium Patient Cohorts Advanced CTE Statistics Uber Hard #48 Geographic Doctor Revenue Leader Multiple CTEs with Max Partition Snowflake Hard

#49 Row Number Weight Ranking ROW_NUMBER Google Easy #50 Dense Rank Height Partition DENSE_RANK Amazon Easy #51 Inpatient Cost Next to Average AVG OVER Meta Easy #52 Admissions Historical Cost Differences LAG Apple Medium #53 Categorize Patients in Height Quartiles NTILE Netflix Medium #54 Admissions Running Cost Total SUM OVER Running Total Microsoft Medium #55 Provincial Weight Averages next to Patient Weight AVG PARTITION OVER Stripe Medium #56 Attending Doctor Historical Case Load COUNT PARTITION OVER Uber Medium #57 First Diagnosis Window Function FIRST_VALUE Airbnb Medium #58 Most Recent Patient Admission details CTE ROW_NUMBER Partition Snowflake Hard #59 Identify Volatile Admission Cost Outliers LAG & LEAD Together ByteDance Hard #60 Top 2 Billing Admissions per Diagnosis DENSE_RANK Partition Filtering Pinterest Hard

#61 Categorize Patients by Weight Classes CASE WHEN Operators Google Easy #62 Monthly Inpatient Volume Timeline Date String Grouping Amazon Medium #63 Format Patient Names Capitalization String Functions Meta Medium #64 Extract Patients with Multi-Allergies String Length and Replace Apple Medium #65 Coalesce Null Fields to Fallbacks COALESCE Operator Netflix Medium #66 Rapid Patient Re-admission Tracking Self Join Date Difference Stripe Hard #67 Inpatient Stays Exceeding Average Duration Date Calculations & Subquery Uber Hard #68 Provincial Financial Contribution Analysis Aggregations with Global Subquery Airbnb Hard #69 Province Average Cost Outliers Correlated Aggregation Filters Snowflake Hard #70 Geographic Same-Metric Clusters Analysis Correlated EXISTS Pinterest Hard

#71 Inspect Column Completeness Introspection Analysis Google Medium #72 Identify Duplicate Candidates in Core Schema Duplicate Identification Amazon Medium #73 Orphaned Reference Auditing Referential Integrity Meta Hard #74 Analyze SQLite System Master Catalog System Introspection Apple Hard #75 Temporal Order Constraint Audits Constraint Audits Netflix Hard