title: Write a query to display the book code, book title ,supplier name and price of the book which takes maximum price based on each supplier
body: <p>Write a query to display the book code, book title ,supplier name and price of the book which takes maximum price based on each supplier.
  <img src="https://i.stack.imgur.com/JTTxM.png" alt="supplier details table"></p>
  
  <p><img src="https://i.stack.imgur.com/mW5Jy.png" alt="book details table"></p>
  
  <pre><code>SELECT book_code,
         book_title,
         supplier_name,
         price
  FROM lms_book_details
  JOIN lms_suppliers_details using(supplier_id)
  GROUP BY supplier_name HAVING price IN
    (SELECT max(price)
     FROM lms_book_details
     GROUP BY supplier_id)
  </code></pre>
  
  <p>output </p>
  
  <p><img src="https://i.stack.imgur.com/3zaxt.png" alt="enter image description here"></p>
  
  <p>The output is displaying, but the book title and price are not correct.</p>