converting row into column in postgresql having dates in header

ABHISHEK THAKUR 0
Viewed 14
select managername, count(*), date(pulldate) from daily_rentals_a where pulldate BETWEEN CURRENT_DATE-7 AND CURRENT_DATE
group by  managername,date(pulldate)
order by date(pulldate)

This is what I have in the first picture

In the second picture the expected result I need

data-analysis pivot datetime sql postgresql
0 Answers
Related