If you’re new to querying and filtering SQL data, I would recommend starting with Getting Started with SQL Server: 1. Simple SELECT Queries. Here you’ll learn about database naming conventions and how to write a simple query.
Once you understand these concepts, I would recommend reading the following two articles:
Once you understand how to use Boolean logic to add AND and OR clauses to your SQL, I would recommend looking into the LIKE operator to learn about partial matching.
Use Pattern Matching in SQL to Filter Results goes over the details so you’re familiar with LIKE.
All the examples for this lesson are based on Microsoft SQL Server Management Studio and the sample databases AdventureWorks and WideWorldImporters. You can get started using these free tools using my guide Getting Started Using SQL Server