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

Tina Huang September 4, 2020
Video Thumbnail
Tina Huang Logo

Tina Huang

@tinahuang1

About

Hi! My name is Tina and I’m an ex-Meta data scientist. This channel is about AI, coding, tech, career and self-study. My goal is always to minimize effort and maximise outcome. I basically refuse to do extra work to achieve my goals (which is why I love AI…)

Video Description

Hi friends! Welcome back to SQL Sundays! A weekly SQL data science interview questions and answers walkthrough. This is another data science SQL interview question and answer done from beginning to end in a real interview style. 🔗Affiliates ======================== My SQL for data science interviews course (10 full interviews): https://365datascience.com/learn-sql-for-data-science-interviews/ 365 Data Science: https://365datascience.pxf.io/WD0za3 (link for 57% discount for their complete data science training) Check out StrataScratch for data science interview prep: https://stratascratch.com/?via=tina 📲Socials ======================== instagram: https://www.instagram.com/hellotinah/ linkedin: https://www.linkedin.com/in/tinaw-h/ discord: https://discord.gg/5mMAtprshX 🤯Study with Tina ======================== Study with Tina channel: https://www.youtube.com/channel/UCI8JpGrDmtggrryhml8kFGw How to make a studying scoreboard: https://www.youtube.com/watch?v=KAVw910mIrI Scoreboard website: scoreboardswithtina.com livestreaming google calendar: https://bit.ly/3wvPzHB 🎥Other videos you might be interested in ======================== SQL Sundays Playlist: https://www.youtube.com/playlist?list=PLVD3APpfd1tuXrXBWAntLx4tNaONro5dA How I learned SQL from Scratch in 11 Days to Pass my FANNG SQL Interview: https://www.youtube.com/watch?v=vaD3ZFFNwhM How I consistently study with a full-time job: https://www.youtube.com/watch?v=INymz5VwLmk How I would learn to code (if I could start over): https://www.youtube.com/watch?v=MHPGeQD8TvI&t=84s 🐈‍⬛🐈‍⬛About me ======================== Hi, my name is Tina and I'm a data scientist at a FAANG company. I was pre-med studying pharmacology at the University of Toronto until I finally accepted that I would make a terrible doctor. I didn't know what to do with myself so I worked for a year as a research assistant for a bioinformatics lab where I learned how to code and became interested in data science. I then did a masters in computer science (MCIT) at the University of Pennsylvania before ending up at my current job in tech :) 📧Contact ======================== youtube: youtube comments are by far the best way to get a response from me! linkedin: https://www.linkedin.com/in/tinaw-h/ email for business inquiries only: [email protected] ======================== Some links are affiliate links and I may receive a small portion of the sales price at no cost to you. I really appreciate your support in helping improve this channel! :)

Upgrade Your Study Sessions

AI-recommended products based on this video

Loading...
45W Charger for Acer Aspire 5 A515-55 A515-54 A515-56 A515-56T A515-57 A514-52G A514-54 A515-46 A515-44 A515-45 Laptop Power Supply Adapter

45W Charger for Acer Aspire 5 A515-55 A515-54 A515-56 A515-56T A515-57 A514-52G A514-54 A515-46 A515-44 A515-45 Laptop Power Supply Adapter

(2)
$20.90
FREE delivery Sun, Jun 15 on your first order
Loading...
65W AC Charger Fit for Acer Aspire 5 1 Series A515 A515-53 A515-53G A515-52 A515-52G A515-52K A515-51 A515-51G A515-41G A515-43 A515-43G A517-51 A517-51G A114-31 A114-32 A111-31 A111-32 Laptop

65W AC Charger Fit for Acer Aspire 5 1 Series A515 A515-53 A515-53G A515-52 A515-52G A515-52K A515-51 A515-51G A515-41G A515-43 A515-43G A517-51 A517-51G A114-31 A114-32 A111-31 A111-32 Laptop

