title: MYSQL view support subquery
body: <p>Am just started reading view tutorial </p>
  
  <p>i used this link <a href="http://www.mysqltutorial.org/create-sql-views-mysql.aspx" rel="nofollow">view tutorial</a></p>
  
  <p>in this tutorial they said</p>
  
  <pre><code>Subquery cannot be included in the SELECT statement.
  </code></pre>
  
  <p>but they gave one example that is ,</p>
  
  <pre><code> CREATE VIEW vwProducts  AS 
   SELECT productCode,
          productName,
          buyPrice 
   FROM products
   WHERE buyPrice &gt; (
        SELECT AVG  (buyPrice)
        FROM  products
   )
   ORDER BY buyPrice DESC
  </code></pre>
  
  <p>Tell me , is it possible , </p>
  
  <p>in view shall we use sub query or not ,</p>