Athena Vs Select

Both can run SQL. But S3 Select run very simple SQL Statements whereas Athena can run complex SQL Query

Athena

S3 Select