Filtering Rows with WHERE (PostgreSQL)

Up to this point, every query we’ve written has returned all rows from a table. But in real applications, we usually don’t want everything. Most of the time, we want to fetch only specific rows that match some condition. This is where the WHERE claus...