Video

Coding choice. You're correct - you don't need == 1. It's just a more efficient way of doing things (how I was taught). With == 1 is more explicit and makes sure that only ONE item is read per iteration. Without == 1 we rely on the true/false evaluation of the return value. Both work but adding == 1 is what I learned from the past in my teachings.

think 9 changed: In 9.sql, write a SQL query to list the names of all people who starred in a movie released in 2004, ordered by birth year. Your query should output a table with a single column for the name of each person. People with the same birth year may be listed in any order. No need to worry about people who have no birth year listed, so long as those who do have a birth year are listed in order. If a person appeared in more than one movie in 2004, they should only appear in your results once. SELECT DISTINCT p.name FROM people p JOIN stars s ON p.id = s.person_id JOIN movies m ON s.movie_id = m.id WHERE m.release_year = 2004 ORDER BY p.birth_year;

@@RealisticResponse as a comp engineering student, I can say that you have a great teaching and explaining style. With you I've improved my coding knowledge. Thank you so much :)

I absolutely am still responding :) ready for this one? In my opinion this is the first complicated piece of code we write so here we go: preferences[i][j]: So preferences is a 2D array. Each ROW matches to a VOTER Each COLUMN within a row represents the RANK (1st, 2nd, 3rd, etc.) of the candidate that the VOTER has chosen. So, pref[i][j] gives you the index of the candidate that voter i ranked at position j. We use the VALUE from preferences[i][j] as an index into the candidates array. The CANDIDATES array is an array of candidate structs. So, candidates[preferences[i][j]] gives you the candidate struct FOR the candidate that voter i ranked in position j. For .eliminated == false: Now that we have candidate struct, we can access its eliminated field to check whether this candidate has been eliminated from the election or not. So: Say we have three candidates (Alice, Bob, and Charlie), and the preferences of the FIRST voter (voter 0) are stored in preferences[0]. If preferences[0][0] is 2, that means this voter’s first choice is the candidate at index 2 in the candidates array (Charlie because machines start counting at 0). Hopefully this helps - its a big one.

This is answered in many many comments and referenced 4 times in the video. Please see other comments that will help solve this.

Most definitely. What happens on your check50? where are the errors? you have to find and debug. This is a very tedious project and you can't be missing anything but you should not be receiving a 1/21.

A previous version I wrote. It doesn't serve a purpose. I was going in a different direction and left it in. but it is a dead line of code so shouldn't impact yours if you do not use. This video took so long to do, removing something I didn't end up using in the end became to tedious so it died in-line.

I'm so happy you came here only looking for help with a specific portion! That is excellent work you're doing. Keep it up and I'm happy I helped!

Until I can dedicate a bit more time to it, its down unfortunately. I hope to get it up and running again, but I just didn't have the necessary availability to keep up with demand for a bit.

This is a top quality comment. I love seeing other solutions and thank you for showing others a more efficient way. Sometimes in my codes I get a bit lost going back and forth and talking and typing and editing etc. Please always feel free to offer alternative solutions and thanks for helping others!

oh wait check50 is different from when you did it with your other video. hmmm.