(12)
$23.99
FREE delivery Sun, Jun 15 on your first order
Loading...
Laptop AC Charger for Acer Aspire 5 A515 A515-56 A515-56T A515-55 A515-54 A515-46 A515-45 A515-44 A514-52G A515-57 A514-54 Laptop

Laptop AC Charger for Acer Aspire 5 A515 A515-56 A515-56T A515-55 A515-54 A515-46 A515-45 A515-44 A514-52G A515-57 A514-54 Laptop

(5)
$25.99
FREE delivery Sun, Jun 15 on your first order
Loading...
65W 45W Laptop Charger for Acer Aspire 3 5 A515-55 A515-56 A515-46 A515-54 A515-54G A517-52 Swift Spin 1 3 5 SF113-31 SF114-32 Chromebook 11 R11 13 14 15 CB3 C720 C720P Power Adapter

65W 45W Laptop Charger for Acer Aspire 3 5 A515-55 A515-56 A515-46 A515-54 A515-54G A517-52 Swift Spin 1 3 5 SF113-31 SF114-32 Chromebook 11 R11 13 14 15 CB3 C720 C720P Power Adapter

(64)
$19.98
FREE delivery Sun, Jun 15 on your first order
Loading...
Laptop Sleeve Case 11–14 Inch MacBook Air MacBook Pro Surface Laptop Dell XPS 13 HP Envy Pavilion Lenovo Yoga Slim IdeaPad Acer Swift Chromebook Samsung Galaxy Book Shockproof Leather Bag Colour Blue

Laptop Sleeve Case 11–14 Inch MacBook Air MacBook Pro Surface Laptop Dell XPS 13 HP Envy Pavilion Lenovo Yoga Slim IdeaPad Acer Swift Chromebook Samsung Galaxy Book Shockproof Leather Bag Colour Blue

(98)
$81.45
Loading...
Gumdrop ProTech Case for Dell New XPS 13 Plus 9320 Laptop- Slim Lightweight Case with Energy Displacement Protection, Non-Skid Rubber Feet and Frosted Exterior for Bumps and Drops (Black)

Gumdrop ProTech Case for Dell New XPS 13 Plus 9320 Laptop- Slim Lightweight Case with Energy Displacement Protection, Non-Skid Rubber Feet and Frosted Exterior for Bumps and Drops (Black)

(49)
$109.43$108.34
FREE delivery Aug 11 - 13
Loading...
65W 45W USB C Laptop Charger Compatible with Dell Latitude 5420 5430 5520 5530 7340 7430 Inspiron 14 16 XPS 13 Chromebook 3100 Dell Computer Type C Fast Charging AC Adapter Power Cord

65W 45W USB C Laptop Charger Compatible with Dell Latitude 5420 5430 5520 5530 7340 7430 Inspiron 14 16 XPS 13 Chromebook 3100 Dell Computer Type C Fast Charging AC Adapter Power Cord

(7)
$19.99
FREE delivery Sun, Aug 24 on your first order
Loading...
45W 65W AC Adapter Laptop Charger for Dell Inspiron 15 14 13 17 3000 5000 7000 Series 5558 5559 Charger Latitude E6440 E6430 3520 3420 XPS 13 14 9333 9350 Notebook Dell Computer Power Supply Cord

45W 65W AC Adapter Laptop Charger for Dell Inspiron 15 14 13 17 3000 5000 7000 Series 5558 5559 Charger Latitude E6440 E6430 3520 3420 XPS 13 14 9333 9350 Notebook Dell Computer Power Supply Cord

(52)
$13.99
FREE delivery Sun, Aug 24 on your first order
100+ bought in past month
Loading...
65W 45W Laptop Charger for Lenovo IdeaPad 3 1 1i 5 Slim 3 110 110s 310 320 320S 330 330s S340 S145 S540, for Lenovo IdeaPad Flex 5 4 6 1470 1480 Chromebook N22 N23 N42 AC Adapter Power Supply Cord

