sql sum with group by left join oracle query

Solutions on MaxInterview for sql sum with group by left join oracle query by the best coders in the world

Search
showing results for - "sql sum with group by left join oracle query"
Norah
01 Jan 2020
1select 
2   q.sp_question_id,
3   count(p.project_id) as projectCount,
4   sum(p.funding) as amount,
5   round(sum(p.funding)/sum(sum(p.funding)) over() *100) as percentTotal 
6from questions q 
7   left join objectives o on 
8         o.sp_question_id = q.sp_question_id 
9     and o.fiscal_year = 2014 
10   left join projects p on o.fiscal_year = p.fiscal_year and o.sp_objective_id = p.sp_objective_id 
11   left join funders f on p.funder_id = f.funder_id and f.funder_short_name ='foo' 
12where q.fiscal_year = 2014 
13group by q.sp_question_id 
14order by q.sp_question_id;
15
source
similar questions
sql group by sum with conditionoracle sql group by date yearsql avg group bysql query row number group byhow to select a column not in group by clause in oraclehow to use group concat in sql serversql sum and other fieldssql count group bysql group by yearsum with group by in sql servergroup concat sql serversql select sum group by id laravelsql group by sumgroup by time oracle sqlsql server group by concatenatemysql sum with group byora 00979 not a group by expression in oracle 19cmysql sum group bysql select sum group by id laravel joinsum group by sqlgroup by is always tied together with an aggrigate function in sql
queries leading to this page
sql get sum group by joinsql sum group by nulloracle sql sum all despite group byoracle sql sum over all in group bygroup by sum in oracle dbsql query sequence select sum group by from joinsql sum group by is returning nulloracle sql total sum when in group bysql sum with group by left join oracle query