title: How to select rows that meet criteria from two different columns
body: <p>I have this small table (8 rows) called songs and I need to select just the title and length of all songs that are less than 3 minutes and 46 seconds long. The longest a song can be is 3 minutes and 45 seconds.</p>
  
  <p><a href="https://i.stack.imgur.com/Lq95x.png" rel="nofollow noreferrer">Songs table image</a></p>
  
  <p>I previously tried:</p>
  
  <pre><code>SELECT title, length FROM songs WHERE minutes &lt;= 3 AND seconds &lt; 46;
  </code></pre>
  
  <p>but this command left out the song titled A Kind of Magic that is 2 minutes and 59 seconds in length.</p>
  
  <p>I'm thinking that this SELECT query might need a CASE expression but can't figure out how to make it work without getting an error.</p>