Google Maps: High-Impact Local Guides

Unsolved

Google Maps Community Operations recognizes high-impact Local Guides who enrich place discovery with visual content. Write a SQL query to identify all verified reviewers (`account_status = 'verified'`) who have published at least 2 reviews containing photos (`has_photos = 1`) for locations in either 'San Francisco' or 'Mountain View'. Return the `reviewer_id`, `reviewer_name`, and the count of qualifying photo reviews as `photo_review_count`. Sort the results by `photo_review_count` in descending order, breaking ties by `reviewer_id` in ascending order.

Learn the concept: INNER JOIN vs LEFT JOINWHERE, ORDER BY & LIMIT

SQL Query Editor (Ctrl+Enter to run)

0 characters · Valid

Canonical Solution Official

Official Solution is Hidden

Try solving the question with the schema explorer and hints first. When ready, reveal the verified canonical query and step-by-step logic breakdown.

Community Q&A & Discussion

Ask questions, share alternate queries, and explore solutions

0 comments

Asked By:

🏢 Google

Submission History

Your recent query executions and answer checks

Execution Pipeline:

FROM reviewers

Full source dataset

5 rows total

This will insert the verified MySQL solution into your editor so you can study how each clause transforms the table.

Google Maps: High-Impact Local Guides

Official Solution is Hidden

Approach & Explanation

Community Q&A & Discussion

Submission History