Exercise · SQL & Querying
Predict, then run it
Predict the output
jars(jar, ingredients) = (stew,[nut,nut,salt]),(jam,[fruit]). How many jars contain 'nut' — the membership way, so stew's double-listed nut can't double the jar:
SELECT COUNT(*) AS jars FROM jars WHERE list_contains(ingredients, 'nut');
Predict the exact output.