SQL Tutorial - PIVOT

Thanks a lot for explaining this so clearly! This is really helpful!!

this is the first video that worked for me, thank you!!

Great stuff!

What I can understand is where are you getting [Month] from?

Great video. Very helpful. what if you dont have elements names, can it be dynamic?

Hello. I'm watching this playlist because I've watched every single minute of the window functions, which I've loved so much. One question: do we have to hardcode the names of the new columns in the <columns> part as well as after the IN? I find it quite inefficient and clunky. No way to make it code dependent? I can imagine that we can use a SELECT statement after the IN, but what about the <columns> section? Thanks!

Much apreciated for this tutorial. It was very helpful.

There should be a Heart react button for this video.
Thank you. ❤️

thank you very much

Hi I need help 😥I want to display the average in 2 decomal places but Idk how

SELECT Student, [English], [Mathematics], [Science], [Programming], [History]
FROM ( SELECT Student, Grades, Subject
FROM Grade_Report) AS SourceTable
PIVOT
(
AVG (Grades)
FOR
Subject IN ([English], [Mathematics], [Science], [Programming], [History])
) AS PivotTable

how to summarize monthly data in annual level

can u show me,
how to sum by column =>> total of sum(1),sum(2),sum(3),....

Absolutelly love your accent! Thank's for video

can u please tell how can we add a row/ column total to the pivot table

Very well explained!

thanks teacher

What is wrong with my pivot?

SELECT [United States],
[Asia],
[Canada]
FROM
(
SELECT
(SELECT country FROM regions r WHERE r.region_id = e.region_id) as [country]
FROM employees e
) AS Src
PIVOT
(
COUNT(country)
FOR country IN ([Asia],[Canada],[United States])

) AS Pivot

Thank you!

Thanks so much. This is very helpfull.

that was very helpfull thankyou broo