👨💻 Learn How to Code with Private Classes - www.dorscodingschool.com/coachingplans ❓Having a hard time with CS50, FreeCodeCamp or Odin Project? Practice with our exclusive free coding platform: www.codingdors.com/ 🎯 Are You A Coding Expert? Take Our Free Quiz and Find Out - www.dorscodingschool.com/quiz
Thank you! I actually got the city right but was confused with interconnections of tables and got the Theif and Accomplice wrong first time, now I see why this happened, Thank you for explaining!
Glad to hear that! By the way, we have a Telegram Group to help people learn how to code and where you can connect with learners from all over the world. Over there you can ask any question about programming and you can easily get your questions answered within 24 hours. Besides that, you will have access to our membership with more than 400 problems made by us to ease your learning curve and 1 hour of group coaching every month! Check www.dorscodingschool.com/products
Key moments: 00:00 The video discusses a problem set called '50 view' in CS50, focusing on solving a mystery using SQL to find out who stole the CS50 duck and where they escaped. The task involves analyzing a database with specific information to unravel the mystery. -Explanation of the '50 view' problem set in CS50 and the use of SQL to solve a mystery about a stolen CS50 duck and its escape location. -Detailed overview of the database structure and tables involved in solving the mystery, emphasizing the importance of the crime scene reports table. -Demonstration of using SQL queries to extract specific information from the database, such as descriptions related to the crime scene, witnesses, and interview transcripts. 06:04 The video discusses using SQL queries to analyze interview transcripts to identify suspects based on specific criteria like timestamps and activities mentioned in the text. This method helps narrow down potential suspects for further investigation. -Analyzing interview transcripts using SQL queries to filter suspects based on timestamps and activities mentioned in the text. -Utilizing the relationship between license plates in security logs and people tables to identify suspects by name. -Implementing SQL joins and select statements to extract relevant information for identifying suspects from the data. 12:08 The video discusses identifying suspects using database queries. It demonstrates joining tables to extract information like names and activities, aiding in solving a theft case. -Utilizing database tables for ATM transactions and bank accounts to link account numbers with names, enabling identification of suspects involved in the theft case. -Explaining the process of joining tables like people, bank accounts, and ATM transactions to extract relevant information such as names and transaction details for suspect identification. 18:11 To identify the passengers for the earliest flight, a complex SQL query involving multiple tables is used to match passport numbers, flight IDs, and airport IDs. -Working with multiple tables to extract passenger information for the earliest flight using SQL queries. -Utilizing SQL joins and conditions to link passengers, flights, and airports data for investigative purposes. -Analyzing phone call data to determine the suspect involved in a brief call, connecting phone numbers to individuals through SQL queries. 24:15 The video discusses using SQL queries to identify suspects in a scenario involving phone calls and flight data, ultimately revealing the main suspect and accomplice. -Analyzing phone call data to identify suspects based on phone numbers and call details. -Utilizing flight data to determine the escape destination of suspects by matching airport IDs. -Using SQL queries to link phone calls between suspects and uncovering the accomplice through call receiver information. The thief is Bruce, who escaped to New York City, and the accomplice is Robin.
Wow, I had the right answer for ages and couldn’t figure out why I was wrong. Spoiler: Turned out I was typing in the name of the airport as the location (LaGuardia) but the answer was right next to it (NYC)
I did try to use this explanation to learn how to use JOIN. But anyway, I stuck as before. The only way I can solve this PROBLEM SET and any others is: implicit join. Who had the same issue? How did you handle it?
It's hard. You need to think if you need to create a new table joining both tables or if you need a subquery (so you use IN). We highly recommend sqlbolt.com/, it will help you understand this. By the way, we have a Telegram Group to help people learn how to code and where you can connect with learners from all over the world. Over there you can ask any question about programming and you can easily get your questions answered within 24 hours. Besides that, you will have access to our membership with more than 400 problems made by us to ease your learning curve and 1 hour of group coaching every month! Check www.dorscodingschool.com/products
![[2023] CS50 - (Week 8) Trivia Solution | Walkthrough & Guide for Beginners | By Anvea](http://i.ytimg.com/vi/0fzPIphkBSE/mqdefault.jpg)
👨💻 Learn How to Code with Private Classes - www.dorscodingschool.com/coachingplans
❓Having a hard time with CS50, FreeCodeCamp or Odin Project? Practice with our exclusive free coding platform: www.codingdors.com/
🎯 Are You A Coding Expert? Take Our Free Quiz and Find Out - www.dorscodingschool.com/quiz
Nice job, if You want find common part of each query You can use INTERSECT between them.
SELECT .........
INTERSECT
SELECT.........;
Thank you! I actually got the city right but was confused with interconnections of tables and got the Theif and Accomplice wrong first time, now I see why this happened, Thank you for explaining!
Glad to hear that!
By the way, we have a Telegram Group to help people learn how to code and where you can connect with learners from all over the world. Over there you can ask any question about programming and you can easily get your questions answered within 24 hours.
Besides that, you will have access to our membership with more than 400 problems made by us to ease your learning curve and 1 hour of group coaching every month!
Check www.dorscodingschool.com/products
Key moments:
00:00 The video discusses a problem set called '50 view' in CS50, focusing on solving a mystery using SQL to find out who stole the CS50 duck and where they escaped. The task involves analyzing a database with specific information to unravel the mystery.
-Explanation of the '50 view' problem set in CS50 and the use of SQL to solve a mystery about a stolen CS50 duck and its escape location.
-Detailed overview of the database structure and tables involved in solving the mystery, emphasizing the importance of the crime scene reports table.
-Demonstration of using SQL queries to extract specific information from the database, such as descriptions related to the crime scene, witnesses, and interview transcripts.
06:04 The video discusses using SQL queries to analyze interview transcripts to identify suspects based on specific criteria like timestamps and activities mentioned in the text. This method helps narrow down potential suspects for further investigation.
-Analyzing interview transcripts using SQL queries to filter suspects based on timestamps and activities mentioned in the text.
-Utilizing the relationship between license plates in security logs and people tables to identify suspects by name.
-Implementing SQL joins and select statements to extract relevant information for identifying suspects from the data.
12:08 The video discusses identifying suspects using database queries. It demonstrates joining tables to extract information like names and activities, aiding in solving a theft case.
-Utilizing database tables for ATM transactions and bank accounts to link account numbers with names, enabling identification of suspects involved in the theft case.
-Explaining the process of joining tables like people, bank accounts, and ATM transactions to extract relevant information such as names and transaction details for suspect identification.
18:11 To identify the passengers for the earliest flight, a complex SQL query involving multiple tables is used to match passport numbers, flight IDs, and airport IDs.
-Working with multiple tables to extract passenger information for the earliest flight using SQL queries.
-Utilizing SQL joins and conditions to link passengers, flights, and airports data for investigative purposes.
-Analyzing phone call data to determine the suspect involved in a brief call, connecting phone numbers to individuals through SQL queries.
24:15 The video discusses using SQL queries to identify suspects in a scenario involving phone calls and flight data, ultimately revealing the main suspect and accomplice.
-Analyzing phone call data to identify suspects based on phone numbers and call details.
-Utilizing flight data to determine the escape destination of suspects by matching airport IDs.
-Using SQL queries to link phone calls between suspects and uncovering the accomplice through call receiver information.
The thief is Bruce, who escaped to New York City, and the accomplice is Robin.
This practice problem was amazing. Thanks for sharing! :)
Thank you! Excellent technical communication! I found your solution logical and easy to follow.
Great to hear!
Wow, I had the right answer for ages and couldn’t figure out why I was wrong.
Spoiler: Turned out I was typing in the name of the airport as the location (LaGuardia) but the answer was right next to it (NYC)
Are you Brazilian?
TY🤩
Wow this was challenging!!!
Bruce and Robin gotta Duck... Wwwayne, Bruce. Why it's NY, but not Gotham??
Love this problem! Exellent!
hahahaha great!
Obrigado Giovanna... I hope someday my English skills will be like yours :)
I did try to use this explanation to learn how to use JOIN.
But anyway, I stuck as before.
The only way I can solve this PROBLEM SET and any others is: implicit join.
Who had the same issue?
How did you handle it?
Got it THANKS!!
You're welcome!
ty
well made coding video, thank you :)
Thanks for your comment!
Why can I not join on id's ?
when do you know whenwhich situation to use JOIN or IN ? im kinda confused here
It's hard. You need to think if you need to create a new table joining both tables or if you need a subquery (so you use IN).
We highly recommend sqlbolt.com/, it will help you understand this.
By the way, we have a Telegram Group to help people learn how to code and where you can connect with learners from all over the world. Over there you can ask any question about programming and you can easily get your questions answered within 24 hours.
Besides that, you will have access to our membership with more than 400 problems made by us to ease your learning curve and 1 hour of group coaching every month!
Check www.dorscodingschool.com/products
super
Big tip to anyone doing this. DO NOT assume the 2022 versions ATM is on Humphrey Street.
Thank you!
@@DorsCodingSchool yeah that part stumped me for a full day....
love u
você é brasileira?
Sou sim (:
@@DorsCodingSchool obrigado pelo vídeo :)