title: BigQuery not allow Subselect in select clause
body: <p>I have sample with 2 table:</p>
  
  <pre><code>table POINT_STATUS:
  rank_point  status
  9       excellent
  5       good
  3       bad
  0       fail
  
  table STUDENT_POINT:
  student     point
  student A   8
  student B   9
  student C   5
  student D   4
  </code></pre>
  
  <p>How to create query on BigQuery for get status of student <code>(with point &gt;= rank_point)</code>? </p>
  
  <p><strong>NOTE:-</strong>  BigQuery not allow Subselect in select clause.</p>