Skip to content

Real Data Science SQL Interview Questions and Answers # 1 | Data Science Interview Questions - YouTube

Bram Adams
Bram Adams
1 min read

Table of Contents

 https://www.youtube.com/watch?v=Td-cmLfQ7uU&ab_channel=TinaHuang
 01:40

building a potential and reasonable schema

 02:28

-- is a comment in SQL

 03:06

FROM -> JOIN -> ONAND

 04:21

line 13: build a function by using SELECT

 04:34

COUNT (DISTINCT …)

https://bram-adams.ghost.io/content/images/2023/01/sql-date-trunc-tina.png
sql date trunc tina.png
  1. joining all iOS and web users by ID
  2. func DATE_TRUNC
  3. num_users = distinct count by 'day'
  4. group the result into num_users and day
https://bram-adams.ghost.io/content/images/2023/01/real-data-sci-sql-interview-tina-huang-Screenshot-2023-01-09-17-15-59.png
real data sci sql interview tina huang Screenshot 2023-01-09 17-15-59.png

CREATE TABLE

INSERT INTO
VALUES
(now()), INTERVAL (time)

sqlyoutube-notes

Bram Adams

writer, programmer

Comments


Related Posts

Members Public

Notes on The History of Menswear

All about the history of menswear, from the Chinese ruling class wearing nail polish to the introduction of modern streetwear.

Notes on The History of Menswear
Members Public

Notes on OpenAI Q&A Finetuning GPT-3 Vs Semantic Search - Which to Use, When, and Why

A great video about finetuning vs semantic search. Finetuning teaches a model to write new patterns, not to have a theory of mind.

Members Public

I Programmed a YouTube Clipper

Just to capture this goated moment on a Kripp vid Are you on the guest list? x 3 It captures the current time from a YouTube share link and adds 5 seconds to the end time, subtracts 5 seconds from the start time. Get it here ⬇️ GitHub - bramses/ytclip-10s