Users with 5 edits, no. of NS0 pages and top 100 contributors

SQL

-- Set the database to Tamil Wikipedia
USE tawiki_p;

-- Task 1: Total number of registered users with more than 5 edits
SELECT COUNT(DISTINCT actor.actor_id) AS registered_users_with_more_than_5_edits
FROM actor
JOIN revision ON revision.rev_actor = actor.actor_id
JOIN user ON user.user_id = actor.actor_user
WHERE user.user_registration IS NOT NULL
GROUP BY actor.actor_id
HAVING COUNT(revision.rev_id) > 5;

-- Task 2: Total number of pages in namespace 0
SELECT COUNT(*) AS total_pages_in_ns0
FROM page
WHERE page_namespace = 0;

-- Task 3: Top 100 users with the number of pages they have created in namespace 0
SELECT actor.actor_name AS user_name, COUNT(*) AS pages_created
FROM page
JOIN revision ON page.page_id = revision.rev_page
JOIN actor ON revision.rev_actor = actor.actor_id
WHERE page_namespace = 0 AND page_is_redirect = 0
GROUP BY actor.actor_name
ORDER BY pages_created DESC
LIMIT 100;
SQL

Checking query status...
