title: I want to obtain the highest % of the category "sex" in 2018 and that also shows what is the gender of that percentage
body: <p>I put max with strata_name, but I'm not sure if it was the correct decision.</p>
  <pre><code>SELECT Year, Strata, FORMAT(max([percentage]/100000), 'P') Npercentage, Max(Strata_Name) as gender
  FROM [dbo].[Depression_in_California] 
  WHERE Strata = 'Sex' 
  GROUP BY Year, Strata, Strata_Name
  ORDER BY Year desc;
  </code></pre>
  <p>Here is the image</p>
  <p><img src="https://i.stack.imgur.com/3doMb.png" alt="enter image description here" /></p>