Ok, from this basic query that select ALL unbilled items from the unbilled_item table along with the respective project manager for each job from the job table, is it possible to sum the unbilled_item.amount's associated with each unbilled_item.job_number and then order by this total.

So, I am trying to list jobs by total unbilled amount.

Many thanks.

Code:
	$sql = "
	SELECT unbilled_item.job_number,unbilled_item.week_ending,unbilled_item.amount,job.project_manager
	FROM unbilled_item 
	LEFT JOIN job ON (unbilled_item.job_number=job.job_number)
	" ;