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