Filtering & predicates
Exercise · SQL & Querying

Predict, then run it

Predict the output

fabrics(name) = 'linen 100%', 'cotton 200', 'linen blend', 'silk 100'. Find only the fabrics labelled with a literal '%' — the trailing percent must be data, not a wildcard:

SELECT name FROM fabrics WHERE name LIKE '%100\%' ESCAPE '\' ORDER BY name;

Predict the exact output.