These are SQL questions of the kind Google actually asks — the patterns reported from Google's SQL screens and data/SDE interview rounds. My advice: treat this page as a mock test. Attempt every question on paper first, then reveal. If any answer surprises you, the lesson it comes from is linked right below — go read it, then come back.
Google SQL concept questions
Explain the window frame clause — the difference between ROWS BETWEEN and RANGE BETWEEN — and what frame is used by default when a window function has an ORDER BY but no explicit frame clause.
Asked in
Google SQL query questions
Using the same employees table, write a query to find all employees whose email address is a personal Gmail address rather than the company's @corp.com domain.
Asked in
employees9 rows
| emp_id | name | department | salary | manager_id | join_date | |
|---|---|---|---|---|---|---|
| 1 | Alice Sharma | Engineering | 95000 | NULL | 2019-03-12 | alice.sharma@corp.com |
| 2 | Bob Iyer | Engineering | 72000 | 1 | 2020-07-01 | bob.iyer@corp.com |
| 3 | Chitra Rao | Sales | 65000 | NULL | 2018-11-20 | chitra.rao@corp.com |
| 4 | David Paul | Sales | 58000 | 3 | 2021-01-15 | david.paul@gmail.com |
| 5 | Esha Nair | Engineering | 88000 | 1 | 2019-09-05 | esha.nair@corp.com |
| 6 | Farhan Khan | Marketing | 60000 | NULL | 2020-02-28 | farhan.khan@corp.com |
| 7 | Gita Menon | Marketing | 60000 | 6 | 2022-04-10 | gita.menon@gmail.com |
| 8 | Harish Verma | Sales | NULL | 3 | 2022-06-18 | harish.verma@corp.com |
| 9 | Amit Verma | Sales | 52000 | 3 | 2021-08-01 | amit.verma@corp.com |
Given online_orders(product_id) and store_orders(product_id), write a query using INTERSECT to find product IDs that have been ordered through both the online channel and the in-store channel.
Asked in
online_orders4 rows
| product_id |
|---|
| 1 |
| 2 |
| 3 |
| 2 |
store_orders3 rows
| product_id |
|---|
| 2 |
| 3 |
| 4 |
How to use this page: Google rarely asks a question you've never seen — they ask standard patterns with a twist. Master the pattern in the SQL course lessons, and the twist stops mattering.
Keep practising: SQL Basics, Joins, GROUP BY & HAVING and Subqueries cover what most Google SQL rounds test.