SQL Fundamentals

Arithmetic & Numeric Functions: Next

COUNT, SUM, AVG, MIN, MAX CASE Statements & Conditional Logic Data Types & Type Conversion Calculate order total with tax and discount Compute average salary by

COUNT, SUM, AVG, MIN, MAX

CASE Statements & Conditional Logic

Data Types & Type Conversion

Calculate order total with tax and discount

Compute average salary by department

Round prices to nearest dollar

Explain integer division, numeric precision, and how NULL affects arithmetic expressions.

Data Types & Type Conversion

NULL Handling

Aggregate Functions & Grouping