title: Need to write a query instead of 5 queries to get the result of all 5 states
body: <p><img src="https://i.stack.imgur.com/ZjTMB.png" alt="enter image description here" /></p>
  <p>The CSV file has around 62000 rows, It has states and county (county name is unique within that particular state).</p>
  <p>I had to write 5 queries on the view. Each query will retrieve for one of the states the State_Name, Date, MAX(SumConfirmed) the date with the highest number of confirmed cases in each state.</p>
  <pre><code>SELECT State_Name, Date, ConfirmedCases AS Max_ConfirmedCases
  FROM covid_by_state
  WHERE ConfirmedCases =
      (SELECT max(ConfirmedCases) AS Max_ConfirmedCases
       FROM covid_by_state
       WHERE State_Name='Texas');
  </code></pre>
  <p>The above query was giving me the result for one particular state but I'm not able to find how to get the result of 5 states in one query.</p>