filmov
tv
Using IFNULL() on a Google SQL Interview Question
Показать описание
This video will walk you through Google's "Videos Removed on Latest Date" SQL interview question.
We explore two datasets and use of IFNULL() function and SQL queries to find the latest date when flags got reviewed for each unique user, and then determine the total number of distinct videos that got removed on that date. Along the way, we discuss important SQL concepts such as filtering, joining, and aggregating tables.
Join us to see how we solve this hard-level problem!
Go to the question through the link below and follow along with me 👇
______________________________________________________________________
______________________________________________________________________
Timeline:
Intro: (0:00)
Interview Question: (0:18 )
Exploring and understanding the dataset: (1:02)
Writing out the approach: (2:39)
Coding the solution: (3:42)
Conclusion: (7:46)
______________________________________________________________________
About The Platform:
______________________________________________________________________
Contact:
If you have any questions, comments, or feedback, please leave them here!
______________________________________________________________________
#googleinterviewquestion #mysql
We explore two datasets and use of IFNULL() function and SQL queries to find the latest date when flags got reviewed for each unique user, and then determine the total number of distinct videos that got removed on that date. Along the way, we discuss important SQL concepts such as filtering, joining, and aggregating tables.
Join us to see how we solve this hard-level problem!
Go to the question through the link below and follow along with me 👇
______________________________________________________________________
______________________________________________________________________
Timeline:
Intro: (0:00)
Interview Question: (0:18 )
Exploring and understanding the dataset: (1:02)
Writing out the approach: (2:39)
Coding the solution: (3:42)
Conclusion: (7:46)
______________________________________________________________________
About The Platform:
______________________________________________________________________
Contact:
If you have any questions, comments, or feedback, please leave them here!
______________________________________________________________________
#googleinterviewquestion #mysql
0:08:09
Using IFNULL() on a Google SQL Interview Question
0:02:54
Fórmula IFNULL - Google Data Studio
0:05:43
9.6. Data Blending: Calculated Fields & Nulls (Looker Studio Masterclass) (Full Data Studio Cour...
0:00:53
Using IFNULL() Function in MySQL to Avoid Null Value Errors
0:06:48
Return True Blanks - IF, VLOOKUP, IFERROR - Google Sheets
0:10:31
How to Fix N/A, Null, 0... in Looker Studio
0:07:10
Strategies for optimizing your BigQuery queries
0:05:16
Blank Cells in Google Sheets? || If Cell is Blank Return Value or Blank
0:10:11
IMPORTRANGE Function in Google Sheets | Multiple Sheets
0:00:14
Minecraft Hungry Herobrine #Shorts
0:00:29
SQL Trick Using COALESCE function #sqltricks #sqltips
0:00:23
Null Vs Alice | Requested
0:03:36
How to Return a Blank Cell If Zero in Excel? 3 Methods- IF Formula, Custom Formatting, Sheet Option
0:17:43
Google Sheets Apps Script - If, Then, Else If, Else JavaScript Statements Tutorial - Part 6
0:03:17
the TRUTH about C++ (is it worth your time?)
0:06:25
How to Ignore Formula / Not Calculate If Cell is Blank in Excel
0:13:40
7. When if Condition in Google Data Studio
0:02:24
Sign Into Complete Purchase Error Fix On iPhone iPad iPod -How To Fix All Apple iD Purchases Errors
0:00:38
(Bug) Infinite Credits Glitch in Brawl Stars! #shorts #brawlstars #brawlstarsglitch
0:04:48
If Cell is Blank Then ... Return Value or Blank in Excel
0:00:58
Remove #Div-0 Errors From Excel Worksheets
0:10:22
Entendiendo IF e IFNULL de SQL con Google BigQuery (CON EJEMPLOS)
0:06:41
Using ISNULL to Replace Missing Values in your Queries | Essential SQL
0:08:30
Postman API Testing Tutorial | Postman Tutorial For Beginners 2022
Комментарии