Join and Filter Customer Orders

SELECT with WHERE Filter

Fix the JOIN Condition

Selecting and Ordering Query Results

Clause Order in a Grouped Join Query

Filtering Rows with WHERE

Filtering Rows With NULL Values

SQL Clause Execution Order

Filter Aggregates with HAVING

Filtering and Sorting Results

Core SQL Querying Essentials

Filtering Aggregated Results

SQL Query Building Blocks

Selecting All Columns With The Wildcard

Removing Duplicates With DISTINCT

Comparison Operators

Column Aliases With AS

Filtering NULL Values

Sorting With ORDER BY

Negating With NOT

Set Membership With IN

Filtering With WHERE

Logical Order Of Clauses

Combining With AND / OR

Sorting By Multiple Columns

Limiting Result Rows

Pattern Matching With LIKE

Selecting All Columns

Ascending vs Descending Sort

String Literals And Quoting

Range Filtering With BETWEEN

Selecting Specific Columns

SQL Syntax Basics

Limiting Rows With LIMIT and TOP

Removing Duplicates With DISTINCT

Sorting by Multiple Columns

Ascending and Descending Order

Sorting Results With ORDER BY

Handling NULLs With IS NULL

Set Membership Filtering With IN

Range Filtering With BETWEEN

Pattern Matching With LIKE

Combining Conditions With AND, OR, NOT

SQL Comparison Operators in WHERE

Filtering Rows With WHERE

Renaming Columns With AS Aliases

Specifying Tables With FROM

Pattern Matching With LIKE

Limiting Returned Rows

Filtering With IN

Filtering Ranges With BETWEEN

Clause Order In A Query

Sorting Descending

Selecting Specific Columns

WHERE Comparison Operator

Combining Conditions

Removing Duplicates With DISTINCT

Selecting All Columns

Sorting By Multiple Columns

Sorting With ORDER BY

Handling NULL Values

Column Aliases With AS

Selecting Specific Columns by Name

The SELECT Statement's Purpose

Filtering with IS NULL / IS NOT NULL

IN Operator for Value Lists

Sorting by Multiple Columns

Logical Operators AND, OR, NOT

Column Aliases with AS

WHERE Clause for Filtering

Statement Termination with Semicolon

LIKE Operator and Wildcards

SELECT DISTINCT for Unique Values

LIMIT Clause to Restrict Rows

Ascending vs Descending Sort

Selecting All Columns with *

Selecting Specific Columns

String Literals and Quoting

ORDER BY for Sorting

Comparison Operators

FROM Clause and Table Name

BETWEEN Operator for Ranges

Case Sensitivity and Conventions

SELECT Statement Basic Syntax