> For the complete documentation index, see [llms.txt](https://usmanahmad.gitbook.io/data-mining-techniques/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://usmanahmad.gitbook.io/data-mining-techniques/database-management-system/retrieving-specific-data-using-select-statements/activity.md).

# 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.