Find students whose name starts with ‘S’ and last name ends with ‘s’?

Question

Answer

Select * from students where name like ‘%S’ and last_name like ‘s%

Answer

Select * from students where name like ‘S%’ and last_name like ‘%s'

Answer

Select * from students where name = ‘S%’ and last_name = ‘%s

Answer

Select * from students where name like ‘S%’ and last_name like ‘S%

Answer

Select * from students where name = ‘%S’ and last_name = ‘%s

Answer

Select * from students where name like ‘S%’ and last_name like ‘%S

Crowdly