Create a gist now

Instantly share code, notes, and snippets.

Check counts of Adobe lookup tables
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";
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment