Fetch members payment reports in mysql

There is a community that requires that its members pay membership dues according to a schedule as listed below:

- the first fee type is a one-off non-recurring fee. it is mandatory for every member.

- the second fee type is an annual and recurring fee. it is mandatory.

- the third fee type is for voluntary and non-recurring contributions.

Using mysql, you are required to:

1. Create the following tables:

- feesType,

- members and

- fees table with the correct relationships.

2. Fetch data from the three tables, feetype, members and fees.

3. Fetch date by memberID that shows a given member all or any outstanding/pending payment obligations, the he must make.

4. Fetch data list by feetype of only those members who have not made payments based on fee type.

5. Return the count by fee type of only members who have not made payments based on fee type.

6. Fetch data that shows total income for the current year.

7. Fetch data that shows total income by fee type for the current year.

8. Fetch data and return income for the current year based on the year a member joined the community. e.g. 2019, 2018, 2017 etc

Find attached sample table shema to guide design.

Please use [login to view URL] or any tool to host the solution for review.

Skills: MySQL, Database Programming, SQL

See more: create reports mysql database, mysql statement count day today send email, wordpress members payment paypal, making excel reports mysql, payment reports clone, php session handling mysql adding count, wordpress plugin create reports mysql, emoney payment php mysql, vb6 mysql table count, cacti mysql query count, pull reports mysql excel, create excel reports mysql, mysql record count joomla, php mysql duplicate count, pulling reports mysql, mysql loop count average

About the Employer:
( 2 reviews ) Lagos, Nigeria

Project ID: #20435473

Awarded to:


Hi I am very interested in your project. As for me, I am a full-stack developer with 6+ years in the web development. If you hire me, I will devote my full time only for you and guarantee high quality and deadline More

$30 USD in 1 day
(20 Reviews)

3 freelancers are bidding on average $23 for this job


Hello! I am a web developer. I have checked your project description. If you hire me, I am gonna do my best. I guarantee the good result. I will wait for your reply. Thank you.

$20 USD in 7 days
(7 Reviews)

Hello Dear. How are you? Nice to meet you. After reading your job description in details I am very interesting in your job. The best quality, accurate timeline are what I guarantee to my clients. I am a full stack Web More

$20 USD in 7 days
(2 Reviews)