The SQL SELECT statement possesses three primary capabilities: selection, which filters rows using a WHERE clause; projection, which chooses specific columns to display; and joining, which combines data from multiple tables. Therefore, all of the listed capabilities are correct.