SQL Interview Questions Asked in Google for Product Analyst

Описание: SQL Interview Questions Asked at Google for Product Analyst | Crack Your Dream Job!
SQL Interview Questions asked for Product Analyst role at Google


Q1. Write an SQL query to find all active businesses.
Table: Events
Columns: business_id | event_type | occurrences

Q2.Write an SQL query for a report that provides the customer IDs from the Customer table that bought all the products in the Product table.
Table1: Customer
Columns: customer_id | item_key
Table2: Item
Columns: item_key

Q3. Write an SQL query to find for each user, the join date and the number of orders they made as a buyer in 2024.
Table1: Users
Columns: user_id | join_date | favorite_brand
Table 2: Orders
Columns: order_id | order_date | item_id | buyer_id | seller_id
Table 3: Items
Columns: item_id |item_brand

Q4. Write an SQL query that reports the books that have sold less than 10 copies in the last year, excluding books that have been available for less than 1 month from today. Assume today is 2024-05-09.
Table1: Books
Columns: book_id | name | available_from
Table2: Orders
Columns: order_id |book_id | quantity |dispatch_date

Q5: Write an SQL query to find for each date, the number of distinct products sold and their names.
Table: Activities
Columns: sell_date | product



Tags~
sql interview questions
product analyst interview google
google product analyst interview
sql questions for data analyst
data analyst interview prep
google sql interview
product analyst interview preparation
google interview preparation
sql for business analyst
real sql interview questions
product analyst role at google
data science interview questions
google job interview
sql joins practice
sql queries for interviews
google analyst sql
analyst interview tips
crack google interview
sql for product managers
data analyst roadmap 2025

#interviewquestions #productanalyst #google #sql #motivation#dataanalyst #SQL #Google #ProductAnalyst #InterviewQuestions #DataAnalyst #GoogleInterview #SQLQueries #TechInterview #CareerInTech #Motivation #AnalyticsCareer #SQLPractice #DataJobs #CrackTheInterview #InterviewPrep