james.maes
fb10ae20c3
- Fix clippy warnings in test code by adding #[allow(dead_code)] - Move all unit tests from source files to tests/ directory - Add integration tests for SQL parsing and schema operations - Create examples directory with 5 SQL query examples - Add Windows CI job to ci.yml for cross-platform coverage - Update Cargo.toml with documentation and readme fields - Add comprehensive clean room audit documentation All 39 tests passing, clippy clean, formatting verified
30 lines
790 B
Markdown
30 lines
790 B
Markdown
# Aggregate Functions Example
|
|
|
|
This example shows how to use aggregate functions in your queries.
|
|
|
|
```sql
|
|
SELECT
|
|
Status,
|
|
COUNT(*) as count,
|
|
AVG(Rating) as average_rating
|
|
FROM Tasks
|
|
GROUP BY Status;
|
|
```
|
|
|
|
This query:
|
|
- Groups records by Status column
|
|
- Counts the number of records in each status group
|
|
- Calculates the average Rating for each status
|
|
|
|
Run with:
|
|
```bash
|
|
notion-sql query --database-id YOUR_DATABASE_ID --sql "SELECT Status, COUNT(*) as count, AVG(Rating) as average_rating FROM Tasks GROUP BY Status;"
|
|
```
|
|
|
|
Supported aggregate functions:
|
|
- COUNT(*) - Count the number of records
|
|
- SUM(column) - Sum values in a numeric column
|
|
- AVG(column) - Calculate the average of a numeric column
|
|
- MIN(column) - Find the minimum value
|
|
- MAX(column) - Find the maximum value
|