title: MYSQLQuery- How to create a query where we have to list out customers who have bought a specific number of album by the same singer
body: <p>We have the following tables: </p>
  
  <pre><code>Customer:
  customer_id (pk)
  customer_name
  customer_dob
  adress
  gender
  </code></pre>
  
  <hr>
  
  <pre><code>Album:
  Album_id (PK)
  album_name
  singer_id (FK)
  </code></pre>
  
  <hr>
  
  <pre><code>Order_Details:
  order_id (Pk)
  quantity purchased
  customer_id (fk)
  </code></pre>
  
  <hr>
  
  <pre><code>Order_Basket:
  Order_id (fk)
  album_id (fk)
  </code></pre>
  
  <p>I want to create an SQL query statement where I want to list out customers that have purchased 4 or more albums by the same singer. I'm very new to this and I would like to seek input from the much more professional individuals here.</p>