title: sql or sqlite query and getting result in a list
body: <p>I am new to sql and In my app I am using sqlite DB's and I have trouble in creating a query.</p>
  
  <p>I have a DB with column names to be:</p>
  
  <pre><code>Name1  Name2  Score1  Score2 Winner  Aces1  Aces2
  </code></pre>
  
  <p>Imagine that thse are the stats of a single game, so the same name can be in name 1 or in name 2 in different rows.</p>
  
  <p>I want the following:</p>
  
  <p>a)
  Return in a list the player names with a descending number of aces.</p>
  
  <p>For example imagine these rows:</p>
  
  <pre><code>Nick George 39  35  Nick  2   4
  Joe  Nick   17  39  Nick  1   0
  George Jorge  11  39  Jorge  3  1 
  </code></pre>
  
  <p>Should give me in a list the following:
  //number or aces</p>
  
  <pre><code>George 7
  Nick 2
  Joe 1
  Jorge 1
  </code></pre>
  
  <p>b)I want the same with number of wins.</p>
  
  <p>c)and the same avg points.</p>
  
  <p>Can you please give me the query?</p>