Top Visited Websites Ordering

The Nio Robotics Fleet Console records websites visited by robotics operators. Write a PostgreSQL query that identifies the three most visited websites based on human visits.

Requirements

1. Exclude visits where is_bot is TRUE.
2. Return each website's domain, total human visit count, and distinct visitor count.
3. Sort by total visits descending, then website_id ascending for deterministic tie handling, and return only the top three websites.
4. Use the websites and page_visits tables. Websites with no qualifying visits should remain eligible for ranking with zero counts.