title: how do i only show the min and max values in sql? my code is showing all the values
body: <p>Hi so i am making a database and want to return only the minimum value and maximum value with  other information in other columns so i want to display like the shopID and the brands and brand name</p>
  <pre><code>SELECT Shop.ShopID, 
         Brand.BrandID, 
         Brand.Brand_name, 
         price
  FROM Brand 
  INNER JOIN Shop ON Brand.BrandID = Shop.BrandID
  WHERE Brand.BrandID = 1
  ORDER BY Price;
  
  ShopID  BrandID Brand_Name  Price
  18         1    coke         41
   9         1    sprite       115
   1         1    fanta        141
  </code></pre>
  <p>as you can see it shows me all 3 values i know all the brands are one 1 even though they are separate brands but i essentially want to remove the middle one so it only shows me the minimum and maximum values, just not sure how to go about this, any help would be greatly appreciated.</p>