Description
In this course, you will learn :
- Learn how to apply filters to numeric and text data, as well as how to sort the results.
- how to use SQL Server aggregate functions like SUM, COUNT, MIN, MAX, and AVG
- You'll learn how to work with text fields. To finish the chapter, you'll strengthen your queries with GROUP BY and HAVING, allowing you to perform more meaningful aggregations.
- You'll primarily be responsible for representing sales of various artists and tracks in the Chinook digital media database.
Syllabus :
- SELECTion Box
- Groups, strings, and counting things
- Joining tables
- You've got the power