-- Number of tables in Schema bigpvfc.

select distinct table_name
from tables
where table_schema = 'bigpvfc';

select count(distinct table_name) as "Number of tables"
from tables
where table_schema = 'bigpvfc';


-- The tables of PVFC together with the number of columns of the table.
select distinct table_name as "BigPVFC tables",
    -- Number of columns in the tables.
    count(column_name) as "Number of columns"
from columns
where table_schema = 'bigpvfc'
group by table_name;  -- one output per group: table in bigpvfc