5) Most of our devs' SQL skills are rudimentary beginner-level (including mine). There are fewer DBAs than devs, and they tend to work on teams/projects that our outside of the customer-facing app.

To illustrate how a LEFT JOIN works, let’s simply change INNER JOIN to LEFT JOIN in our original SELECT statement, like this: SELECT Donors.DonorID,Donors.Donorname. DonationRecords.DonationAmt ...