Did you solve the issue? I am struggling the same error((

​@@xsenyus7521 it is a bit different but the issue is the same. This comment is the number one question and there are lots of responses and comments that help solve it. I also mention this 4 times in the video. All values must be usd which is defined in the existing code. If you convert all values to usd this should solve your problem. If that doesnt make sense, look to previous comments as we've solved it many times. That should help.

I dont think 2024 is requiring the api key - can you tell me abit more?

What's important is you not quitting. Hopefully my video was helpful and I appreciate your support. Keep up the great work!

HA! heigth and becasue always get me. I think one hand types faster than the other and those particular two words always end up slightly off. Excellent catch and thanks for letting me know :) keep up the great work. Good catch!

All values need to be in USD format. I have to re-do this video explaining this since it's the Number 1 asked question. There should be lots of help here in the comments section since that one gets asked a lot. Hopefully previous comments can point you in the right direction.

Debugging code is like trying to solve a murder where you're also the killer :)

Keep up the great work!

Most likely the use of DISTINCT keyword in with the ORDER BY. When using DISTINCT, it removes duplicate rows based on the selected columns. So DISTINCT name will only return unique names, but if there are different people with the same name, could return less results. Also, ORDER BY birth ASC clause orders by the birth column, but since you’re only selecting name, this might be causing issues depending on the SQL implementation. Here is 9: list the names of all people who starred in a movie released in 2004, ordered by birth year. Your query should output a table with a single column for the name of each person. People with the same birth year may be listed in any order. No need to worry about people who have no birth year listed, so long as those who do have a birth year are listed in order. If a person appeared in more than one movie in 2004, they should only appear in your results once. So you need something like: SELECT DISTINCT name FROM people JOIN stars ON people.id = stars.person_id JOIN movies ON stars.movie_id = movies.id WHERE movies.year = 2004 ORDER BY people.birth ASC;

@@RealisticResponse You also use DISTINCT and ORDER BY, one more thing is if I remove DISTINCT then the result will be correct. I think the error is on CS50 side.

@@RealisticResponse I have the exact same problem. I have the same lines as you, the only difference is I didn't write ASC at the end, and I didn't write the "synonyms". But anyway, my result is always 19261 values also. It's been hours I'm checking it but can't find the problem...

Sqlite3 finance.db in terminal

@lgachaboyyt the code that he shows in text file...do i keep that code in a .sql file inside finance folder? I did that but it didnt work

@@omarhoque1662 Hopefully everyone here is a bit of a rookie. In case you haven't figured this out yet - watch at 10:45. You have to enter the slite3.db command to get 'into' your sql file (recall your sql week). then enter the code to update sql, then back out of sql to get back into our regular file. You shouldn't be writing a new sql fie - there's already one there - having 2 can be problematic.

Can tell you how much this means to me. I keep getting downhearted since making these. Not all of the feedback is positive and it gets tough trying to help people all over the world. But comments like this definitely keep me motivated. I appreciate you, and congratulations on making it this far!

brother, can you tell me what he meant in 10:50 , how do I add the codes in the sql file? I wrote the codes in a seperate .sql file and kept it inside finance folder , then i went to sqlite3 and now what?

@@omarhoque1662 I wrote a response on your other comment - hopefully it helps. but get into your sql file b entering the command sqlit3.db to enter the existing sql database (recall sql week and manipulation).

Not really, What it's doing is checking if the first four bits of binary are 1110 - since those bits indicate a jpg, we search the first part of each file for that sequence. So the first 4 bytes of a jpg hexideceimal are: 0xff, 0xd8, 0xff. And the fourth bit is USUALLY 0xe. So we're checking the first 4 bits to see if they match that sequence. Does that make more sense?

Even people who don't watch my videos are likely to have similar, or the same codes. I designed these videos to teach, not to cheat. So let me ask you this, did you learn from my videos? did they help? or did you just copy and paste? Because if we took this class together and I helped you figure something out you didnt know as a classmate, if we had the same code, are we cheating? or did we help one another. The answer is up to you and in your heart, if that makes sense. There are likely videos on yT that help you cheat. Mine are wholly designed to help you learn. I may not be the best, but hopefully I get better, and I'll keep trying.

@@RealisticResponse the perfect reply doesn’t exist! I agree with you. Truly saying, I did learn a lot but I still won’t consider myself fully comfortable with all those problem sets but that’s natural ;) I got my answers, thank you Devin !

@@AmitojSingh_2402 Congratulations on making it through and I'm happy I was a helpful part of your journey. keep up the good work!

html is a great way to showcase your skills. Building off something you've already created is ALSO helpful. I'd say you're on your way to creating something interesting. Blog's are a good example to show what you learned. Maybe ad a page on your "about me" where you can enter a status update, or update a journal, or something like that.

