SQL query with a condition, how to do?

Question

PHP

We were given laboratory work on the database. The essence of the question is this: Determine the number of cars whose stock notice number starts with "10" and does not end with "39".
help me please

Answer 1

SELECT COUNT(*) FROM `cars` WHERE `number` LIKE '10%' AND `number` NOT LIKE '%39';

In general, you need to make labs yourself, for this you need to read books and understand.