title: How do I execute the following query?
body: <p>I'm using mysql. I have a table called orders with the fields <code>orderid</code>, <code>orderdate</code>, <code>customerid</code>, <code>shippedcity</code> and <code>amount</code>.</p>
  
  <p>I want to show orders for the month of June and year 2011. Please help.</p>