SQL basic question

I was given the following question on basic SQL. Can someone please help me understand this query?   SQL CONCEPT 1 Please write the result for the following query Table1 name 1.   A 2. B 3. C Tab...