Data Science SQL Interview Question and Answer

====== ✅ Details ======

Love it or hate it - solving the SQL question correctly with speed can make or break your interview success.

That's why in this video, I share:

👉 Three tips that helped clients ace SQL rounds in MAANG companies
👉 Daetama - an SQL practice pad with 100 interview questions
👉 A walkthrough of a Google SQL interview question

⭐ Daetama is a new DataInterview product that will allow you to practice code on a web browser. Once launched at 9:00 A.M. EST on June 16, 2022, premium users will get access to 100 FAANG-style SQL questions curated and solved by data scientists at Google and Meta.

👍 Make sure to subscribe, like and share!

====== ⏱️ Timestamps ======

00:00 - How to prepare for data science SQL interview questions
00:35 - Tip #1
00:59 - Tip #2
01:48 - Tip #3
02:25 - Where to practice SQL problems
03:35 - Google SQL question

====== 📚 Other Useful Contents ======

====== Connect ======

[DataInterview]

I can't wait to have you try out Daetama once it launches on June 16!

[Aidan_Au]

Welcome back, Dan! Hope that your trip in Pais was rejuvenating.
I just entered my email on Daetama using your link.
Thank you for sharing your resources with us.
I got your confirmation email. You may want to correct the launch date to June 16, 2022. Right now it says April 16 🚀

[Aidan_Au]

Could you please make a video on your thoughts on Take Home Assignments?
Most people on Blind said that they don't like take home.
In what situations do companies give take homes? (e.g. Let candidates prove themselves if they only show borderline ability, e.g. Are take homes often give out by startups or major tech companies) How can we use take-homes to our advantages?

[eraheem]

Is the discount for the main subscription or just the SQL practice website?

[garyboy]

Thanks. Tried out some questions and many solutions are not correct. Either the output is the same as the answer but just different order (the question did not specify how to order the result, I suspect you are doing exact match of the output answer), OR some of the solutions are incorrect. For example q 93 (Users who searched between 2 and 5 times) you are comparing dates in this format '04-01-2022' which gives incorrect result, as you should compare to '2022-04-01'

When would these kinds of bugs and incorrect answers be fixed? Thank you.

[danielw]

Hi Dan, Thanks for the walk through and I am very excited about the upcoming daetama launch. Here's my approach and would appreciate it if you could provide your feedback.

WITH converted_list AS (
SELECT DISTINCT W.url
FROM google_search_activity A
LEFT JOIN google_search_websites W USING (website_id)
WHERE A.event_type = 'converted'
)

SELECT url FROM google_search_websites WHERE url NOT IN (SELECT url FROM converted_list)

[Aidan_Au]

--Join the 2 source tables.
--Create CTE#1 for all distinct clicked websites only. (DISTINCT clause is used here because there can be multiple sessions for the same website)
--Create CTE#2 for all distinct converted websites only.
--Return only websites that were in the clicked CTE but NOT in the converted CTE.

[Aidan_Au]

Google SQL question: my approach

WITH clicked_sites_table AS (
SELECT
DISTINCT w.url
FROM
google_search_activity a
JOIN google_search_websites w ON a.website_id = w.website_id
WHERE
a.event_type = 'clicked'
),

converted_sites_table AS (
SELECT
DISTINCT w.url
FROM
google_search_activity a
JOIN google_search_websites w ON a.website_id = w.website_id
WHERE
a.event_type = 'converted'
)

SELECT
url
FROM
clicked_sites_table
WHERE
url NOT IN (
SELECT
url
FROM
converted_sites_table
)