Skip to content

Instantly share code, notes, and snippets.

@adsharma

adsharma/edge-types-by-freq.sql

Created November 26, 2024 18:39
Show Gist options
  • Save adsharma/7821cda7d01445a5438ae67a9d9566e9 to your computer and use it in GitHub Desktop.
Save adsharma/7821cda7d01445a5438ae67a9d9566e9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
edge-types-by-freq.sql
attach 'props.db' as props;
select type, count(type) as cnt, l.value
from relations r
join props.labels l on r.type=l.property
group by type, l.value
order by cnt desc
limit 200;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment