• Viewing SELECT statement syntax
• Displaying all columns
• Eliminating Duplicate Values from the data
• Subsetting data using Conditional Operators
• Enhancing Query output
• Summarizing and Grouping data
• Subsetting data by using Subqueries
• Subsetting data by using Non-correlated Subqueries
• Subsetting data by using Correlated Subqueries