Capstone project on SQL "Education for All"

I am thrilled to present my SQL capstone project "Education for all Fundraising" using SQL For Data cleaning and analysis.
The Data set was made available to us by 10ALYTICS for an organization to improve the skills we have learned as a data analyst working for a charity organization as it entails e data on donor insights and donation rates.
The Key objectives were;
- Increase the number of donors in your database
- Increase the donation frequency of your donors.
- Increase the value of donations in your database

Queries to Consider
1. JOIN
2. ORDER BY
3. WHERE
4. BETWEEN
5. AND
6. OR
7. SUM()
8. COUNT()
9. AVG()
10. GROUP BY
11. HAVING

Findings and Recommendations
There is a direct relationship between the ability to speak a second language and the value/frequencyof donation. Donors who could speak a second language probably preferred the second language to the first, and thus did not respond to emails or invitations to charity donations. Their job fields cut across many sectors and thus if they are in a country different from where the charity organization is situated and where another language they understand is spoken, there is a tendency that they will not respond to emails and invitations. It is, therefore, necessary for the charity organization to provide translation tools within the email for clients who may prefer to read their letters in a second language.
More email marketing strategies and physical representation are needed in states that recorded low donations. This will increase the donations received. In addition, more programs should be organized for loyal donors, who share the vision of the charity organization and donate daily, weekly, monthly, and yearly basis. Gift items should also be presented to them to show appreciation and renew their commitment.

Conclusion
The data shows that ability to speak a second language and a low level of education can negatively affect the frequency and value of donation received.