BOOL_AND

Returns true if all non NULL input value are true, otherwise false. If all input values are NULL values, returns NULL.

Syntax

BOOL_AND(<expression>) [FILTER ([WHERE] <condition>)]

Parameter	Description	Supported input types
`<expression>`	The boolean expression used to calculate the result	`BOOLEAN`
`<condition>`	An optional boolean expression to filter rows used in aggregation	`BOOL`

BOOLEAN

name	totalprizedollars
The Drift Championship	22,048
The Lost Track Showdown	5,336
The Acceleration Championship	19,274
The French Grand Prix	237
The Circuit Championship	9,739

We want to check if all tournaments have prize money

SELECT
	BOOL_AND(totalprizeddollars IS NOT NULL AND totalprizeddollars > 0) as all_have_prizes 
FROM
	tournaments;

Returns true

⌘I