using 'tennis' database, which consists of tables:

PLAYERS (PLAYERNO, NAME, INITIALS, BIRTH_DATE, SEX, JOINED, LEAGUENO)

TEAMS (TEAMNO, PLAYERNO, DIVISION)

MATCHES (MATCHNO, TEAMNO, PLAYERNO, WON, LOST)

and provide mySQL statements:

1) For ALL players, get the player number and a list of the numbers of teams for which they have ever played. Some players may not have played for teams in the database. Hint a JOIN of some kind is needed.

2) Get the number of each player who won at least one match. A win from matches is more wins than losses.