65W 45W Laptop Charger for Lenovo IdeaPad 3 1 1i 5 Slim 3 110 110s 310 320 320S 330 330s S340 S145 S540, for Lenovo IdeaPad Flex 5 4 6 1470 1480 Chromebook N22 N23 N42 AC Adapter Power Supply Cord

(0)
$21.99
FREE delivery Sun, Jun 22 on your first order
Loading...
Keyboard Cover for Lenovo Flex 5/IdeaPad 5 14",Lenovo IdeaPad Flex 5i 14"/Slim 7 9/Yoga 5i 7i/Yoga 9 7 Pro/Slim 7 pro x Keyboard Skin, ThinkBook 14 14s/Yoga Pro 14s Protector

Keyboard Cover for Lenovo Flex 5/IdeaPad 5 14",Lenovo IdeaPad Flex 5i 14"/Slim 7 9/Yoga 5i 7i/Yoga 9 7 Pro/Slim 7 pro x Keyboard Skin, ThinkBook 14 14s/Yoga Pro 14s Protector

(556)
$31.35$23.92
FREE delivery Jun 20 - 25
Loading...
65W Laptop Charger for Lenovo IdeaPad Flex, Ideapad 3 5 1 330 330S 320 310 S340 S145 110 120 120S 130 100 510 Flex 5 4 6 14 15 1470 1480 1570 1580 Yoga 720 710 Chromebook N22 N23 V15 V14 Adapter Cord

65W Laptop Charger for Lenovo IdeaPad Flex, Ideapad 3 5 1 330 330S 320 310 S340 S145 110 120 120S 130 100 510 Flex 5 4 6 14 15 1470 1480 1570 1580 Yoga 720 710 Chromebook N22 N23 V15 V14 Adapter Cord

(10)
$17.99
FREE delivery Sun, Jun 22 on your first order
Loading...
65W 45W AC Charger Fit for Lenovo IdeaPad Flex Slim 1 3 4 5 6 100 100S 110 120S 130 130S 310 310S 320 320S 330 330S 510 510S 520 530 530S 710 710S L340 C340 C640 S130 S145 S310 S340 S530 Laptop

65W 45W AC Charger Fit for Lenovo IdeaPad Flex Slim 1 3 4 5 6 100 100S 110 120S 130 130S 310 310S 320 320S 330 330S 510 510S 520 530 530S 710 710S L340 C340 C640 S130 S145 S310 S340 S530 Laptop

(16)
$19.99
FREE delivery Sun, Jun 22 on your first order
Loading...
Apple 2025 MacBook Air 13-inch Laptop with M4 chip: Built for Apple Intelligence, 16GB Unified Memory, 256GB SSD Storage, Touch ID; Sky Blue - English Keyboard

Apple 2025 MacBook Air 13-inch Laptop with M4 chip: Built for Apple Intelligence, 16GB Unified Memory, 256GB SSD Storage, Touch ID; Sky Blue - English Keyboard

(687)
$1,249.99
PrimeFREE delivery Sat, Jun 14
100+ bought in past month
Loading...
TP-Link USB C To Ethernet Adapter (UE300C) - J45 To USB C [Thunderbolt 3/4 Compatible] Type-C Gigabit Ethernet LAN Network Adapter, Compatible With Apple MacBook Pro 2017-2023, MacBook Air, And More

TP-Link USB C To Ethernet Adapter (UE300C) - J45 To USB C [Thunderbolt 3/4 Compatible] Type-C Gigabit Ethernet LAN Network Adapter, Compatible With Apple MacBook Pro 2017-2023, MacBook Air, And More

(11,192)
$12.99$10.39
FREE delivery Sat, Jun 14 on your first order
500+ bought in past month
Loading...
Asus Zenbook S 14, Next-Level AI PC, 14” Ultrathin Laptop, 3K 120Hz OLED Touchscreen, Intel Core™ Ultra 7 (Series 2) Processor, 16GB Memory, 1TB SSD, Wi-Fi 7, Zumaia Gray, UX5406SA-DH71T-CB

