SQL query with the condition, how to do?

We were given Labratory work on the database. The crux of the matter is this: Determine the number of cars that have the stock notification number begins with "10" and end with "39".
Please help
July 12th 19 at 17:11
1 answer
July 12th 19 at 17:13
Solution
SELECT COUNT(*) FROM `cars` WHERE `number` LIKE '10%' AND `number` NOT LIKE '%39';

In General, the labs have to do yourself, to read books and understand.

Find more questions by tags PHPSQL