In the previous chapters, you’ve learned how to restrict the records you want to see. You looked at using symbols such as “equals to” and “greater than.” You also learned how to do partial matches using the LIKE keyword and wildcard characters.
These concepts are useful to know. However, you may have noticed that we only filtered by one criteria in each query. We filtered based on a particular last_name value, or a particular salary value. What if we wanted to filter on two or more criteria?
Why Use Multiple Filters?
Why would you want to use multiple filters in an SQL ...
