Handling Outliers (Z-score concept)

Problem

A single test order for $9,999,999 skewed the entire Q3 revenue report. You are tasked with implementing an anomaly detection system in SQL. Write a query that outputs concept with the value: "Outliers can be detected using Z-scores, standard deviations, or interquartile ranges (IQR)."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Hint

Solution