Mysql Data Query Tool

Build a web-based tool to query my database:

Tool outputs the data as an Excel spreadsheet with this information:

Report Summary
Date of Report: (format September 14, 2010)
Total members: A
Total comments: B
Total Friendships: C
Total Private Messages: D

Membership by Gender: 50% Male 50% Female
Age – represented as a percentage

Association with (field will be told to you) – count, and as a percentage
City – Count by city – top 25, count, and as a percentage
State – Count by state – top 25, count, and as a percentage
Country – Count by country – top 10, count, and as a percentage

Members that have not logged in within XX number of days

Members that do not have a photo present: First name, last name, and email address

Members that do not have an album present: First name, last name, and email address

Members that have not posted on the forum: First name, last name, and email address

PROJECT BUDGET IS $30-40. RESPOND WITH THE PHRASE HAGAJI SO THAT I KNOW YOU HAVE READ AND UNDERSTAND THIS PROJECT.

Leave a Reply

Your email address will not be published. Required fields are marked *