title: Total count in sql
body: <p>I need to create a view that will display the total number of students who have declared two majors (<code>Major1</code> and <code>Major2</code> are not null).</p>
  
  <p>What query should I use? </p>
  
  <p>My goal is to  get a single row of output so I know <code>ORDER BY</code> clause is irrelevant in this case. </p>