Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
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
You can’t perform that action at this time.