title: Easiest SQL command to show all rows and tables
body: <p>Let's say my database has the following columns: FirstName, LastName, SSN. I want to write a SQL statement that would show only columns and last name begin with a S.</p>
  
  <p>I'm just a beginner so what is the easiest way to to do this?</p>
  
  <pre><code>SELECT
    firstname,
    lastname ="s",
    ssn
  FROM
    Patrons
  WHERE
    xtype = 'U';
  GO
  </code></pre>
  
  <p>is this right?</p>