Merging queries with inner join

At the latest departmental meeting, the chief Emergency Physician mentioned they had noticed an increase in patients presenting to the emergency department for abdominal pain.

You must combine the emergency visit data with the visit chief complaint data to assess this relationship. They are also interested in appropriately assessing the admission rate to plan for resources.

Admission Rate is calculated as the percentage of total visits with disposition of "admit" out of total emergency department visits.

Admission Rate (%) = visits with admit disposition / total visits

If you lost progress, load the workbook '12mergingquerieswithinnerjoin.xlsx' from the Workbooks folder and launch the Power Query editor.