In this chapter, you learned the basic syntax of the SELECT statement and how it can be used to query data from SQL Server database tables. You learned about the different categories of built-in T-SQL functions and used them in your queries. You learned the different techniques to combine data from multiple tables. You also learned how to organize the data and how to generate the summary data by grouping data or pivoting data. You also understood the purpose of the CTE. We then went through the purpose of window analytic functions and how to use them to quickly solve complex analytical tasks.