Registration date and first edit date

SQL

SELECT
    user_name,
    DATE_FORMAT(CONVERT_TZ(user_registration, '+00:00', '+05:30'), '%Y-%m-%d') AS Registration_date,
    DATE_FORMAT(CONVERT_TZ(MIN(rev_timestamp), '+00:00', '+05:30'), '%Y-%m-%d') AS First_edit_date,
    DATE_FORMAT(CONVERT_TZ(MAX(rev_timestamp), '+00:00', '+05:30'), '%Y-%m-%d') AS Last_edit_date,
    COUNT(DISTINCT rev_id) AS Total_edits,
    COUNT(DISTINCT rev_id) / TIMESTAMPDIFF(YEAR, MIN(rev_timestamp), MAX(rev_timestamp)) AS Avg_edits_per_year
FROM
    revision
JOIN page ON page_id = rev_page
JOIN actor ON actor_id = rev_actor
JOIN user ON user_id = actor_user
JOIN user_properties ON up_user = user_id
GROUP BY
    user_name, user_registration
HAVING
    Last_edit_date >= DATE_SUB(CURDATE(), INTERVAL 180 DAY)
    AND Avg_edits_per_year > 50
ORDER BY
    Total_edits DESC;
SQL

Checking query status...
