Question: what is the difference between the select and project operations?
Answer: PROJECT eliminates columns while SELECT eliminates rows. In Relational algebra 'Selection' and 'Projection' are different operations, but the SQL SELECT combines these operations in a single statement. ... Project retrieves the attributes (columns) specified.