Hi everyone. I had a question regarding a small task i've been put with. Below I have pasted the question and a screenshot of the database layout. Now I just don't understand what exactly i'm ment to be creating, a user defined function maybe? But how.. Question: Calculate and return the total estimated chargeable cost of a stage taking into account the different charge rates applicable for different tasks (assuming that all the work for the stage has been assigned). Screenshot of DB layout: http://tinypic.com/view.php?pic=2dtvg3l&s=5 Not a clue :/ Any hints or tips to create the SQL output needed would be great help, thanks.
I'm guessing it involves STAGE, TASK, TASK_TYPE, and CHARGE_GRADE, but I can see it involving others, as well. I have the table information (as shown below). Just the sql to connect and SUM them up I guess is where i'm confused I think. Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting