Merging queries with left outer join

The emergency department director requested a triage score breakdown by total visits. They want to understand the distribution of Emergency Severity Index (ESI) scores throughout the data collection period for department b.

ESI levels are numbered 1 through 5, with level 1 indicating the greatest urgency. Visits with ESI from 1 to 3 are considered higher acuity and require higher resources than visits at levels 4 to 5, so keeping track of staffing and resource planning is important.

Your task will be to combine the triage data with the master visit data to prepare this analysis.

If you lost progress, load the workbook '11mergingquerieswithleftouterjoin.xlsx' from the Workbooks folder and launch the Power Query editor._