Fork of
Untitled query #26129
by Lucarosty
This query is marked as a draft
This query has been published
by Lucarosty.
SQL
x
select linter_cat, page_namespace,
count(*) from linter join page on page.page_id = linter.linter_page
group by linter_cat, page_namespace
order by linter_cat asc, page_namespace asc;
select linter_cat,
count(*), count(distinct page_namespace) from linter join page on page.page_id = linter.linter_page
group by linter_cat
order by linter_cat asc;
select page_namespace,
count(*), count(distinct linter_cat) from linter join page on page.page_id = linter.linter_page
group by page_namespace
order by page_namespace asc;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.