Enclosing a sample table script
Query to run
select max(day_of_week) as day_of_week, max(month) as month,order_by,
case when rep_id = 2 then goals end as Jen,
case when rep_id = 11 then goals end as Sheri
group by rep_id,goals,order_by
order by order_by
output is enclosed as spreadsheet.
Required or expected output is enclosed
I also wanted the query to give me data from the present month that we are running the report. For now from JUL onwards.
I tried using where MONTH = to_char(sysdate,'MON') that is for jul
for going upto DEC I could not get when I used >=