title: Display itemcode, supplier name and total quantity for the ordered items, whose total quantity ordered is greater than or equal to 100
body: <p>Display itemcode, supplier name and total quantity for the ordered items, whose total quantity ordered is greater than or equal to 100.</p>
  
  <p>tables are:</p>
  
  <p>Quotation(QuotationId,Sname,ItemCode,QuotedPrice,QDate,QStatus)</p>
  
  <p>Orders(OrderId,QuotationId,QtyOrdered,OrderDtae)</p>
  
  <pre><code>select  Q.itemcode ,Q.sname, O.QtyOrdered as TOTALQUANTITY 
  from Quotation Q
      inner join Orders O on Q.QuotationId = O.QuotationId
  where QtyOrdered &gt;= 100 
  </code></pre>
  
  <p>Query Result :</p>
  
  <pre><code>ITEMCODE  SNAME           TOTALQUANTITY
  I1008     EBATs               100
  I1009     VV Electronics      100
  I1009     VV Electronics      150
  </code></pre>
  
  <p>expected result :</p>
  
  <pre><code>TEMCODE  SNAME            TOTALQUANTITY
  I1009    VV Electronics      250
  I1008    EBATs               150
  </code></pre>