Search⌘ K

SQL Interview Preparation

0%

1.Get Started

2.CRUD Operations

Question: Insert a Record Answer: Insert a Record Question: Update a Value Answer: Update a Value Question: Delete a Record Answer: Delete a Record

3.Aggregate Functions

Question: Aggregate Records Using SUM Answer: Aggregate Records Using SUM Question: Aggregate Records Using AVG Answer: Aggregate Records Using AVG Question: Aggregate Records Using MIN/MAX Answer: Aggregate Records Using MIN/MAX Question: Aggregate Records Using COUNT Answer: Aggregate Records Using COUNT

4.Date and Time Functions

Question: Extract a Value From a Date Answer: Extract a Value From a Date Question: The DATE Column and Calculations Answer: The DATE Column and Calculations

5.Filtering

Question: Filter with the WHERE Clause Answer: Filter with the WHERE Clause Question: Filter with the LIKE Operator Answer: Filter with the LIKE Operator

6.Grouping

Question: The GROUP BY Clause and the AVG Function Answer: The GROUP BY Clause and the AVG Function Question: The GROUP BY Clause and the SUM Function Answer: The GROUP BY Clause and the SUM Function

7.Sorting

Question: Sorting the Records Answer: Sorting the Records Question: Sorting and Calculations Answer: Sorting and Calculations

8.Constraints

Question: The NOT NULL Constraint Answer: The NOT NULL Constraint Question: The UNIQUE Constraint Answer: The UNIQUE Constraint Question: The PRIMARY KEY Constraint Answer: The PRIMARY KEY Constraint Question: The FOREIGN KEY Constraint Answer: The FOREIGN KEY Constraint

9.Working with JOINs

Question: Using LEFT JOIN Answer: Using LEFT JOIN Question: Using RIGHT JOIN Answer: Using RIGHT JOIN Question: Using INNER JOIN Answer: Using INNER JOIN Question: Combining JOIN Statements Answer: Combining JOIN Statements

10.Subquery

Question: Subquery in the SELECT Clause Answer: Subquery in the SELECT Clause Question: Subquery and Calculations Answer: Subquery and Calculations

11.Final Remarks

SQL Interview Preparation

Question: Filter with the LIKE Operator

Learn how to use the LIKE operator in an SQL query.

We'll cover the following...

Question
Expected output
Try it yourself
Hints

Question

Given the following StudentGrades table structure:

StudentGrades

RecordID	StudentID	StudentName	Subject	Marks
1	st-101	Alexa	Mathematics	90.00
2	st-101	Alexa	Science	NULL
3	st-102	Diana	Mathematics	80.00
4	st-102	Diana	Science	88.00
5	st-103	Carl	Mathematics	NULL
6	st-103	Carl	Science	92.00
7	st-104	Sara	Mathematics	75.00
8	st-104	Sara	Science	85.00
9	st-105	Karen	Mathematics	85.00
10	st-105	Karen	Science	90.00

Additional information

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