Example 1
Average a set of review scores
This example uses values whose average is exactly 4, avoiding engine-specific decimal display differences.
Source table data Rows loaded before the example query runs.
Setup
CREATE TABLE reviews (id INT, score DECIMAL(4, 2));
INSERT INTO
reviews (id, score)
VALUES
(1, 4.00),
(2, 5.00),
(3, 3.00);Validated query Shared across supported engines.
SQL
SELECT
AVG(score) AS average_score
FROM
reviews;Expected result Returned rows for the shared example.
| average_score |
|---|
| 4 |
The same dataset and exact average validate cleanly across all engines.