In Progress

Write MYSQL queries to calculate specific data and then insert the result into a field

Before you bid, please open the Excel Document and View the sample. No BID Will be accepted unless I receive a message from you first.

Using the attached excel sheet, I need help creating MYSQL SELECT statement to calculate data from some tables and INSERT the result into the tables.

Table 1:

T6 - Total the columns where times are set for each day

U6 - Total the number of hours for each day

Add results to the table

Table 3:

E37:K56 - Count How Many Times each tbl2_id is between tbl1_start and tbl1_end

L36 - Total the columns for each day there is a time

M36 - Total the number for each day

P36 - tbl3 total number of days divided by tbl1 total number of days= Average number of days

Q36 - tbl3 total number of hours divided by tbl1 total number of hours = Average number of hours

R36 - Average those two averages

Add results to the table

Table 4:

D60 - Average all the results from Table 3 R36 by tbl1_id and location_id

Add result to the table

Skills: Data Entry, Database Administration, Database Programming, MySQL, SQL

See more: mysql insert select multiple rows, insert into select mssql, insert query in mysql php, mysql insert into select, mysql select specific columns, mysql insert values from select, mysql insert multiple rows, mysql insert example, Simple data entry of price range into excel sheet, i have 60 business cards which i need the data to be entered into an excel sheet each category to have, write mysql query smarty, write mysql query vbulletin template, cronjob email result mysql query perl, write mysql query php, write mysql update query

About the Employer:
( 8 reviews ) Homestead, United States

Project ID: #15642122

Awarded to:

HouGuoQiang

SELECT SUM(tbl1_start_1 IS NOT NULL) + SUM(tbl1_start_1 IS NOT NULL) + SUM(tbl1_start_3 IS NOT NULL) + SUM(tbl1_start_4 IS NOT NULL) + SUM(tbl1_start_5 IS NOT NULL) + SUM(tbl1_start_6 IS NOT NULL) + SUM(tbl7_start_1 IS More

$25 USD in 1 day
(2 Reviews)
2.1

5 freelancers are bidding on average $40 for this job

softcarve

MM. Hi, I have seen the excel and would like to do the task. please get in touch to discuss more. Relevant Skills and Experience sql, mysql Proposed Milestones $55 USD - completion

$55 USD in 2 days
(28 Reviews)
5.0
amutinda

A proposal has not yet been provided

$50 USD in 1 day
(16 Reviews)
4.2
prabakarm23

Worked on SQL and Access Databases, I can make this project as expected, I have reviewed the Excel file and I can make queries for the requested scenarios. Relevant Skills and Experience Worked on VB, VBA, .NET with I More

$55 USD in 1 day
(27 Reviews)
4.2
mdyounuskhan726

Hello dear sir. am interested in your [url removed, login to view] sandsand mme aa message so that we discus [url removed, login to view] I am expert some to your work.

$15 USD in 5 days
(1 Review)
1.1