medium to hard SQL questions

The Great Department Audit: Balancing the Medical Staff at City Hospita The hospital board just a scovered that some plepartments are overwhelired anile others are understaffed The Chief Medical Officer storms into your office "We need to see exactly how many doctors we have in each department-NOW! She suspects the Cardiology department is overloaded while Emergency might be dangerously understaffed. Your mission. Write a SQL query to display each department name along with the count of doctors assigned to it. Make sure to include ALL departments (even those with zero doctors-we need to know where the gaps arel). Order the results by doctor count in ascending order so the CMO can immediately see which departments need attention. The hospital's efficiency-and patient care - depends on getting this right! ▲ CRITICAL WARNING: Column names in your answer must EXACTLY match those shown in the sample output (including capitalization, spacing, and punctuation). ANY deviation in column naming will result in ZERO MARKS/AUTOMATIC FAILURE for this question. Sample Output department_name doctor count 5 5 5

Emergency Blood Alert: Finding AB- Donors Problem Description View Schema It's 2 AM at City General Hospital, and the ER just received a critical case requiring AB-blood-one of the rarest blood types. The blood bank is running low, and Dr. Sarah needs to quickly identify potential patient donors who might help. As the hospital's database analyst, you've been urgently called to help. Write a SQL query to find the total count of patients in the system who have blood type 'AB-'. Every second counts - lives depend on this information! ▲ CRITICAL WARNING: Column names in your answer must EXACTLY match those shown in the sample output (including capitalization, spacing, and punctuation). ANY deviation in column naming will result in ZERO MARKS / AUTOMATIC FAILURE for this question Sample Output patient_count 5