Question: Filter with the LIKE Operator

Question

Given the following StudentGrades table structure:

Additional information

You are provided with a table named StudentGrades that contains the following columns:

• RecordID: A column of unique values. It’s the primary key of this table.

• StudentID: Unique identifier for each student.

• StudentName: The name of the student.

• Subject: The subject for which the grade is recorded.

• Marks: The marks obtained by the student in the corresponding subject.

You are required to analyze student performance data. The StudentGrades table holds important details like ID and name along with the marks of the students obtained in Science and Mathematics. Here’s a task for you: Can you write a query using SQL LIKE to find out the records of students whose name ends with “a”?

Let’s see if you can find the answer!

Expected output

The expected output is shown below:

Try it yourself

You can try to write a query in the following playground:

Hints

Below are some hints to help you understand these concepts better: