Check counts of Adobe lookup tables

check-counts.sql

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from browser
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from browser_type
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from color_depth
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from connection_type
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from country
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from javascript_version
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from languages
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from operating_systems
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from plugins
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from referrer_type
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from resolution
group by "V1"
order by "V1";

select
"V1",
sum(1) as records,
count(distinct "V2") as distinct_keys
from search_engines
group by "V1"
order by "V1";