Okay! This video explains a four-step approach to solving SQL questions using an example from Uber. Here's a quick breakdown:
Step 1: Understand the Data (0:19-0:22): The video starts by explaining the data set of Uber rides, including distance traveled and cost for each ride (0:56-1:05).
Step 2: Assumptions and Talking Through the Logic (0:22-0:41): The presenter discusses assumptions and clarifies questions about the data, such as how to handle null values and zeros in the denominator (3:02-4:03).
Step 3: Writing the Query (0:41-5:02): This involves extracting the year and month from the date (4:10-4:16), computing the distance-to-cost ratio at both the date (4:22-4:30) and month levels (4:33-4:47), and then finding the absolute difference between these two values (4:47-5:02).
Step 4: Finalizing the Query (5:04-5:21): This includes rounding off the values and finding the average of the absolute differences to two decimal places (5:04-5:21). The video then walks through the SQL query (5:25), explaining each part.
Finally, the presenter runs the query (12:57) and uses a cloud feature to optimize it (13:17).
Subscribe 🤝 | React 🤓 | Drop 💬 | Re-share ♻️
Поделиться в:
Доступные форматы для скачивания:
Скачать видео mp4
Информация по загрузке:
Скачать аудио mp3
Похожие видео
array(10) {
[0]=>
object(stdClass)#5585 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "D3t2lEF1mDw"
["related_video_title"]=>
string(80) "SQL Challenges (MAANG) | Video 5: Hard SQL question by @wholefoods - Basket Size"
["posted_time"]=>
string(27) "5 месяцев назад"
["channelName"]=>
string(18) "Sundeep Kondaveeti"
}
[1]=>
object(stdClass)#5558 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "wIyHSOugGGw"
["related_video_title"]=>
string(43) "Every React Concept Explained in 12 Minutes"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(13) "Code Bootcamp"
}
[2]=>
object(stdClass)#5583 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "QCKBN4W6SFM"
["related_video_title"]=>
string(82) "Build a Python RAG app with Qdrant, Docling, Gemini - With Sabrina Aquino, @qdrant"
["posted_time"]=>
string(24) "12 часов назад"
["channelName"]=>
string(16) "Francesco Ciulla"
}
[3]=>
object(stdClass)#5590 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "8L51FUsjMxA"
["related_video_title"]=>
string(115) "Как устроена База Данных? Кластеры, индексы, схемы, ограничения"
["posted_time"]=>
string(27) "6 месяцев назад"
["channelName"]=>
string(25) "Артём Шумейко"
}
[4]=>
object(stdClass)#5569 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "laf64Ms0yV4"
["related_video_title"]=>
string(33) "The correct way to optimise React"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(16) "Cosden Solutions"
}
[5]=>
object(stdClass)#5587 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "HV99mN0pDs0"
["related_video_title"]=>
string(87) "Все, что нужно знать про 1С для старта за 13 минут!"
["posted_time"]=>
string(19) "2 дня назад"
["channelName"]=>
string(86) "Программирование в 1С с Ильясом Низамутдиновым"
}
[6]=>
object(stdClass)#5582 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "i-FFVM4cIXQ"
["related_video_title"]=>
string(138) "База по Базам Данных - Storage (Индексы, Paging, LSM, B+-Tree, R-Tree) | Влад Тен Систем Дизайн"
["posted_time"]=>
string(22) "11 дней назад"
["channelName"]=>
string(15) "Влад Тен"
}
[7]=>
object(stdClass)#5592 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "KFgwXXWT7sQ"
["related_video_title"]=>
string(170) "ИИ-агенты — вот что действительно изменит разработку. Пишем ИИ-агент на Python, LangChain и GigaChat"
["posted_time"]=>
string(23) "1 месяц назад"
["channelName"]=>
string(29) "Диджитализируй!"
}
[8]=>
object(stdClass)#5568 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "jjQPzaKHhpc"
["related_video_title"]=>
string(110) "Comedy Club: Курсы альфа-самца | Кравец, Шальнов, Бутусов @ComedyClubRussia"
["posted_time"]=>
string(19) "2 дня назад"
["channelName"]=>
string(11) "Comedy Club"
}
[9]=>
object(stdClass)#5586 (5) {
["video_id"]=>
int(9999999)
["related_video_id"]=>
string(11) "NOzi4wBHn0o"
["related_video_title"]=>
string(34) "What are JavaScript PROMISES? 🤞"
["posted_time"]=>
string(19) "1 год назад"
["channelName"]=>
string(8) "Bro Code"
}
}
