Select DH.DH_Position,L.LOC_NAME, DH.DH_Name, sum(NVL(si.si_income1,0)) as Value From LOCATION_GROUP_TYPES gt inner join LOCATION_GROUPS g on gt.LGT_ID = g.LG_LGT_ID inner join locations l on g.LG_LOC_ID = l.LOC_ID Left join SITE_INCOME si on si.si_loc_id = l.loc_id inner join Department_Headings DH on DH.DH_Position = 1 Where (LOC_DATE_CLOSED is null or to_char(LOC_DATE_CLOSED,'YYYY') >= 2016) and gt.LGT_REGION is not null and si.si_year = 2016 and si.si_week Between 10 and 10 and gt.LGT_DESCRIPTION = 'NORTH WEST AND NORTH MIDLANDS' and L.LOC_NAME = 'CHORLTON' group by DH.DH_Position,L.LOC_NAME, DH.DH_Name
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Connect with Certified Experts to gain insight and support on specific technology challenges including:
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE