To find the names of the customers between 30 to 40 years of age, set up the query as seen here:

Question

Select ID, Firstname, Lastname, Age
From customers
Order by Age
Limit 29,40;
Can we code like these?

Answer 1

select ID, Fistname,lastname,age from customers where age between 30 and 40 order by age