Asus Zenbook S 14, Next-Level AI PC, 14” Ultrathin Laptop, 3K 120Hz OLED Touchscreen, Intel Core™ Ultra 7 (Series 2) Processor, 16GB Memory, 1TB SSD, Wi-Fi 7, Zumaia Gray, UX5406SA-DH71T-CB

(0)
$1,699.00$1,292.94
FREE deliveryTemporarily out of stock.
Loading...
Asus Zenbook Duo (2024), Dual 14” FHD OLED Touch Laptop, Intel Evo Certified, Intel Core Ultra 7 155H CPU, Intel Arc Graphics, 16GB Memory, 1TB SSD, Windows 11 Home, UX8406MA-DS71T-CA

Asus Zenbook Duo (2024), Dual 14” FHD OLED Touch Laptop, Intel Evo Certified, Intel Core Ultra 7 155H CPU, Intel Arc Graphics, 16GB Memory, 1TB SSD, Windows 11 Home, UX8406MA-DS71T-CA

(29)
$1,639.97$1,074.31
FREE delivery Sat, Jan 3Only 2 left in stock.
Loading...
Asus Zenbook Duo (2025), AI, Dual 14” WUXGA OLED Touch Laptop, Intel Evo, Intel Core Ultra 9 285H CPU, Intel Arc, 16GB RAM, 1TB SSD, Wi-Fi 7, Windows 11 Home, Inkwell Gray, UX8406CA-DS91T-CA

Asus Zenbook Duo (2025), AI, Dual 14” WUXGA OLED Touch Laptop, Intel Evo, Intel Core Ultra 9 285H CPU, Intel Arc, 16GB RAM, 1TB SSD, Wi-Fi 7, Windows 11 Home, Inkwell Gray, UX8406CA-DS91T-CA

(3)
$1,998.00
FREE delivery Jan 27 - Mar 1
Loading...
Asus Zenbook A14; Copilot+ PC, Ultrathin Laptop, 14” WUXGA OLED, Snapdragon® X Processor, 32 GB Memory, 1TB SSD, Wi-Fi 6E, Iceland Gray, UX3407QA-DS51-CA

Asus Zenbook A14; Copilot+ PC, Ultrathin Laptop, 14” WUXGA OLED, Snapdragon® X Processor, 32 GB Memory, 1TB SSD, Wi-Fi 6E, Iceland Gray, UX3407QA-DS51-CA

(12)
$1,198.00$958.40
FREE delivery Sat, Jan 10
Loading...
tomtoc 360 Protective Laptop Sleeve for 15.6 Inch Acer Aspire 1/3/5 15 Slim Laptop, 15.6-16 Inch ASUS Strix G16/G15, HP Pavilion 15, Lenovo Ideapad 3 Laptop, 15.6 Inch Dell Samsung Notebook Ultrabook

tomtoc 360 Protective Laptop Sleeve for 15.6 Inch Acer Aspire 1/3/5 15 Slim Laptop, 15.6-16 Inch ASUS Strix G16/G15, HP Pavilion 15, Lenovo Ideapad 3 Laptop, 15.6 Inch Dell Samsung Notebook Ultrabook

(3,132)
$37.59
FREE delivery Sat, Jun 21
Loading...
Lg gram 16-inch +View Portable Monitor with USB Type-C, DCI-P3 99% (Typ.), Auto Rotate, Two-Way Supported Folio Cover

Lg gram 16-inch +View Portable Monitor with USB Type-C, DCI-P3 99% (Typ.), Auto Rotate, Two-Way Supported Folio Cover

(36)
$328.99$263.19
FREE delivery Tue, Aug 12
Loading...
Lenovo IdeaPad Duet 3i 10.3" Touchscreen Intel Celeron N4020, 2-in-1 Laptop, Windows 11 Home S Mode + Includes 1-Year Microsoft 365 Personal - 82AT00KJCC

