title: PHP Laravel SQL Or Elequent Or Query builder
body: <p>I am new to Laravel <code>5.4.</code> I am facing a big problem to make decision whether I should focus on mySQL or Elequent or query builder to make complex query.</p>
  
  <p>For example: I need a electric bill report based on different charge range.</p>
  
  <pre><code>0-99=&gt;$120
  100-199=&gt;$200
  200-299=&gt;$220
  300-399=&gt;$250
  </code></pre>
  
  <p>How can make a elequent query or query builder to make a report with other data such as Customer name, address, phone, sum of total, with details list of which range is being charged to him etc?</p>
  
  <p>Should I use raw SQL query for this?</p>
  
  <p>As I am using AngularJs, I have to return all this in a single query. If you want to help me using a controller, you can show me.</p>
  
  <p>What can I do?</p>
  
  <p>I used .Net where I can make this easily by LINQ query, but I am stuck here!</p>
  
  <p>I think laravel query builder is not powerful like LINQ. Leave .Net if you are not familiar with it.</p>
  
  <p>Anyways, I need help to get out of the problem. How can I write that complex query?</p>
  
  <p><em>Desired result</em>:</p>
  
  <p>Suppose I have <code>Customers</code> table, <code>Billranges</code> table and <code>Bill</code> table</p>
  
  <p>I need: </p>
  
  <pre><code>Customername-Address-Metter-Charge-Bill
  John-Dhaka-250-$220 -55000(250x220)
  </code></pre>
  
  <p>Can I do this in Laravel 5.4 Query builder?</p>