Question

Working with SQL Below is the solution to a previous problem I now have to change it to do the following

Display firstName and lastName from the student table in ascending order by lastName. Include

only if lastName begins with

J – M

(SUBSTRING).

___CURRENT SQL BELOW_____

USE `univdb`;
Select firstName, lastName

From
student
Where lastName Not Like '%y'
Order By lastName ASC;

Answer 1

USE `univdb`;
Select firstName, lastName
From
student
Where lastName Like '[j-mJ-M]%'
Order By lastName ASC;

[j-mJ-M]% specifies the first character should be in the range J-M or j-m and the rest of characters can be anything

and order by specifies that the result should be sorted in ascending order of lastName.