title: Creating a view (virtual table) which display colums with particular requirements
body: <p>So I`m trying to  make a statistic view which counts various things  like how many users are in table called "PACIENTAS" , how many doctors are in table "GYDYTOJAS" and it works.</p>
  
  <pre><code>   CREATE OR REPLACE FORCE VIEW "NEW" ("PACIENTU SKAIČIUS DUOMENŲ BAZĖJE", "PACIENTAI    UŽSIREGISTRAVĘ VIZITUI", "LIGONINIU SKAICIUS", "GYDYTOJU SKAIČIUS", "ŠIO MENESIO REGISTRACIJOS")   AS 
     SELECT(
     SELECT COUNT(*) FROM   PACIENTAS) AS VISIPACIENTAI,
    (SELECT COUNT(*) FROM   REGISTRACIJA) AS REGPACIENTAI,
    (SELECT COUNT(*) FROM  LIGONINE) AS VISOSLIGONINES,
    (SELECT COUNT(*) FROM  GYDYTOJAS) AS VISIGYDYTOJAI,
    (SELECT COUNT(*) FROM  REGISTRACIJA)  AS REGISTRACIJA
    FROM dual
    /
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/n7Inn.png" rel="nofollow noreferrer">Counts how many columns are in table</a>
  <br /></p>
  
  <p>But I want to count  only  columns that fulfil a specified condition </p>
  
  <pre><code>   CREATE OR REPLACE FORCE VIEW "NEW" ("PACIENTU SKAIČIUS DUOMENŲ BAZĖJE", "PACIENTAI   UŽSIREGISTRAVĘ VIZITUI", "LIGONINIU SKAICIUS", "GYDYTOJU SKAIČIUS", "ŠIO MENESIO REGISTRACIJOS") AS  
     SELECT(
     SELECT COUNT(*) FROM   PACIENTAS) AS VISIPACIENTAI,
     (SELECT COUNT(*) FROM   REGISTRACIJA) AS REGPACIENTAI,
     (SELECT COUNT(*) FROM  LIGONINE) AS VISOSLIGONINES,
     (SELECT COUNT(*) FROM  GYDYTOJAS) AS VISIGYDYTOJAI,
     (SELECT COUNT(*) FROM  REGISTRACIJA)  AS REGISTRACIJA
     FROM dual
     WHERE ASMENSKODAS &gt; 10  //ASMENSKODAS is a column from PACIENTAS TABLE
     /
  </code></pre>
  
  <p>When I write this code I get an error</p>
  
  <blockquote>
    <p>ORA-00904: "PACIENTAS": invalid identifier</p>
  </blockquote>
  
  <p>I thinking maybe I need to write my condition in count parentheses but I don't know how, I need ideas because I am stuck.</p>