SQL

1. Retrieve the name, club, and position for the players whose country is USA

2. Retrieve the names of countries participating in the 2014 world cup (this database) that have won the world cup at least once.

3. Retrieve the names of countries participating in the 2014 world cup (this database) that have never won the world cup.

COUNTRY No_of_Worldcup_won Country Name Population Manager PLAYERS Country Player id Name Fname Lname DOB Height Club Position Is_captain Caps for country MATCH_RESULTS Team1 Team2 Match_id Date Start_ time Team1_ Team2_s Stadium Host_C score ity core PLAYER_CARD No_of_Red_cards Player id No_of_Yellow_cards PLAYER_ASSISTS_GOALS Goals Assists Minutes_played Player id No_of_Matches