title: Laravel mysql special query
body: <p>I have a table called: roast_coffees
  In it I have the fields:
  id
  coffee_id
  weight
  packed</p>
  
  <p>I need to find the oldest record where the coffee_id equals X and weight field minus the packed field is bigger than Zero.</p>
  
  <p>I am doing it like this:</p>
  
  <pre><code>$result = DB::select( DB::raw("SELECT id, weight, packed FROM roast_coffees WHERE coffee_id = 3 AND weight - packed &gt; 0"));
  </code></pre>
  
  <p>I have 2 questions:</p>
  
  <ol>
  <li>Is there a better way to do this?</li>
  <li>How do I get only the latest record that fits the query? </li>
  </ol>
  
  <p>Thank you </p>