Kodewick
Start learning →
Starter←→0 / 70

M is for…

#050StarterText, LIKESELECT2 min

The owner is making little signs for everything whose name starts with M. From the products table, pick the name and price of the things whose name starts with the letter M.

The tables
products
idnamecategorypricestock
1Milk teadrink1230
2Lemon waterdrink850
3Cheesecakecake256
4Cookiesnack580
5Browniecake180
6Iced coffeedrink1520
7Chipssnack740
8Fruit tartcake284
8 rows
query.sql
SELECT name, price
FROM products
-- your code here: LIKE 'M%' keeps the ones starting with M
;
Ctrl + Enter runs too
Result

Run shows what your query gives. When it looks right, Submit.