Aggregating and Organizing Data Practice Links-2

 

 

Grouping, Summarizing and Organizing Data in Result Sets

 

You can use the Sample Database form the MySQL Tutorial Website to practice the activities illustrated in the links below.  

Here is a Link to Download the My SQL Tutorial Sample Database

mysqlsampledatabase-1.sql Download mysqlsampledatabase-1.sql

 

 

 

Adding the GROUP BY Clause to a SELECT statement

 

http://www.mysqltutorial.org/mysql-group-by.aspx Links to an external site.

 

 

Adding the HAVING Clause to a SELECT statement

 

http://www.mysqltutorial.org/mysql-having.aspx Links to an external site.

 

 

Sorting Results Sets Using the ORDER BY Clause

 

http://www.mysqltutorial.org/mysql-order-by/

 

http://www.mysqltutorial.org/mysql-natural-sorting/ Links to an external site.