Help with complex query

[bubbadawg]

I have a projects_tbl setup with the following fields: project_id, project, hours, and date. I am trying to run a query that will return each (unique) project, total hours for the entire project and number of days the project took to complete (difference between first date entry and last date entry).

 

I am able to come up with part of the query:

 

"SELECT project, SUM(hours) AS hours from projects_tbl GROUP BY project."

 

However, I am thinking that the remaining part might be above my pay grade as I am not a MySQL expert. Any help is greatly appreciated. 

[fenway]

You should be able to get MAX(yourDate) and MIN(yourDate) and then do the math.

[bubbadawg]

Can my entire query be done in one SQL statement? This is where I seem to be getting tripped up as I am not sure of the exact syntax to get my desired results.

 

Thanks.

[bubbadawg]

Okay, I think this will return what I need unless there is a better / more efficient way to do it.

 

SELECT project, MAX(date), MIN(date), SUM(hours) from projects_tbl GROUP BY project

[fenway]

Yup.