Activity

• Using the WHERE clause to filter data

• Using comparison operators in WHERE clause

• Using logical operators in WHERE clause

• Using the LIKE operator to search for specific patterns

To do: Create a SQL query using SELECT statements to retrieve specific data from a given table, with a focus on applying WHERE, comparison operators, logical operators, and LIKE operator.Scoring Criteria:

1. 1.Correct and efficient use of SQL SELECT statements.

2. 2.Proper application of WHERE clause, comparison operators, logical operators, and LIKE operator.

3. 3.Clarity and organization of the query, as well as the relevance of the data retrieved.

Step-by-step plan:

1. 1.Identify the table to query.

2. 2.Determine the specific columns to retrieve.

3. 3.Define the filtering criteria using the WHERE clause and comparison operators.

4. 4.Add logical operators to combine multiple conditions.

5. 5.Apply the LIKE operator to search for specific patterns.