Topics

• SELECT
• Example Databases and Tables
• CASE
• ORDER BY
• GROUP BY

Examples

• Searched CASE in SELECT (Matches a boolean expression)
• Use CASE to COUNT the number of rows in a column match a condition.
• Use ORDER BY with TOP to return the top x rows based on a column's value
• USE GROUP BY to COUNT the number of rows for each unique entry in a given column
• Sorting by column number (instead of name)