A product catalog team wants to flag items with names that are too long for certain display templates. Using the products table, find every product whose name is longer than 20 characters. Return name and name_length (the number of characters in the name). Sort by name_length descending.
products
| column | type |
|---|---|
| id | INTEGER |
| name | TEXT |
| category | TEXT |
| price | NUMERIC |
| id | name | category | price |
|---|---|---|---|
| 1 | Widget | Tools | 9.99 |
| 2 | Professional Drill Set | Tools | 49.99 |
| 3 | Laptop Stand Adjustable Arm | Electronics | 34.99 |
| 4 | Pen | Office | 1.99 |
| 5 | Wireless Ergonomic Keyboard | Electronics | 79.99 |
| name | name_length |
|---|---|
| Wireless Ergonomic Keyboard | 27 |
| Laptop Stand Adjustable Arm | 27 |
| Professional Drill Set | 22 |
"Widget" (6 chars) and "Pen" (3 chars) are below the threshold. The three products with names longer than 20 characters are returned, sorted from longest to shortest.