Each task describes text that you know only part of. Build a pattern with % and _.
- The plush toys: the products whose name ends with
Plush. Showname, thenprice. - The products with
Stickeranywhere in the name. Shownameonly. - Think before you run it: how many rows does
SELECT name FROM products WHERE name LIKE '%kraken%';return? - The products with "kraken" in the name, in any case. Show
nameonly. - The customers whose email has exactly one character between a dot and the
@, as inliam.p@example.com. Showname, thenemail.