title: How can I query this sql to get the best-selling product
body: <p>This's my database sample: 
  <em>orderdetails</em> table with the ProID relate to <em>products</em> tabale</p>
  
  <pre><code>| ProID | OrderID | OrderQuantity | OrderPrice |
  |  93   |    17   |       1       |     150    |
  |  16   |    18   |       1       |     100    |
  |  93   |    19   |       3       |     450    |
  |  93   |    17   |       1       |     150    |
  </code></pre>
  
  <p><em>products</em> table</p>
  
  <pre><code>| ProID | ProPicture | ProName | ProPrice |
  |  93   | ./a.jpg    |  Iphone |    150   |
  |  16   | ./b.jpg    |  Nokia  |    100   |
  </code></pre>
  
  <p>How can I get the best-selling product information: ProID, ProPiecture, ProName, ProPrice from <em>products</em> table base on <em>orderdetails</em> table?</p>