Independent Company Challenges
Google-style SQL challenges
Independent Google-style search, advertising, user-engagement, and video-product SQL practice.
These independent exercises use Google-relevant business domains; they are not claimed to be questions used by Google, and this site is not affiliated with the company.
- Published pages
- 29
- Runnable now
- 26
- Difficulty
- Beginner to Hard
What this collection tests
Skills and query patterns
Search behavior, advertising revenue, user activity, video engagement, retention, and product analytics
Curated exercises
Choose a challenge
Work in the live editor where supported. Read-only solution guides and advanced guided labs state their capability before you choose the next action.
- Challenge 1Easy
Active Search Queries
Which distinct search queries were entered on or after January 18, 2024?
- Filtering
- Sorting
- Distinct values
SQLite live
Open challenge → - Challenge 2Beginner
Total Users Count
How many users are registered on the product platform?
- Aggregation
Read-only solution guide
Read solution guide → - Challenge 3Easy
Users by Country
How many users are registered from each country?
- Aggregation
- Sorting
Read-only solution guide
Read solution guide → - Challenge 4Beginner
Mobile Users
Which users signed up using a mobile device?
- Filtering
- Sorting
SQLite live
Open challenge → - Challenge 5Easy
Daily Search Volume
How many search queries were submitted on each day?
- Aggregation
- Date analysis
- Sorting
SQLite live
Open challenge → - Challenge 6Easy
Users Without Searches
Which registered users have never made a single search query?
- Joins
- NULL handling
- Filtering
SQLite live
Open challenge → - Challenge 7Beginner
Search Queries Count
What is the total number of search queries stored in the system?
- Aggregation
SQLite live
Open challenge → - Challenge 8Beginner
Recent Signups
Which users signed up on or after February 1, 2024?
- Filtering
- Sorting
SQLite live
Open challenge → - Challenge 9Easy
Searches by User
How many searches has each user performed in total?
- Aggregation
- Sorting
SQLite live
Open challenge → - Challenge 10Easy
Top Countries by Users
Which countries have the most users, ranked from highest to lowest?
- Aggregation
- Sorting
Read-only solution guide
Read solution guide → - Challenge 11Medium
Most Searched Query
Which search query has been submitted the most times, and how many times?
- Aggregation
- Sorting
- Top-N
SQLite live
Open challenge → - Challenge 12Medium
Daily Active Users
How many unique users performed at least one search on each day?
- Aggregation
- Date analysis
- Sorting
SQLite live
Open challenge → - Challenge 13Medium
Revenue by User
What is the total ad revenue each user has generated through ad clicks?
- Aggregation
- Numeric functions
- Sorting
SQLite live
Open challenge → - Challenge 14Medium
Top Revenue Users
Which 5 users have generated the most total ad revenue?
- Aggregation
- Numeric functions
- Sorting
SQLite live
Open challenge → - Challenge 15Medium
Users with Multiple Searches
Which users have submitted more than 10 search queries in total?
- Aggregation
- HAVING
- Sorting
SQLite live
Open challenge → - Challenge 16Medium
Video Views Per Category
How many total video views has each YouTube content category received?
- Joins
- Aggregation
- Sorting
SQLite live
Open challenge → - Challenge 17Medium
Average Watch Time
What is the average watch time in seconds for each video?
- Aggregation
- Numeric functions
- Sorting
SQLite live
Open challenge → - Challenge 18Medium
Users with Ad Clicks
Which users have clicked on at least one ad?
- Sorting
- Distinct values
SQLite live
Open challenge → - Challenge 19Medium
Search to Signup Gap
Which users performed a search on the exact same day they signed up?
- Joins
- Date analysis
- Filtering
SQLite live
Open challenge → - Challenge 20Medium
Inactive Users
Which users have not performed any search on or after January 15, 2024?
- Joins
- Date analysis
- NULL handling
SQLite live
Open challenge → - Challenge 21Hard
User Retention
Which users searched on at least one pair of consecutive days?
- Joins
- Date analysis
- Sorting
SQLite live
Open challenge → - Challenge 22Hard
Top Query Per Day
For each day, which search query was submitted the most times? When multiple queries tie, show all tied queries.
- Window functions
- Subqueries
- Aggregation
SQLite live
Open challenge → - Challenge 23Hard
Revenue Contribution %
What percentage of total ad revenue does each user account for?
- Subqueries
- Aggregation
- Numeric functions
SQLite live
Open challenge → - Challenge 24Hard
Most Engaged Users
Which users have an average video watch time above the platform-wide average?
- Subqueries
- Aggregation
- HAVING
SQLite live
Open challenge → - Challenge 25Hard
Top Revenue Users with Search Activity
Which 10 searching users generated the most ad revenue?
- Joins
- Subqueries
- Aggregation
SQLite live
Open challenge → - Challenge 26Beginner
Users by Device Type
How many users registered on each type of device?
- Aggregation
- Sorting
SQLite live
Open challenge → - Challenge 27Medium
Daily Ad Revenue Trend
What is the total ad revenue and click count for each day?
- Aggregation
- Date analysis
- Numeric functions
SQLite live
Open challenge → - Challenge 28Medium
Top 5 Videos by Total Watch Time
Which 5 videos have accumulated the most total watch time across all viewers?
- Joins
- Aggregation
- Sorting
SQLite live
Open challenge → - Challenge 29Hard
Top Viewer per Video Category
In each video category, which user has watched the most total seconds of content?
- Window functions
- Joins
- Subqueries
SQLite live
Open challenge →
Attempt
Write a query or design from the brief before opening any hints.
Validate
Run active exercises; use the published evidence and declared validation standard for read-only or guided pages.
Explain
Compare the verified answer and explain each choice aloud.
Learn before practicing Google
Strengthen your understanding with these targeted learning topics:
Continue practicing
Explore related company challenges
Meta
Independent Meta-style social-product, engagement, content, community, messaging, and advertising SQL practice.
Microsoft
Independent Microsoft-style cloud, productivity, subscription, usage, support, and customer analytics SQL practice.
Netflix
Independent Netflix-style streaming, subscription, catalog, ratings, and engagement SQL practice.
Return to the complete interview preparation experience.