Question

Explain the SQL syntax along with how each statement functions
SELECT UNIQUE City FROM Wins_S001 WHERE Team = 'Braves';

Answer 1

SELECT UNIQUE City FROM Wins_S001 WHERE Team = 'Braves';
Explanation:
This query fetches all the columns from Wins_S001 table which satisfies the condition that team name is Braves and city name is unique.
UNIQUE clause gives the column is fetched only one. For example if the two rows has same city, it is fetched only once.