title: Working with SQL Views and two use cases
body: <p>I have a basic knowledge of SQL using Tables but I only have access to SQL Views  and I want to do these tasks frequently</p>
  
  <p>a) List the View name which contains the <strong>column name</strong> "SEX"</p>
  
  <pre><code>This is what I did wrote for searching view names with specific column 
  values
  
  select distinct TABLE_NAME
     from INFORMATION_SCHEMA.COLUMNS
     where COLUMN_NAME in ('Sex')
     and TABLE_SCHEMA = 'BTJrView' ;
  
  I get an error Relation 'COLUMNS' does not exist
  </code></pre>
  
  <p>b) List the View names that contain <strong>column value</strong> "IFX"</p>
  
  <p>Need help with these two cases</p>
  
  <p>Again, I am working with Views dont have access to Tables</p>