SQL Interview Question | EY

[@manojsmart9831]

🔥💯

[@shabeerkhan379]

Pls explain using pivot function?

[@DILLIPAKUMARCHOUDHARY]

select * from ( SELECT COUNTRY,AMOUNT,product FROM PRODUCT)pivot(max(amount) for product in ('banana'BANANA,'carrots' CARROT,'beans' BEANS,'orange' ORANGE)) order by 1;

[@codinglake]

Good 💯😊