SQL SELECT statements have three main capabilities: Projection (SELECTing specific columns), Selection (filtering rows with WHERE), and Join (combining data from multiple tables). Option D correctly identifies that SELECT statements can do all three.