Results for “typed rows”

SQL ServerSubqueries & ranked selection

Compare a row with its own group average ↗

SQL Server: A correlated aggregate computes a different comparison value for each group.

SQL Server✓ Tested

PostgresSubqueries & ranked selection

Compare a row with its own group average ↗

Postgres: A correlated aggregate computes a different comparison value for each group.

Postgres✓ Tested

SQLiteSubqueries & ranked selection

Compare a row with its own group average ↗

SQLite: A correlated aggregate computes a different comparison value for each group.

SQLite✓ Tested

PostgresWindows & text

Compare a row with the previous row ↗

Read a preceding value with LAG.

LAG✓ Tested

SQLJoins & subqueries

Compare with a calculated value ↗

Find products above the average price.

subquery✓ Tested

ReactComponents & props

Compose a component with named content slots ↗

Compose a component with named content slots with a small React component and explicit browser behavior.

React✓ Tested

ReactGetting Started

Compose content through children ↗

Compose content through children with a small React component and explicit browser behavior.

React✓ Tested

SQLiteTables & writes

Compute a generated column ↗

Store inputs and derive a value from them.

generated column✓ Tested

SQLReporting & grouped calculations

Compute an integer weighted average ↗

SQL: Multiply before summing and guard a zero total weight with NULLIF.

SQL✓ Tested

SQL ServerReporting & grouped calculations

Compute an integer weighted average ↗

SQL Server: Multiply before summing and guard a zero total weight with NULLIF.

SQL Server✓ Tested

PostgresReporting & grouped calculations

Compute an integer weighted average ↗

Postgres: Multiply before summing and guard a zero total weight with NULLIF.

Postgres✓ Tested

SQLiteReporting & grouped calculations

Compute an integer weighted average ↗

SQLite: Multiply before summing and guard a zero total weight with NULLIF.

SQLite✓ Tested