482954 Mysql PHP Script Output 2 Html Tables

We need a top coder to write a php /mysql script to extract data from the Mysql table. The original table has 55,000 rows, but we will give you a sample table of about ~1000 rows. The table has 17 columns, you will operate on about 6 of them. We need you to query data from many entities, and or products. First script For each entity find the following attributes: • A set of products below a given price • Max and Min Prices • Average Prices • Median Prices • Counts Output: A html table with entity list across the top, with attributes in rows. Second Script We will also provide a list (small table) of product names which will be also used to query the larger table. This table will consist of 50-100 names, with one data column. For each product within each entity find the following: • A set of products below a given price • Max and Min Prices • Average Prices • Median Prices • Counts Output: A html table with entity list across the top, with product attributes in rows. For those bidders we may like to work with, we will send more detailed information.