PartnerStack interview question

Explain how a select works in SQL