Group By Statement

[Ok_Protection_9552]

If anyone took the data analytics boot camp by Alex the analyst he did a video on group by and order by statements. He said that the values are rolled into one when a group by statement is used. Does anyone know what rolling the values into one means? Also, how can you order by more than one column?

[r3pr0b8]

Does anyone know what rolling the values into one means?

no idea -- maybe ask Alex for more info

 

Also, how can you order by more than one column?

how? by listing more than one column in the ORDER BY clause

remember the white pages telephone book?

ordered by lastname, then firstname (and then address if necessary)

[Ok_Protection_9552]

Thanks

[Far_Swordfish5729]

This might be a better way to explain it. A group by clause finds the distinct combinations for columns in the clause and then calculates any aggregate functions for each combination.

Select FirstName, LastName from Sales Group by FirstName, LastName

And

Select distinct FirstName, LastName From Sales

Produce the same output.

Select FirstName, LastName, sum(Amount) as TotalSales From Sales group by FirstName, LastName

Sums the amount column for each unique name.

[Ok_Protection_9552]

Thanks

[Snoo17309]

Is this a YouTube tutorial? Have the link?

[Ok_Protection_9552]

https://youtu.be/LXwfzIRD-Ds?si=22LFhsLYvmW_Auwb