[Solved] Name and birthdate for all the students whose first name is between 6 and 9 characters long

by

[ad_1]

Your syntax suggests SQL Server. In that database, you would phrase the query as:

select firstname + ' ' + lastname as fullname, birthdate
from student
where len(firstname) between 6 and 9 and len(lastname) > len(firstname)

0

[ad_2]

solved Name and birthdate for all the students whose first name is between 6 and 9 characters long