Filtering with WHERE

How to filter rows using WHERE — comparison operators, logical operators AND / OR / NOT. ## Lesson objectives In this lesson, we will learn how to filter data in SQL using conditions. In the previous lesson, we learned how to use to choose columns from a table. But in real work, we usually do not want to see all rows. We often need only the rows that match a specific condition. For example: only employees located in Baku only employees who work in the IT department only employees with salary greater than 1500 only orders with completed status only records created after a specific date For these cases, we use .