simple queries, continued
eliminating rows
- query
filter <condition> from <table>
- example
filter NAME = ben from ATHLETES
NAME SPONSOR
ben starbucks
operators
- filter and select are called relational operators
- they are like the operations of an abstract data type
- take a table and produce another table