Lenovo IdeaPad Duet 3i 10.3" Touchscreen Intel Celeron N4020, 2-in-1 Laptop, Windows 11 Home S Mode + Includes 1-Year Microsoft 365 Personal - 82AT00KJCC

(125)
$255.88
FREE delivery Sun, Jun 22
Loading...
230W Charger Compatible with Razer Blade 14” 15” 16" 17” (2025-2018) RZ09 RTX-3060/3070/3080/4060/4070 Gaming Laptop RC30-0530 RC30-0238 RC30-0248 Replacement Power Adapter

230W Charger Compatible with Razer Blade 14” 15” 16" 17” (2025-2018) RZ09 RTX-3060/3070/3080/4060/4070 Gaming Laptop RC30-0530 RC30-0238 RC30-0248 Replacement Power Adapter

(16)
$67.99
FREE delivery Mon, Feb 16
Loading...
Charger for Dell Inspiron 15 Charger, 65W Dell Inspiron 15 14 13 3000 5000 7000 Series, Dell Latitude 13 3301 3390 14 3400 3410 3420 3490 15 3500 3510 3520 3590, Dell Vostro, 4.5 * 3.0mm Power Cord

Charger for Dell Inspiron 15 Charger, 65W Dell Inspiron 15 14 13 3000 5000 7000 Series, Dell Latitude 13 3301 3390 14 3400 3410 3420 3490 15 3500 3510 3520 3590, Dell Vostro, 4.5 * 3.0mm Power Cord

(97)
$19.99
FREE delivery Sun, Aug 24 on your first order
50+ bought in past month
Loading...
65W 45W Laptop Charger Compatible with Dell Inspiron 15 5000 7000 3000 5555 5558 3511 Inspiron 17 14 13 3000 5000 7000 Latitude E6440 E6430 3520 3420 XPS 13 14 9333 Power Supply Cord

65W 45W Laptop Charger Compatible with Dell Inspiron 15 5000 7000 3000 5555 5558 3511 Inspiron 17 14 13 3000 5000 7000 Latitude E6440 E6430 3520 3420 XPS 13 14 9333 Power Supply Cord

(52)
$17.62
FREE delivery Sun, Aug 24 on your first order
300+ bought in past month
Loading...
45W 65W AC Adapter Laptop Charger for Dell Inspiron 15 14 13 17 3000 5000 7000 Series 5558 5559 Charger Latitude E6440 E6430 3520 3420 XPS 13 14 9333 9350 Notebook Dell Computer Power Supply Cord

45W 65W AC Adapter Laptop Charger for Dell Inspiron 15 14 13 17 3000 5000 7000 Series 5558 5559 Charger Latitude E6440 E6430 3520 3420 XPS 13 14 9333 9350 Notebook Dell Computer Power Supply Cord

(52)
$13.99
FREE delivery Sun, Aug 24 on your first order
100+ bought in past month
Loading...
65W 45W AC Adpter for Dell Laptop Charer fit for Dell Inspiron 13 14 15 17 3000 5000 7000 Series 3520 3558 5558 3583 3511 5570 XPS 9333 9350 Latitude 3310 Vostro 3425 3520 Computer Round Tips Charger

65W 45W AC Adpter for Dell Laptop Charer fit for Dell Inspiron 13 14 15 17 3000 5000 7000 Series 3520 3558 5558 3583 3511 5570 XPS 9333 9350 Latitude 3310 Vostro 3425 3520 Computer Round Tips Charger

(4)
$17.59
FREE delivery Sun, Aug 24 on your first order
50+ bought in past month
Loading...
Bose QuietComfort Wireless Noise Cancelling Headphones, Bluetooth Over Ear Headphones with Up to 24 Hours of Battery Life, Moonlight Grey - Limited Edition

Bose QuietComfort Wireless Noise Cancelling Headphones, Bluetooth Over Ear Headphones with Up to 24 Hours of Battery Life, Moonlight Grey - Limited Edition

(12,251)
$269.00
FREE delivery Tue, Oct 14