queries on a single table
for uniformity
- think of result of a query as a table itself
-
two ways to make a table smaller
- eliminate some columns
- eliminate some rows
eliminating columns
- query
select <column names> from <table>
- example
select CAFEMEISTER, HOURS from EVENTS
CAFEMEISTER HOURS
ben 10
alice 15
carol 8