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.