title: Using a for loop to select items and put them into a list
body: <p>So I am querying a database that is called golfDB and it consists of one table called players with 5 fields:</p>
  
  <ul>
  <li>name (player's name)</li>
  <li>totalGross (sum of the gross scores from each round)</li>
  <li>totalRounds (number of rounds played)</li>
  <li>pars (total number of pars made)</li>
  <li>birdies (total number of birdies made)</li>
  </ul>
  
  <p>In this function below I am trying to find the player/ players with the most pars.  It turns out that there are two players, so I am trying to figure out a way to make this print out better because currently it is printing the print statement twice but with the different player at the end.  I want to be able to make what I have designated as players be a list of both players, and then somehow print the players in the print statement more coherently.  Any ideas?</p>
  
  <pre><code>def queryDBpars(cursor):
      """find out which player had the most pars"""
      cursor.execute('select name, pars from players where pars = (select max(pars) from players)')
      playerPars= cursor.fetchall()
      for items in playerPars:
          players= (items[0])
          print('The player(s) with the most pars is/are', players)
  </code></pre>