@@RealisticResponse I see. Yea for example in my about me site, I can continue updating still like job/volunteer experience, and wherever applicable. Thank you cuz at least now I have a goal that I need to accomplish. Really appreciated :))

@@AmitojSingh_2402 Always a pleasure and thank you for your support!

Thank YOU! Keep up the good work!

Oh 100%! I feel like there's a little lack of teaching on some of those topics too. Like they felt that base teaching was enough. But when we learn to join, like you said, not only is it easier, it's more likeable to a programmer. At least I think.

Absolutely! Hope you enjoyed SQL!

@@RealisticResponse I did! It became my fav till week 8. html and css are my fav now 😅

I don't show the whole code because people would come to this video to copy and paste. My channel is designed in a way to not make me feel like I'm helping people cheat, but helping them learn. That's the only reason I don't post the whole code as it would be like posting a solution. Hope that makes sense. As for your question, when you run flask it should run for all of hem if they're properly linked and you're in the correct directory. Perhaps I'm misunderstanding the question?

The way you look up alternative ways to solve is next level. Knowing ways to solve a code in a way that you didn't do it is always going to make you a better coder. Congrats on solving it and props for looking at alternatives. keep up the great work!

How Can I help?

How can I help?

@jiasubaowenke never really thought about it. I used sys.exit because I wanted it to exit the program if it was an error. Return 1 would work just as well but sys.exit allows the program to stop running instead of trying to complete and just throw an error code... if that makes sense. Also, as these videos age, it's possible I used it to show it's use and neglected to mention the why. For the purpose of this exercise I'm quite sure you're correct in thinking either would work just as well. Great catch and great question.

@AmitojSingh_2402 love this comment. And how true! After grasping for straws for C, we get into sql and it feels like a language we can speak again!

Hey there. Try not to feel that way. If you're new to coding, Not all of this is going to be easy - It's why I tried to design these walk throughs. I know I have a lot to learn as a teacher and plan to update these next year, but hang in there, go slow, and you can get through this. Let me know how I can help.

As are your positive comments! Grateful to have you here and happy to help!

Best advice I can give is TAKE YOUR TIME! Go slow and go back through when you're done. These aren't easy concepts to absorb for beginners.

@@RealisticResponse thanks man Great to see that you’re still replying to our comments even a year later Such a chad 🔥

@@AmitojSingh_2402 hahahaha This might be one of the top comments I received. I appreciate the people who make these videos worth doing; Sincerely. You all make me want to keep doing this and feel like, despite the struggle and commitment and fear of being in front of a camera talking to no one, that I'm making a difference. Appreciate you.

What'd you come up with?

Looking at yours, I'd say yours is more clever. I'm a fan. I have to go back through the course in 2025. I don't remember if they taught us "break" this early on and I do my best to use what they gave you each week. But excellent job! Keep up the good work!

Let me know if you still need help with this. was a bit behind. Hoping you got it sorted. Sorry for delay.

@@RealisticResponse hello! Yes i am still in need of help! I’ve been trying to figure it out, but still not able to get it right! 😭

@@vnzlb I need to know what the error is. I need the log.

Hang in there - DC down for now but I'll get a new link up in the coming weeks to help. for now post a more specific question what you're running into and I'll do my best to help.

I need help related to finance project please reply me 🙏

​@@RealisticResponseI need help related to finance project please reply me 🙏

How can we see the hole codes can you send us a link was been written in it

@@marlowsamuel4467 hi brother please help me i need your help

Since we're already in August, I'm waiting for the 2025 drop and plan to re-do the WHOLE course with better quality. I've improved my PC, My Mic, My Camera, all of it - hoping to do some better, deeper dives to help more people but THANK YOU for you're early support and comments!!!

I need help related to finance project please reply me 🙏

@@cricfever_30 hey, i could try helping! what’s the issue!

@@meera.srivastava bro send me your instgram I'd there we discuss, because I continue to get an error that's a reason. Please reply

@@cricfever_30 how can i help?