 Hello, hello, hello, hello. All right, guys, you can see my screen and that's okay with me because something terrible happened. And I'm not happy about it, but it did. I, just wait, let me make sure, check to make sure this is working, works perfect. Now, this is the live stream you guys are gonna be watching me in just a second. I'm gonna switch over here. This morning, I wake up and my internet is gone. The internet at my house is no longer working, and I have to pull an audible. I have to either cancel the live stream and wait for someone to come out and service my home to get my internet back up and working, or I can go up to my dad's school, which I am at now, and I can do a really improvised setup where I brought my microphone and a webcam. So normally I have my nice background. I have, I got all this stuff ready and going. Not today, not today. So we're going with the flow here and I really hope you're okay with that because I'm okay with it. Now, I'm gonna come down here real quick. I usually have two computers and I got all this stuff going, not today, but I'm gonna be chat with you guys in here. And I, genuinely, this whole live stream is just to really show off the platform. We've been working insanely hard. And when I say we, you know, I work with a team called Wavesync. They are amazing. Kasun, he's here in the chat. He's been with me since day one. He was the one who helped kind of create all this. And then of course his team as well. And so we have like a lot of people who have worked on this over the past year. And then we had the beta launch and we had like 6,000 people sign up, which was just insane. And now we are here. We've created a lot of new things. We've fixed all the bugs. We fixed all the things. And now we're doing our full launch and it just feels like time has passed way too quickly. And so I'm super, super, super excited to show off the platform to you guys. I over here, I create a new account and I bought the Lifetime Bundle, right? And by the way, you guys can get a 20% discount off of everything. So you can get all five courses and get 20% off, which comes like $99, which comes out like 20 bucks a course. I just, I'm really, really, really excited for you guys to try it out, for you guys to test it out. And it's 20% off everything, not just one item. So if you wanna get one of these, use the code in the checkout, AB Live 23, that's Analyst Builder Live 23, right? You can get all the courses as well for 20% off. So I'm going to be showing you, I'm gonna come back here, but I'm gonna be showing you the platform. And honestly, it is everything I had hoped it was going to be and more. And we have so many plans for even the next like two months. I've already recorded more courses, they're being edited. I'm recording more courses now, believe it or not. And they're just gonna be added on more and more and more to the platform as it goes. And so if you get something like the Lifetime Bundle, like a lot of people have gotten. If you get that, any course that I release, you're gonna have instant access to and you can start taking it, you never have to pay for a course or the questions ever again. Now, what I'm gonna do is I see a lot of people in the chat, really appreciate you guys coming. Someone's asking if we can have new payment methods. Yes, we plan on doing that in the future, but it is a little bit more complicated than just adding it on the end to when you pay. But we do plan on adding that stuff in the future. Now, now that we have people here, we have people watching and you can hear me, which is good, because again, this is an impromptu setup. I'm gonna show off the platform a little bit. And I'm going to, and my wife texted me, let me make sure she, I saw her in the chat. Actually, my wife is in the chat over here. There she is, there's Christine. So I'm glad you guys can hear me. Yeah, if you already purchased stuff, if you were part of the beta launch and you already purchased things, you're gonna have access to everything. You just gotta have a slightly discounted price because you were beta testing and there were bugs, right? We fixed a lot of bugs, login issues and coding issues and stuff like that. But now it's like all working amazingly. So what I'm gonna do is I'm gonna kind of show off the platform a little bit and then I'm going to, and this is gonna be a long live stream. Can I just be honest with you guys, this could be several hours. But one of the things that I really want to do while we're here is I am going to try to earn some of these achievements either by, I think I'm gonna start with MySQL, but I'm gonna get crazy with it and do some Python. I'm gonna show you how you can earn these badges, which they aren't showing because I just created, this is like a fresh, brand new account, never been touched. And so what I'm gonna do is I'm gonna show you the platform for what it is and then show you how you can use it to help you learn because this is in essence a learning platform, right? But it's not like every other platform that you took that you've used in the past. And that's what I'm super proud of is that it's unique. It's super well made. And all the content was created by myself. So if you like my content on YouTube, you are going to love this platform. And again, we have tons of stuff coming and I'll talk about that later because this is a long live stream. Take a round for it, just hang out with me. This is a long, long, long live stream and I'll be doing giveaways later and all those different stuff. But I'll just kind of talk about like the future of the platform and where we're gonna be taking it in just even a couple months or just by the end of next year, which again is early for a platform. And just to like give you some perspective, one's like, other platforms like Data Camp or Data Quest, they've been around for six, seven years. We've been around for two months. And so we have ideas that no other platform has. And so I'm really, really, really excited to kind of share these thoughts and dreams with you. And I hope you stick around for it. So let's show off the platform really quick. Again, I just went in here, I created an account, you can just go click login or register, create an account, your profile look exactly like this. The only difference being, if you just create an account is you have to purchase something for some of the things. I'll show you the free stuff. But once you purchase something, if you don't like it, ask for a refund, I won't be hurt. If you don't like what the product that we have, won't hurt my feelings. Now, this is the questions page. These are our technical questions. Now, essentially what this is and the reason why I created it, exactly how we created it is when I was first starting out as a data analyst, I had something called a technical interview. And if you don't know what that is, you go in for an interview as a data analyst and they ask you all these generic questions, tell us about yourself, why do you want this position? Then last more pointed questions, what do you know about SQL? What do you know about these different things? And then they may even give you, I probably got these around 75%, 80% of the data analyst interviews that I got, they'd give you some type of test, a technical interview. And I was horrible at first, I failed many of them, but once I started getting hands on experience, I was like, oh geez, I really should have practiced for this. And I don't want you to be in the same place that I was. And that's what this is for. Now, if you come in here right now, you don't have to purchase a thing. But if you come in here right now, you can go to this free section and you can click done. And I'm gonna start with these in a little bit. I'll actually start taking some of these. Shoot, just kick this whole stinking mic. I'm gonna show you how it works and why it is so helpful for these technical interviews. Because genuinely, this is probably the best layout setup for learning for technical interviews of anything I've used. And I've used a lot of different platforms. I just love it. So many people have given feedback that it's super addictive and really, really fun and it's really helpful to learn. So I'm gonna show you this in a little bit. But this is the question section where you can learn. Now I'm gonna really quickly, I'm gonna go over here. The refund is for seven days. We have a seven day refund policy. So if you try it out for a week, you don't like it, you can get a refund. Looking at the chat real quick. I usually have a whole separate computer for this. So you guys are getting like what I see on the backend. But no, it's not free reshoot. There is a free section of it. But listen, the whole thing is is I make free content on YouTube for free for hundreds of thousands of people. This is for people who wanna go a little bit further, right? I have my whole free boot camp on YouTube, which I think is just, it's free. You should take it 100%. But then if you wanna dive deeper in, you're also wanting to practice for your technical interviews, which I can't really do that on YouTube. This is where you can do it. And of course I have a whole team who works on this and I pay for all the hosting for this entire website, which is not cheap. And so unfortunately I cannot make it free. But it is genuinely one of the best deals out there. Like if you go to other platforms, for example, you go to Coursera, which I love Coursera. You go to Coursera, one, they don't have anything like this. This is unique for a lot of learning platforms. But if you try to take courses or anything on Coursera, you have to pay a yearly fee of like $2.99, whereas you can get the bundle, which is all courses and questions for life for $349. So just to put it in perspective, it genuinely is, I'm not trying to, this is not me just like throwing out things and trying to get money, money, money. I really do see this as a huge value for you guys. And I priced it as such. I could have priced it and I've seen a lot of other YouTubers do this where they price their courses at like $100 per course, $200 per course, and it gets like insane. And I really value your guys' budgets. And I remember where I was when I first started out. So I tried to put everything into like, where was I like five years ago or six years ago when I was first starting out? This is what I think is very, the value is really there. So I'll go back and forth between the chat. I'll try to answer some questions throughout, but I'm just kind of showing you the platform real quick. I mean, this is a long live show. I'm gonna get into everything. I will show you every single part of this website. But then we like, if we go into a course, this is what it looks like. You can come in here, you can check it out. And what I can do is I can come over here and this is the actual course. Now what's really unique about this course, now I haven't, this is a new account, so I haven't gone through this, but as you're going through, there are things like this, which is a queue, that is a question. So you're gonna come in here, you're gonna learn about variables, and there's all sorts of extra materials and stuff, and you're gonna learn all about variables, I'll teach you how to use it. And then you're gonna come over here, and there's an actual question built in, and you're gonna have to then answer that question on variables. So there's a built-in IDE, and then we can, you can kind of practice it. Now this one's a funny one. This is, I don't know, this is my sense of humor, but you're gonna create a variable, and then you're gonna try to use the index off of it to pull something, or you're going to create a variable called love and assign a value to it. So you're just learning about variables and you have these fun little prompts throughout. Now we also have full projects, and this one is actually on my YouTube channel, but I have a lot of others that are unique as well. So some of these automated web scraping and using regular expression, these are unique that are not on YouTube, right? And then all of these things go much more in depth than my YouTube stuff. Now, I didn't do that intentionally. I created the Python stuff way before I even thought about creating a course. It's just, YouTube is a platform of attention, so if I made as long of stuff as I did, most people wouldn't watch it. So I tried to make shorter videos that kind of got to the heart of it, but in these I go a lot more in depth. And so let's come back here. Now, I'm just quickly gonna show you the pricing. The questions, if you go to this questions tab, it's only for this questions tab. So you can get the monthly, yearly, or the lifetime just for the questions tab. And I've already added new questions to the questions tab just a couple of days ago. There's fresh questions. I'll be releasing more every single month. Then we have courses. You can buy individual courses if you just are interested in learning pandas for data analysis, which I need to go update that because I have two projects. I didn't update that. But this pandas course is probably the best pandas course I've ever seen. I've taken a lot of pandas courses because I used it in my job, but as someone who's used it in the job, there were a lot of things that I think I thought other courses were missing and I added those. And then the projects are the best projects I've ever created, genuinely. So if you haven't taken pandas and you wanna learn how to use Python for data analysis or use that Python library, or pandas library, take it. All these things, by the way, are 20% off. You can just go use that code at the checkout. But you can check out all these things. And then of course, we have bundles, which include multiple things. So this is gonna include all five courses, and then the lifetime is gonna include all the current courses and access to the questions page or the technical questions for life. And all the questions that I add in the future, all the courses that I add in the future, which I'll talk about what I have planned in a little bit, you're gonna get all that. Now, Christine, if you were watching, that's my wife, if you're watching, if at any point something is, my audio goes out or anything, you just shoot me a text. I know she's listening. She cares about me. So with that being said, I'm gonna do some, I'm gonna actually, I'm gonna check out, I'm gonna check out the comments. I'll answer some questions and I'm gonna do some coding because I wanna show you how to use it. How will I pick the giveaway winner? People who are in the chat, I read the chat, I'll pick someone out of the chat. How is it different than other platforms? Well, okay, take something like Maven Analytics, Udemy, Coursera. It's just video. It's only videos. And really the whole point is what I was trying to do with these courses and the reason I didn't put my stuff on Udemy is because I wanted it to be more interactive. I didn't just want it to be courses. And I could have done that. I could have just put them on Udemy. I didn't have to build this platform and I could have sold courses. But I wanted it to be more interactive. So then I added the questions part that's added into it and it just adds a whole nother level to it. It's so much fun. I really like that. Oh, geez, my image is frozen. That's okay. If it's not working, it'll hopefully work. But that is why it's different. But then also the technical questions part of it. So you can go to the questions and practice for your technical interviews. Again, not every, there's no platform that has both of these things. We are the only platform that has both the technical question coding and the courses in one place. And we're gonna be adding a ton of stuff. This is just the beginning. Images frozen. Yeah, if it's, the code to get the 20% off is gonna be active for one week. Then we'll take some time off. I'll be adding another course in just a few weeks to the platform. Then it'll just be regular prices. But then we'll do a new year's launch, a new year's code. So I'll have that for the new years. For people who are wanting to invest in their data analytics journey, we'll have that in the new year. Just about the lifetime, thank you. I'm super glad to hear that. I really, really hope you like it. Someone said, Damon said, Damon said, thank you for not putting your course on you to be. You're welcome, Damon. And how's it going? Hope you're doing all right. I've known Damon for a long time. Really good guy. Will there be additional Python courses aside from pandas? Yes. There will be other Python courses. But there's the Python for beginners course, which is awful, like from beginning to like intermediate slash advanced in just learning what Python and how to use it. Fantastic course. I'm super, super, super proud of that. Then there's the pandas course, which is specifically for data analysts, right? But yes, I have other courses planned for Python. Yeah, yeah. Yeah, no, exactly. So a lot of courses will just like, they're really similar. They're, you know, they'll just give you like a PDF for the docs, et cetera, et cetera. I think mine is a lot more interactive. And if you like my stuff on YouTube, you are going to love the stuff on Analyst Builder. One other thing I didn't even show you guys. I didn't even go into this. I'll answer more questions in a little bit. I'm going to go into this because I want to show you what this looks like because again, I, a year ago, when I met with Kasun to start talking about how to build this, I didn't, I had some type of idea, but over the course of the year we built it, it just changed and got better and better and better and better and better. And so I'm going to choose a super easy one. I want to look good on camera, but I'll actually get up. Let me show you real quick. There are easy ones. There are moderate ones. These are ones that I would start taking for entry level data analyst positions in real technical interviews. So, and I conducted technical interviews for three years. In real technical interviews that you are going to get if you're applying for data analyst roles. You easy and moderate are the ones that you should be practicing and really know how to do everything in these questions. It's joins, group by, using distinct like statements, all sorts of things. And all of these questions are unique. And then there's hard. Now, hard ones are pretty difficult. These are like what I've seen when I was interviewing for senior level roles. And then there's very hard ones. Now, these very hard ones are very hard. I would consider them extremely hard for, they're not under the free. I would consider these extremely hard and you probably won't get questions this difficult in technical interviews, but they're really fun. And I created them more for like a challenge. It's more of a challenge than really prepping. So if you can solve these, and I've had a lot of people in the beta who were taking these and solving them, they were like, this was really hard. I myself, when I was creating these questions, they were very difficult. I could not solve them because I was trying to see if I could solve it with chat GBT. I could not solve these questions with chat GBT. It was too difficult. Even with multiple prompting given all the details, I couldn't do it. These are more like what I would consider probably more lifelike, like things that you'll encounter in the real world in real work. So like easy, moderate, hard or really simple queries, you know, the hard's not super simple, but easy, moderate or fairly simple queries that you'll encounter in technical interviews are pretty basic for entry level data analyst positions. Those are things that you should be able to do all the time in an entry level role. Hard is like, you know, you've been in the game for a little bit, you've had a job for a little while. Very hard is if you can solve these, these are like real things that I've worked on in my real job, but they're much more difficult than when you'll see in a technical interview. So let me see how I look up here. My thing's still frozen. Okay, that's unfortunate. I'm going to, here's what I'm gonna do. I'm gonna come over here and I'm going to, let me activate it again. There we go. Don't worry about that guys. It's not gonna ruin my day. This is all impromptu. But let's come in here and I'm gonna show you what it looks like to solve a question. Now you can come in here right now, go to the free. I think there's 25, there's a lot of questions. There's like, there's a second page even. Oh, okay, there we go. I think there's 25 or 26 questions that you can do for free just to try it out, see if you like it. And you earn points from this. So I was trying to show you this earlier, but in this profile, you'll earn points from these and we're gonna enhance upon this. There's gonna be a leaderboard over here for different like MySQL or Python and you can get on the leaderboard, which is gonna be really fun. But let's come down here. Let's choose this chocolate question. So when you come into this question, this is our built-in IDE. Now what we have over here is, these are easy questions. So these are the in terms of difficulty, this is an easy, right? But you come in here and we have the question. You can get hints if you need a hint. You can also look at what your answer should look like in the expected output. And because we're in Python, you need to have it in a data frame. But if we come over here, if we change it to MySQL, now you wanna have it in a table as the output, right? So that's just kind of how it looks. But then we have this bakery items and this is our table over here. So we have a table and it looks like this is just a text data type. And we have all these different products and I personally love chocolate and it says, the question even says, this is just from my perspective, I love chocolate and only want delicious baked goods that have chocolate in them. Write a query to return bakery items that contain the word chocolate. Now I'm gonna do this in SQL really quick and then I'm gonna kind of show you some of the other things in here because every single question, this is another thing that I think is really, really unique about Analyst Builder and you don't get this on other platforms that do something like this. That there's video explanations for every single question from me. And what I think that really does it really helps you understand more in depth. Other ones will just have like a text explanation but you can't really replicate it and it's kind of confusing, that's what I found. I always wanted people to do video and nobody did it. So I was like, I'm gonna do that. I wanna do that. So we have a video explanation that will go through this entire question and give it a second. I'm on like not great wifi cause I'm not at home but it is gonna walk through the entire question for you and kind of describe it. So if you can't figure it out, that's how you do it. Now I'm gonna solve this really quick because it's an easy question so I'll kind of go through this one but we just need to return bakery items that contain the word chocolate. So I'm gonna say select everything and I could say just the name but the whole table is everything but I'm gonna select everything from bakery items. Where and then I need to say, let me paste that real quick but I need to take the column name where product name is equal to, actually no, I need to do like is like and it just has to have the word chocolate in it. Now I'm not saying equal to because if you look in here, nothing is just chocolate but some start with chocolate and then some say double chocolate donut, right? So we just need to search for the word chocolate. Let's run it. And one other thing and this is just a side note. Our processing times and this is just like kind of me nerding out our processing times for running the code here is faster than any other platform probably in the world. It is insanely fast. Other platforms for even a simple query like this it's like two, three seconds. Ours is insanely slow and that's completely from our engineering side. Kasun, well Kasun built all this really the back end of it. So mostly to him but also part of the team insanely difficult to get it to this level. A lot, a lot, a lot of work went into this. So here's our output and it just says write a query. So that's all we have to do. So now what we can do, now that this looks like the right answer we can even compare it. This looks exactly the same. This looks like the right answer. So all we have to do now is check our answers. So let's go ahead and check it. And you can also do shift enter, I think it is. Yeah, control enter, control shift enter. And this is control enter. So you can use hotkeys as well to run it just like in an actual ID. But it says down here your solution is correct. So now that we got that solution correct I'm gonna show you some of the other things real quick. You can go to your submission and you can see, okay today I ran it and I got the right answer. It was very, very fast. I just wanted to point that out, that was super cool. But you can also take a look at your actual code so it saves your code for you. And if you want to, if you want to replicate this you can always come in here and you can copy it and then you can, you know, paste it if you wanna do that. My wife's texted me. Let me see if anything's going wrong. No, everything's fine. She's out of the grocery store. That's all she had to say. But then you'll show your percentages. Now what's really, really, really cool about this is you can't, you don't just have to practice in one variation. Answers are gonna be different in Microsoft SQL Server sometimes or PostgreSQL or MySQL or Python. So if you have an interview coming up and this happened all the time to me is I practiced everything in MySQL but in the actual job that I was applying for they use Microsoft SQL Server. I didn't know the difference way back in the day but there are different variations of SQL. So if you have an interview coming up in MySQL you come over to MySQL and you can learn certain syntaxes and different things specific to MySQL. And then of course if you have a Python interview coming up or you're just wanting to practice you can come in here and it automatically is gonna set this up for you where you import pandas and it, you know, reads in the initial one or the initial head of the code. So the first five I think is maybe it's the first 10 by default I can't remember off the top of my head. But this is how it works. And this is a super easy question. Let me get some water real quick. This is a super easy question. Well, I don't wanna say super easy. It's an easy question. But I'm gonna show you some moderate and some hard ones in a little bit that I would consider quite difficult. But the other part to this is we have our submission. If you want to look at the solution you can come in and do that, right? So you can come in here. I can say, okay, I don't know how to solve this. Let me just look at the answer and there's the answer. And maybe that gives you everything you need. Maybe you're like, okay, that's exactly what I was looking for. That's exactly what I wanted. Now I know how to solve it. But if not, then you can go over to the video explanation and you can have me walk through the entire solution with you. Oftentimes what I do is I break it down very systematically. I'm like, here's what it's asking. Here's exactly what we need to do. Here are the steps. Now we could also do this or we could do this. And I give a lot of what I think is really good insight into how these questions go. Now for the easy ones I don't add a ton of insight but when it starts getting to the moderate and the hard questions where it gets a little bit more challenging I add a lot of extra information that I think is really, really helpful. And I do that in the courses too which I think is really useful. Let me take a look. Beautiful ID looks, I completely agree. The design team did an incredible job. And H said, what's the difference between purchasing the course and doing the monthly plan? Can we still do courses and all the questions with the monthly plan? So I'll come over here real quick. The monthly, I don't right now have a complete monthly subscription for the entire course. Like it's almost like this but on monthly installments. I'm going to do that. Multiple people have said that it's just on the back end it takes a little bit of work and setting it up with all the things that we have on the back end. So I have to set it up. But I do plan on doing that. In this questions, this only pertains to questions. Just the questions tab. So if you're practicing just for a technical interview you don't wanna buy courses, you don't wanna buy a bundle. You can just pay $15 a month with a 20% discount. So be sure to grab that if you're gonna buy something. But it does not give you access to the courses. The courses are just a one-time purchase. Now why did I do this? Something that I personally really hated when I was first starting out is I started out on different platforms. And some of them, not all, but some of them had a monthly subscription and only monthly subscription. So I took a course, I really liked the course and I wanted to go back later. I had to then purchase another subscription just to access the course again. And I didn't like that. And I didn't wanna do that for you guys. I just wanted it to be almost like a Udemy style, right? Where you can just buy it once and have it forever. So you don't have to, you can just buy this Advanced MySQL for a data analysis course, $24. You can just buy it and you'll never have to pay for it again. You can take it a hundred times. Keep referencing it back to you. You get into a job. You're like, oh, I remember learning about indexing in this Advanced MySQL course, but I don't remember exactly how to do it. And so you can reference it whenever. Same thing with the bundles. You get these forever. You buy these courses, you get all these forever. It's just a one-time purchase. I personally feel it makes me feel better. Excuse me, it makes me feel better because when I was first starting out, I didn't have a lot of money. So free resources were pretty rare back in the day before I had my whole YouTube channel set up. They weren't as good or they were a little bit more rare. And so I had to purchase a lot of subscriptions. I just didn't like it. It was like $40 bucks a month or whatever. But I think I'm gonna try to price, when I do set it up, maybe for like next year or sometime, trying to make it pretty affordable because I want people to use it. I want people to be able to learn from it because honestly, everything on here is just, if everyone took it, you guys would be like, this is super, super, super helpful. This is like a really great resource. And so I'm just gonna take a tiny break to talk to you a little bit about, now that I've shown you it, and I'm gonna do more questions in just a sec. Some of the things are gonna be adding soon. And actually, let me go over to the profile. I just earned some points. I answered an easy question, I got 10 points. And now I'm working towards earning a badge for my sequel. In this livestream, which I'm gonna do this for a while, it's only 9.50 my time, I'm gonna try to work my way up to like intermediate, but it takes like thousands of points to get to a master level of my sequel. I think it's 3,500 points. Now you can earn, if you take a full course, you earn 500 points. If you take a crash course in my sequel, for example, you earn 250 points. And then the like super difficult questions. Oh, it says I joined a year ago, I just created this account. But if you do like moderate questions, you earn 25 points, hard is 75 points, and then very hard is 100 points. But some of the things we have planned is we, you know, we have this point system. On the back end, we can see how many points you have. So we have all the data. We're gonna build a dashboard to kind of in each skills. So like with Python and with my sequel, post-grade sequel, we'll have a leaderboard that you can like try to get on to the leaderboard. There's gonna be a whole other section, and this will be early next year, a whole other section for resumes, for excuse me, for cover letters for different communities you can join. And that'll be completely free. You don't have to pay for that. But you'll have access to all these different things. We also are gonna integrate some AI into the platform. We're already looking into it now. We're just gonna be really, I think, more lifelike in the sense for like a real-world job. Now for technical interviews and for learning the courses, I don't think you should be using a ton of AI, in my opinion, because it's kind of like a crutch. You kind of lean into it too much, and it's harder for you to really learn it as in depth, I think. And then in technical interviews, they're most likely not gonna let you use like Chachi to your bar or anything. And so learning without it. But we'll have an option where you can use it, because I think in a real job, especially in like, I'm gonna say like a year or two, there's gonna be a lot of solutions that a lot of companies will have where they'll be kind of baked in, like a product baked in with AI. So that's something I want you guys to be able to use and learn and start using so that you can get kind of comfortable with it. So when you do get a job, then it all looks really good. So that's just like super simple stuff that we're coming, not simple, but some of the very few things that we're coming out with. I have a list of like 15 different things, and next year is like our year of growth. In 2024, we're gonna be launching so many new features, and it's gonna be just an entirely different platform than it is now. Like this is the core functionality. This is like what I say as our MVP, our minimum viable product. But next year, we're adding more courses, more questions, more features. This is gonna be, in my opinion, the best place for data analysts to learn almost anything. And then courses, by the way. So right now, I have five courses. I already have the Excel for data analysis. It's already fully recorded, it's being edited. That'll be probably early next month when it's available. Right now, I'm recording the tableau. Once that's recorded, we'll start creating roadmaps for people. So right now, they're just courses, they're just sitting here, but I'll have a whole roadmaps section that'll kind of take you along the path. Here's what course you should learn. Then practice, learn these questions and use this resume. And so it'll be a whole roadmap. Similar to kind of like the data analyst bootcamp, it's kind of this roadmap. I created it very intentionally in design on YouTube. Let me see if you can still see me. Yeah, you can. I created it very intentionally, but this is what I would consider much more professional, much more advanced. Let me answer a few more questions and I'm gonna go back to the platform real quick. If you guys are just now joining, my internet went out at home and I had to go, I had to play, I had to do, I had to do an audible. I just had to. I couldn't be at home, my internet was out. So I came up to my dad's school where he runs and I'm sitting in like an empty room. That's what I'm doing, but I'm doing it for you guys. R is definitely gonna be coming, absolutely, but probably later next year. And the, yes, so is the Analyst Builder more in-depth version of your bootcamp? The answer is yes. My bootcamp, this was never the intention of, my YouTube channel was never meant to be, how do I describe this? I didn't know I was gonna be creating courses or Analyst Builder ever. So when I created my bootcamp, I created them as like a YouTube video, trying to keep them somewhat short, not going crazy in depth, but getting the meat and potatoes. The courses on Analyst Builder, I would say go about 50% more in-depth and the projects in them are better because I spent a lot more time on them. And you have the integrated questions in the courses. And so all that combined, all that combined is just a much better experience, much better, you're gonna learn a lot more in-depth and I give a lot more of my thought process on how I use it, how these things work, how they all work together. And it's just, it is a lot more in-depth. Am I playing on a data science roadmap? Potentially in the future, I'm looking at potentially partnering with one or two people for doing like a side data engineering, side data science, but the core part of this website is focused on data analytics. Just to put that out there. But yeah, a lot of stuff coming. I'm just looking. All right, I'm gonna go back real quick. So you can go to these technical questions and once you get it right, you have this check mark here and I just went back into it, whoops. So you have this check mark here and what we're gonna do is I am going to, let me go to my profile. By the way, this right here is a public URL. So you can actually share this with people. If you wanna share this on the internet, you can. When as you earn points and badges, these badges right now, once I earn it in just a little bit is not shareable, but it's gonna be shareable in a little bit. And then when you complete a course, you can generate a certificate of completion, you can share that as well. This is gonna be like a hub for everything you do on Analyst Builder. And we're also gonna have a place where you can upload your resume or upload a portfolio. So if you do want to share this with friends or you wanna put it on LinkedIn or whatever, that it's kind of like just, I think it's a really cool place to just share your, to share your progress with people, right? You're learning, you're working on all these things and you can kind of make this into like a pseudo portfolio although I still recommend building an entire portfolio website. But let me go back here real quick. Are you planning to put Excel and data visualizations courses on the platform? I already recorded the Excel for data analysis, it's being edited by my editor right now. That's gonna be ready soon. So probably just like a couple of weeks. And then I'm recording the Tableau course right now. Again, much more in depth than what's on my YouTube channel. Although the stuff on my YouTube channel is fantastic, I'd recommend taking it. That's what I recommend. Now, let's come back here. I'm gonna do another question. I wanna do a little bit more difficult one. Now this is still in the free. So remember, you can go and take this for free right now. You can do this with me while you're listening to me. Let's do, let me see, which one do I think is interesting? This one, that one is interesting. Let me do this one. I'm gonna see what question this is. This is company-wide increase. So if your company hits its yearly targets, every employee receives a salary increase depending on what level you are in the company. Give each employee who is level one a 10% increase, level two, 15, and level three a 200% increase. Okay, I'm remembering this question. Include this new column in your output as new salary along with your other columns. This one tricked a lot of people. I didn't intentionally wanna make it tricky. It's just tricky when you're working with percentages. It's a little bit tricky. This question, you should go take it right now. I'm gonna post this question really quick, really quick, right here. So I'm gonna work through this question. This question's a little bit tricky. And I wanna get that MySQL badge, so I'm gonna do some MySQL first and I'll switch over to Python later. But let's see how this works. So we have this table down here. It just has three columns that are all integers. And it's the same thing, so I'm not gonna take up that preview, but essentially what we're doing is we have different employee IDs. This is me, this is you, this is our friend, John. And there are different pay levels. So maybe that they're tier one, tier two, or tier three even, who's making 300,000. And each of these people get a bonus. We had a really, really good year, it looks like. So now we need to give bonuses, let's see, a salary increase, depending on what level you are in the company. So some people are gonna get a 10% increase, 15% increase, 200% increase, and we need to calculate what their new salary is going to be along with all these other columns. Now, when we were doing the beta, I had a ton of people think that this, the answer to this was wrong. They're like, this is not correct. You messed up. I'm not calling out anyone else. I'm glad they were, that's what the beta was for, was for people to correct me if I was wrong, to give feedback. But a lot of people thought I was wrong on this one and I had to like really walk people through. I was like, well, here's why, and here's the exact math behind why this is correct. And a lot of people like really challenged me on it. And I always thought that was really funny. So I'm gonna move this over for no other reason than I just wanna show it off. You can move this around, customize it. One thing I wanna mention, you can do all this on your phone. It is not an app, but if you just go on analystbuilder.com, you can do this on your phone, which again is something super unique and something I'm gonna start promoting later on, or maybe later this week. One thing I looked for when I was first starting learning coding, my SQL set, I wanted an app or something that I could do on my phone. I never could, I had to all do it on my desktop. You can do this exact question on your phone right now. That blew my mind when we started building this out that we had that ability, because I don't think any other, no other website that I know can do that. I mean, it works, it's not like a bad experience. It's like, you just have to scroll up, look at the question, scroll down, you can code. So you can do all of this coding and practicing like on your way to, no, do it on your way to work while you're driving. You could, if you're on a bus or on a plane, you have Wi-Fi, you can do this on your phone whenever you're just hanging out at home on your couch. You can just do it on your phone. I think that is so cool. Really, really, really neat and again, super unique. Not a lot of platforms that have these built-in IDEs, you can do that. And so we were able to make that happen. Now I'm gonna try and answer this real quick because I need some points. I'm trying to get that first badge, but I'm gonna take a sip of water. I'm gonna drink this whole thing by the end of the stream. All right, let's see. I'm getting a phone call, but I'm ignoring it. I don't know who that person is. Let's see here. So no, wait a second, we don't need to do that. What we need to do is we need to have some if then logic. If they're level one, give them a 10% increase. If they're level two, give them a 15% increase. So we need a case statement. Now it says, include this new column in your output as a new salary. So we don't wanna get rid of these columns. We need all these columns, but we just need a new one. So I'm gonna do a comma here and I'm gonna do a case statement. Now just so you know, we also have built-in, I wanna say it's, what is the, what is it called? It's like autocomplete, essentially. So I wrote in case and it's like, okay, well do you wanna do coalesce? Or are you trying to do a char set, cascaded? These are different things that you can get with like built-in IDEs. And so just kind of like a little bit of autocomplete, which is really neat. So let's do case. Now what we're gonna do is we're gonna come down here. We're gonna say when the pay level is equal to one. Then what's gonna happen? Now we just wanna give them a 10% increase. Now this is their new salary. So we don't just want to do salary times 0.1. That would be bad, that's a 10%, that's 10% of their salary, but we need a 10% increase. So we need to do times 1.1. And I'll just test this out real quick. We'll do end and we'll call as, and we need to name it correctly, okay? These questions are specific. So let's run this, here we go. So if you look right here, this person is a pay level one and they got a 10%. So 10% is gonna be 7,500, so 7,500 on top of that, a 2,500. But the ones that aren't level one didn't get an increase because it's not part of our logic. So what we need to do is we need to include the rest of our logic in here. And I'm gonna show you where people got it wrong and did not agree with me that I was correct, which is gonna be in a little bit and we'll see what you guys think. So when the pay level is equal to two, then we do salary and we'll do that times 1.15. So that's a 15% increase. The times one means that you're taking the original base salary and then you're also multiplying it times 0.15. So then they're adding 15% on top of the one, which is your original salary. So that's kind of how that's working. Now let's run this, okay? So now level two is taken care of. That guy got a big pay increase, 15%. I'd love a 15% increase, that'd be great. But it looks like we have one person. Now this is where a lot of people did not agree with me. And I had to kind of write out the math and I'll write out the math for you as well. And then I'll go back to the questions or I'll go back to look at comments and stuff. Now this next level is level three. There's only one person. So when they have a level three, we're supposed to give them a 200% increase. And what a lot of people were doing is they come over here and they do times two. And they'd run it and they'd come down here and they'd say, okay, they got a 200% increase, that was 300,000, now they're making 600,000, that's insane. And they tried to check the answer and they're like, why is this incorrect? Well it's incorrect because a 200% increase is not times two. A 200% increase is times three. And if I check this answer now, our solution is correct. Now why is it times three? You have to remember you have to include the base salary. So it's like doing salary times one, that's our base salary. But from that base salary, we have to increase it 200 times. So if I increase it 100 times, which is doubling, that's a 100% increase. So from 300,000 to 600,000, that's times two. That's a 100% increase in salary. So a 200% increase in salary is times three. So you have to include that. It's like doing the base salary and then doing it times two for 200%. It'd be the same like this. It'd be doing like times one times 0.15 or 0.15, right? Just visually. So you're doing the salary times one, taking the base salary and then you're adding, well it would actually be like this. Ignore my logic. Don't look at its ideas. So it's like doing this actually. Let me do parentheses here. This is actually probably more accurate. It's like doing the salary times one. So that's the base salary of 75,000. Then you're adding on top of it 0.15, which is 15%. So that's like visually how it would work. And so if you tried to do that for this one, you'd have to do it times two over here. So that's times two on top of the base salary. That's a 200% increase. That tricked a lot of people. A lot of people thought I was wrong on that. And then I had to like lay out the logic of it. So if you're in the chat right now and you were one of those people, I'm not mad at you. I'm not even disappointed or sad. It happens. Like these things are tricky. These are like some of those little, that one's just some math nuance, but in a lot of other questions, there's some other nuances that are just difficult to understand. If you haven't used these before, and that's why I have the video explanation because I go through all of those nuances. If you watch my video explanation, which I pointed a lot of people to when that was happening, I said, go watch the video because I talk about that exact thing in the video. But you can also see here that in this question, I got it wrong. Just I didn't math right, but then I got it correct. And I can always go back and I can see, how did I write that that was wrong? And how did I write it that was correct? Again, this is all for learning purposes, right? This is like one of the, it's just so fun to learn. Now, if you don't get it right, you can always come in here and you can look at this answer. And as you can tell, we already got the answer right. But if you can't figure it out, the answer is in here for every single one. And you know, I think that's really neat. Now, all these variations of SQL, for some of them, the easy and moderate, most of the answers are pretty similar. But when you get to hard questions and very hard, almost none of the answers are the same. Because then you have to start using a lot more built-in functions within MySQL or within Microsoft SQL Server, and they're different. So a lot of the date, time functions, a lot of things like coalesce or left and right, substring, et cetera, all of these things are different. And that's like the more advanced stuff that, you know, when I started getting into my jobs, I had to learn all the different variations. So I was using MySQL and I was using Microsoft SQL Server at the same company. And so I would have to switch back and forth depending on what data I was working with. So I had to really learn these. And so, you know, now that I got that answer right, I can go and I can go take a look. Now we're in 25 extra points. And you can just grind this out. You know, start with the easy questions, work your way up to the moderate. You can earn a badge, maybe two badges even, just from the free questions. So really highly recommend doing that. And we got that question right. Now, I'm gonna try a difficult one, either cake versus pie or temperature fluctuations in just a second, or Kelly's third purchase if we wanna get wild. These are all hard questions. I'm gonna show you like a more difficult one. I may even try one of the very hard ones, although I need, you know, those ones take some time. I don't know how long of a time I have. But let me come back in here. Let's see. The question is, in regards to the lifetime access, we'll have access to all the new programs where you'll be adding, for example, accelerated visualization, yes. If you buy the lifetime, you're gonna have all courses and questions current and anything I add in the future. So next year, I'm planning to release like six or seven more courses, right? I do, I have my consulting business, I have my YouTube stuff, I'm working on courses in every other spare moment I have. And I'm making them, they also take a little bit of time because I'm making them really in-depth and really well-made. Yes, AWS and Azure actually is gonna be really soon. Because I think cloud platforming is really important. So I'm getting the core courses that I wanted done. Python, SQL, Excel, Tableau. Once I have those done, which is early next year, I'm gonna be doing AWS, Azure, and then an AI course. Because I think those two things are kind of like the next trajectory of what you should be doing. So let's see. This is, again, these percentages always confuse people. 10% means it's 1.10, because you're taking one, which is the base salary, and adding 10% which is their new salary. So you have to do that. Let's see. Oh, I'm sorry, you're not feeling good. It's unfortunate to hear. So Holly said, that would never work in my brain with just a text explanation, huh? Yeah, exactly. That's why I like the video explanations. Amon Deep says he wants to do the cake versus pie. I think that's a fun one. I think that's a difficult one, too. I may have to use my own hints on these, because I haven't looked at this one in, I made this six months ago, and then put it in here, and then people started taking it. Let's do the cake versus pie. This is a difficult one. I remember making this, and I was like, whoa, this is tough. I'm like, this is a really tough one. But let's go through it. And this will earn me 100 points. I'll earn my first badge in my profile, which I'm really excited about. So let's look at this question. By the way, if you really like one of these questions, we have this button right here, and you can share this on LinkedIn, X or Twitter, and Facebook. So you can share that on a social media platform. I just think they're, let me tell you something. I genuinely find these so fun. Like, I genuinely get really excited to do these, and I think they're just so interesting. Now, and all the questions are very unique, and what's even better is I did these in my actual, like, when I was a hiring manager in data, when I was a manager of data analytics, and when I was just a data analyst, I was on a hiring team, I was the one performing these tests. And so I did the technical interviews for these people we were trying to hire, and I could always evaluate pretty quickly whether they knew what they were talking about or not. Like, you can just tell, especially if you really know something. I was like, this guy has no idea what he's talking about. And this is like what I would consider a moderate question. Something we were using group by, maybe a join. We didn't want to hire people who didn't know the skills that they had on their resume. That's why you perform technical interviews. Most of the technical interviews that I did were in SQL, and some were in Python. I thought my wife was texting me, but she was not. That's okay. That's okay. So let's try to do this hard question. This is a hard one. So now you're looking at, we did easy, we did moderate, and now we're gonna do a hard question. Then in a little bit, if I'm feeling really spicy, I might try a very hard question, which again, is gonna be very hard. Could take a long time to do, which is why I'm hesitant to do it. This one can still take a while, but let's see what it says. Marcy's bakery is having, let me drink some water first. Thank you. Marcy's bakery, excuse me, let me do this away from the mic. I was doing it right into the mic. You know, I apologize. Marcy's bakery is having a contest at her store, whichever dessert sells more each day will be on discount tomorrow. She needs to identify which dessert is selling more, and so we need to write a query to report the difference between the number of cakes and pies sold each day. Outputs should include the date sold, the difference between cakes and pies, and which one sold more. The difference should be a positive number. So if there's 20 pies, let's go look. This is one day, so this is six one and six one. So the pies sold more by 12. So we need to figure out which one sold more, and then we also have to determine whether it was the cake or the pie that sold more. This is a very tough question. And just even now, as I'm like thinking it, how I did this, and I solved, I wrote all of these, I solved all of these myself. I of course have a video explanation of how to do it. This is not an easy question. So let's see if my little noodle can work through this problem. And I want you to work through this one too. This is a free question. You can go and take this for free. I'm gonna say try this question with me. This is not an easy one. So this is gonna be a tough question. Let's see if I can figure this out because it's been a minute. All right, so we have to write a query to determine the difference. So the difference should be this number minus this number. Right, how can we do this? We can probably do this with a join where the date sold is equal and then we'll have these as two separate things. Would that work? That could definitely work. And I have to determine which one is higher. That to me sounds like a case statement. So if this one was higher on that day, then we return the product name. If this one was higher on this day, then we return the product name. Or something like that. If I fail, hey, listen, it's a learning platform. Right, you're here to learn. So go and try this out. This is a tough one. I'm trying to remember how to do this, honestly. And we even have hints here, but we're not gonna look at that yet. So let's think of how we need to do this. First, I'm gonna get my columns that we need. So we need to include the date sold. So I'll do date underscore sold. Then the next column is gonna be the difference between cakes and pies. So that's the one that we're gonna solve for next. And then we'll do which one sold more cake or pie. I think that's the toughest part of this question, at least in my head how it's working. So we're gonna solve this. So how do we determine the difference between cakes and pies, which needs to be a positive number? So first off, I'm just gonna make a note down here. We have to use absolute to make it a positive number. There we go. Now, the next thing that I think I'm gonna do is I think I'm gonna do, can I do a join to itself? I can, but I need to subtract this number from this number. How can I do that? I'm just thinking I could join it to itself. And if I have this number, I could say the amount sold minus, the amount sold of cakes minus the amount sold of pies. And since it's on the same row, it would work. At least that's where my head's going first. And there's a bunch of different ways you can solve this. Let me come back here real quick. Hey, Ryan, real quick while I'm over here, I was just seeing if anyone had any questions. But while I'm here, yeah, if you buy the lifetime access in the bundles, you will have access to any future courses I put out. And if I, Exactly, Nora, exactly. You'll get all future courses and all future questions. We won't have to purchase anything again. Now this Nora said, if you fail, I have no possibilities, I'll get it right. You know what? I don't agree with that. That's why I have the video explanation so that you can learn how to do it. And if I have to watch my own video explanation on how to do this, I'll do it. I'm not ashamed of that. This is a tough, this is a hard question. These are the types of things that you'll experience in like senior level roles. That's why I was recommending, and you can also use a filter here. That's why I was recommending people start out with easy. Start out with the easy questions, try them out for free right now. Then you can try out the moderate. Those are a little bit harder than the hard. Then there's very hard. And so, just something to take into consideration. Now I'm gonna use all the available resources that I have before I go to hints. I just wanna look at what the output looks like. And this is, I'm not considering this cheating. You should be able to see what it's supposed to look like. But we're gonna have the date. We'll have the difference here and then we'll have which sold more. And so this is what it should look like in the end. No, let's not do hints, whoops. But we have a date, text, and integer. Now let me think about how I wanna solve this because again, this is a little bit tricky. I'm trying to, I gotta do this number subtracted by this number. Now somebody in the comments had said use a lag function. Now I can't use a lag function unless I give these a row number. See again, there's a ton of different ways you can solve this. So if I add, if I did something like a CTE or maybe even a sub query, I can add a row number here. Then I can order it based off of the dates. So these would be one and two. And then I could use a lag function. That'd be possible. Not how I solved it originally, I know that. Or I could join it to itself, which I think is, it just makes the most sense where the product is not the same. And let's try that. Let's just see, let's just get wild with it. I think this is gonna be an inner join and we're gonna join it to itself. I need to label these different. So I'm gonna call this D1 and D2. And I'm gonna say on, and we're gonna do it on the date sold is equal to date sold. So D1.date underscore sold is equal to D2.date underscore sold. So we're doing a self join, but I also need to do it, I believe, we'll say and where the product does not equal the product. So this one is not gonna get joined to itself. Let's just, actually, let's do one thing. Let's run this and what's my error? What's my error here? Oh, I have a comma. Let me actually, let me put everything here. I'm just trying to demonstrate how hard these are. So we have the date sold, the amount sold. Now listen, we only have one column here, but in a second, we're gonna have to label it something differently to get the other column. So let's label these real quick. I'm gonna do D1 for our original table. So D1.mountsold, D1.product, and this is where our auto complete is helping us. So D1.mountsold, oh wait, this should be date, date sold. The next one that we're gonna do is comma, and we're gonna do D2.mountsold. Let's also run this, and I need to change this name. So I'm gonna say this amount underscore sold, and this will be T2, so table two. Okay, so right here, this is exactly like what we wanted, but you know what I should do as well? I should also add the product name. Let me go to D1. Let me do D1.mountsold, and then I'll do D2.product, and I'll label that as, and let me bring this down, so now it's getting complicated. So D1.product.mountsold, D2.product, I'll do this as product, and this will be underscore table two, table two. Let's run this, I need a comma, I need a comma here. So now here's an example of exactly what we were trying to do. So we have on one date, we have the pie, we have 18 cake and then six. That's exactly like what we were trying to do. My wife's calling me, so I'm gonna answer because I don't, we'll see what she says. Hey baby, I'm on the livestream. Oh no, it's not working. Yep, yep, my wife tried to use the wifi at home guys, and wasn't working. Yeah, it's still working, I'm checking it. Yeah, I love you, bye. My wife was concerned. She got home where the internet is not working, and the livestream stopped and she was like, oh Alex, it stopped working. You could use a sub query, absolutely. I mean, I'm not gonna show you because it's gonna take a long time. But if you haven't already, previously in the chat, I'm just gonna post it in there one more time because I want people to try this one. Maybe you can solve it for me. I'm solving this question. This is a hard question on annalsbuilder.com. We've already tried easy, which was pretty simple. We tried moderate, which wasn't crazy complicated. Now we're doing hard and it's quite a bit more difficult. You have to really think about this. Then the last thing I wanna do is I need to add another thing saying the product or d1.product is not equal to d2.product. So d1 is not equal to d2.product. And let's run this and let's see. Okay, so this is fine. I believe, let's see, because now we have two rows for each and that may be fine. That may be fine for now. Let's just keep it as fine. Now I'm gonna come down here and I'm gonna get our next part of our equation, the difference between cakes and pies. So let's come right here and all we need to say is the amount sold minus the amount sold or the amount sold table two, which is just from the different table. So let's do, or I can even do, I can filter where the product, this one is equal to cake because it'll always have one on the day there. It's equal to cake. That could be another way to filter it down. I'm gonna try it real quick. I'm just thinking of this while we go. So this will be d1.product is equal to cake. Let's just try this. What did I do wrong? Oh, isn't the wrong section. Is it in the wrong section? Oh, that wasn't wrong. This is wrong. Guys, I'm working through this. This is, you guys are getting a good glimpse of the real life of me as a data analyst. I make all these little tiny mistakes and then I figured out as I go. Okay, this looks really good to me. I don't know if I'll keep that there for now but it's good visually. So now we need to do is subtract these. So we're gonna say d1.product minus d2.up, yeah, d2.product. And we'll call this as and we'll say difference because that's what it had in the expected output. It doesn't have to be that but let's try it. Let's run it. And we got zero and let me see. Let me see what I'm doing wrong here. Okay, I'm sure it's because it's subtracting by itself which is not what we want. Let me see if I can do amounts. Oh, I'm doing the product. What am I even talking about? Guys, someone tell me that I'm looking like a fool here. Let's see. Unknown column d2 amount sold t2. Okay, that's because I just have the wrong column name. There we go. All right, guys. Listen, I am gonna be completely honest with you. This is like how I work in the real world. This is like how my life is and is around writing queries. But we're getting there. So now we just need to absolute because again, we have to have a positive number. What's the difference? So we're gonna do absolute. I think it's ABS. I don't think it's a full absolute or is it? Let's try it. I thought it was ABS. Oh, maybe it's because of this as differences in there. There we go. You guys are getting a great glimpse. This is wonderful. So we have the difference here, which is perfect. That's exactly like what we needed. So now it shows that there's a difference between the cake sold and the pie sold. So the difference is 12. One, the sold one more, the sold one more, the sold nine more. Then we have this one and we have null here. So I think if it's null, let me see, is this really null? Six, five. Oh, interesting. So one thing that we may have to do here because there isn't another sold. They only sold cakes on this day. They sold 16 cakes on this day. So it should be a difference of 16. They only sold more cakes. Let's see, they only sold 16. This is, this should be a zero. Let me think. This is pie, so they didn't sell any pie on this day. Oh, wait, wait, wait, wait. Let me go back to the original table. No, okay, okay, I got it. It's just null here. So if it's null, it should be a zero. So how can we do that? Give me a second. I'm gonna come back here for a second. See if anyone's giving me any suggestions. Look, you gotta work through these things. I really appreciate that, Mahanad. How do you say that? Mahanad, Zidane. Really, really appreciate that. Thank you. Kassun, you're so right. He said this is really cool. Hey, they know who you are. They know who you are. They know that you helped build this. Let's see. Two, two, two, maybe. Maybe a case statement. Let's see. Can you make a new video on the Google Advanced Data Analytics program? I started taking it and it was good. It was good. I didn't have time to finish it because I was working on this platform. Is understandable when you got distracted while the columns you literally have dozens of eyes looking at you? Yeah, just a few. You can resolve this in a case statement. And name of the column is not null? No, we need it as null. We need it as null. Thank you guys for helping solve this. I do need help with this. This is like half the fun of the platform is these hard questions and very hard questions. So yeah, maybe we could use a case statement. We can say if it's null, make it zero. Maybe. We need to make this. This needs to be a zero, I believe. Unless there's a function that could do that for us. All right, I'm gonna go to hints, guys. I'm getting, let's see. We need to subtract the cake by the pie for each day to determine the difference. We can use absolute to make the number show as absolute difference. Okay, thanks, Alex. Not super helpful. We can use conditional statement to determine which was sold more. If cake is greater than pie, then cake sold more. If not, then pie sold more. Okay, so that's for the last part. That's for which one sold more. So we can do a case statement. If cake is greater than pie, then the cake's sold more. If not, then the opposite. But we gotta determine this one right here. This one's boggling my noodle here. Maybe I could, yeah, maybe I could do a case statement like you were suggesting. Who suggested that? You can use a case statement for the difference output. Maybe. Maybe we could. This is a tough one. Hey, look, this is a hard question. I wrote this myself. If I maybe if I didn't have so many people watching me, I could solve it faster. But we're gonna solve it. I'm not worried about it because we're already halfway there, right? We just need to figure out how to make this a zero instead of null. So I do think a case statement could work. We'll just say for this one, the amount sold t2. We'll say case. Oh, here, I'll put it to a new row. Case. When the amount sold, and this will be the end, end as this. When the amount sold is null, is it is null? It's equal to null. I thought it is null. No, is nulls a function? Let me try equal to null. I don't think that's gonna work because that's a string and this is an empty. Look, it's all tested. If it's that, then zero. And they'll say else, it'll just be the amount sold. So if it's null, let's try this. If it doesn't work, it's okay. Let's run this. Yeah, it's still not there, but all these numbers are fine. So we're getting close. So I think is null, is null. I think it's like that. There we go, nailed it. So now we need to include, oh, interesting. I don't think we can do this because, okay. So we were able to get it to zero here. So maybe we can just use the same logic. We'll do another, okay. This is getting really convoluted. I am 100% sure I could do this in an easier way. But we're going to, we're gonna add it in here. So we're gonna say when it's, actually, yeah, I might just do this. I might copy the same thing. This is getting a bit much, but do as I say, not as I do. Because this is getting insane. All right, so when this is null, then we're gonna do this right here. Whoa, whoa, whoa, wait. No, no, no, that's the else. I'm just thinking this through. Minus zero. Here we go. And if not, then it's just gonna be regular. When it's null, no, no, sorry. When it's null, do this. And when it's not null, do this. And I think we can wrap that in an absolute. Let's try this syntax error. Let's see, let me just see if it works like this first. 16, let me see. Then d1 minus zero. This should be d1. d1.amount sold minus zero. Now why is it making this 16? Oh, I must have changed something. I must have changed something. And as amount sold t2. Let me get rid of this whole thing real quick because I think I'm messing this up. Let me run this. Yeah, okay. And then after that, I added this. Oh, I changed the column name. Let me do, let me change this column name to new. There we go. So now it doesn't mess up the original. And there we go. There we go, we fixed it, guys. So now we have the amount sold t2. Now I can get rid of the difference, or I'll change this to the difference. And I'll get rid of this one, except I need to make that absolute. That's the only thing I need to do. So let's run this. So now we have it. This is working, but we need to make this absolute. So I think I wrapped the whole thing in the case, the absolute in the case statement. Let's just try it. Let's run it. No, not that. Let me try doing that. Or maybe, no, you know what? I'll just do it at this level. So I'll do absolute right here. And then the same thing for here. Absolute. Why is no one in the chat telling me to do these things? Come on. You guys collectively are 10 times smarter than me. Okay, we are really doing this. We are destroying this. This is great. But, okay, in our output though, we have to have, this isn't our output. In our output though, we just need dates sold, the difference, which we have, dates sold, the difference, and then which one is higher. So that's the last thing we need, and then we'll be done. And I can get off of this question because I'm looking like a fool over here. We're gonna do the last one. And let's look at that hint again. So as we can use a conditional statement to determine which was more for each day. Okay, let's just try that. I gave myself this own hint. Remember how to do this? And I shall use it. And I won't feel bad about it. When the amount sold, so d1.amount sold is greater than d2.amount sold, so when this one, which is cake, is greater than this one, that means that the cake, so we're gonna do then it should be cake. Else it's gonna be pi. Now we could write something to account if it was a tie, but in our data there is no tie, but if there was a tie we could write tie, but I'm not gonna do that because I've already spent way too much time on this. And I'm gonna end this, what am I gonna call this? Sold more, let's try this. As sold more, let's put that like that. Now let's try this, let's see if it worked. Over here, did pi sell more? Pi sold more, pi sold more. Oh, we are doing this, cake sold more. Oh buddy, we are in it. Then return the result table ordered by date. Guys, if you guys are not, I'm not looking at the chat, but you guys are not in the chat, it's literally celebrating what I'm doing right here. I'm overcoming extreme adversity of my own doing. Now all we have to do, I say all we have to do, but let's see if it works. All we have to do now is only sell, oh geez, this may not work. I may have to use this as a subquery as like a CTE. Okay, I'm creating, I think I have to. I don't think, because if I start removing some of these things, I can't get the desired output. So I think I'm gonna use a CTE here. So we'll do CTE with CTE. With CTE, we just need to name it. I'll just do pies versus cakes, pies versus cakes. And then what's the syntax for a CTE as? With, oh no, that's the name. So with this as, and I think I wrap this in it, and then I can query from it. So I'll do select everything from pies versus cakes. Guys, I am really working hard over here. Geez, I've never worked so hard in my life. Now I can just select the columns that I want. Date sold, date sold. Oh yeah, yeah, date sold, then I need, which the difference, so difference, and then I need sold more. And let's run this. Okay, oh boy, we might have done it guys. I may not have completely made myself look like a fool. Let's look at this, this is right. 601, 12 pie, 601, 12 pie, guys, we did it. Let's look at the bottom. All right, let, oh no, wait, wait, wait, wait, wait, wait, no, there's something wrong here. This one should be cake, correct? Let me, let me comment this out. Let me get everything here, there's a problem. There's something wrong with this last one. Okay, if cake sold more, it should be cake, but that says pie. Let's go look at our thing. When the D1 amount is greater than the D2 amount, which is null, on the back end it's null, maybe I need a logic there to say zero, because it's null, why is it saying that? Maybe I need, I hate to have to do this again. Wait, no, wait, wait, wait, wait, maybe I need to check, oh geez, this is a problem. This is a problem, okay, wait, wait, wait. I can do this, I can do this. I'm making this 10 times harder than this needs to be, but I'm okay with it. It's a zero here. The issue is, is up here outside of the CTE, it's technically a null when I'm doing this case statement. It's technically a null. So when I'm trying to subtract it, it's not subtracting correctly. Now we have this data formatted correctly. Now I can use this to determine that that's a cake. Oh wait, I've already chosen pi here. Oh, I can do this. I can get rid of this here. Let me run it, syntax error, what did I do wrong? Oh, here we go, let me get, I'm figuring this out on the fly, let's run this. This is 100% how I actually do things in the real world. So I'm gonna do everything comma, then I'll do this. Oh okay, okay, give me a sec, give me a sec. I know what I'm doing wrong. The issue is, is I'm doing, guys I feel like a stinkin' wizard over here. Okay, I don't need to do these anymore. I need to do, because there's no longer aliases. Let's run this now. And let's look at the bottom. It still says pi, why does it say pi? Maybe I was wrong. Oh, oh, oh, what am I doing? Let's run it. Yes, okay, okay. Now, since that is a sold more and we needed that, I just need the date sold, and I need the difference. Here we go, let's run this. Let's take a look. We have pi, pi, cake, pi, cake, okay. All right, let's try it. I've never been right to solve something that I created. Oh, guys, I've never been almost as embarrassed as I have in this moment and also as excited. I thought about using coalesce. Maria, I thought about using coalesce, I really did. Oh, you are correct. I need to order by the date sold. They just happen to be in the correct order, but I do also need to do order by date sold. That's it. There we go. Oh my gosh. I made that way harder than it needed to be. Let me go look at the solution. Okay, so I was using a sum of a case. Oh, interesting. No, this makes perfect sense. And then I could have grouped by the date sold. Wow, wow, that was such an easy, that's a way easier answer. See, but this is the fun thing of, especially the medium to hard and very hard questions, is I solved it in a completely different way. This was way harder than it needed to be. I was doing self-joins and CTEs and all this stuff. This solution was very easy. And honestly, if that's not an example of just how the real world is, I don't know what is. But I could have just done an absolute on a sum on a case statement. Wow. Old Alex, six months ago when I was writing this question, is way smarter than today, Alex. That's all I have to say. But I got the answer right. So I come back here, I got it right. I submit it twice, didn't need to do that. Let's go look at my badge now. I wanna see if I got a badge. I better have. Okay, I got my beginner badge. It goes zero to 100, you can earn the beginner badge. Then it goes up to, what's the next one? Is it novice? I can't remember, but then at the end, when you keep doing these, you can become like a master. Let's see, let's see what people are saying. Thank you, thank you guys, I did it. Holly, that's the whole point of the thing. Because that's the whole point of the platform, is because I just solved a hard question. If you don't know how to do it, you go and you watch my video explanation. And then I walk through it exactly how I'm walking through it with you. I walk through it in these problems on every single question. And it's just super helpful. Is it looking at the expected output cheating? No, just as hints aren't cheating, if you're on here and you need a hint, look at the hint. You can also look at the expected output and just see, okay, am I, should I be getting what I'm supposed to be getting? There are times, especially with harder questions, where even if you're looking at this and this looks the same, maybe you have an empty space on a value and even if you check the answer, it's gonna be wrong. And so no, expected output, I don't consider cheating. I think you should know in your head what it's supposed to look like. Like in real life, you should know kind of what you're trying to create before you do it. I'm just looking for accolades in the, I'm just looking for people to celebrate me in the chat here and it's all you gotta do. Oh, if you haven't, if someone just asked where you can get this, I'm gonna, let me do this. Let me get rid of this filter. I'm gonna say access free questions here. Jessica, that's okay. Thanks for joining. I really appreciate it. I really do. Can you, how to get started? Go to that link that I just put and just filter by the free questions. So come over here, go to the free questions. I'm, I've only answered free questions. I've already earned my beginner badge, but I solved a hard one. But you earn points based off of these, which we're gonna add. We need to add like the points system up here because you earn 10 points for an easy question, 25 points for a moderate question. 75 points, how many points am I at? I'm at 100. So you earn, yeah, it's 10. Let me remember, I don't remember what the points, I need, see I need to write it down. But if you answer like a very hard question, you get 100 points. I think it's 75, 50, 10 or something really close to that. That can't be right though. So I've solved three. Don't, don't quote me on this. I can't remember what the point, that's why I need it here guys. Because soon, if you're watching this, we got out of the point system and the leaderboard here quick, because I, not quick, we're not gonna do it today, but we need to add that, because I forget. So I want you to get on here and try these out. Now, you cannot access the very hard questions in here. That you have, this is only part of the, the like subscription if you pay for it. But I wanna show you some of these, one of these questions, because these are like, they're very difficult. This consecutive visits one, this Uber cancellation I think is a really neat one, but I actually like the consecutive visits better. It's so simple, but so incredibly difficult, which I keep saying this, and I want you to know though, is that I modeled all of these questions off of real questions that I've asked and real world problems. This consecutive visit is something I've done in the real, my real job a hundred times. And it's always a different variation or a different flavor or different functions that you have to use, but this is a real problem. This is a real, you know, you have two tables here. And the question is so simple. Write a query to return the ID and name and the number of consecutive visits of the person who has gone to Waffle House the most days in a row. Super, it's very simple, right? Somebody goes five days in a row. That's the person who went the most days in a row. Here we have the ID, we have their name. Then we have when they went. So this is their ID and this is the visit, the date that they went. On the surface, this is so simple to just look at and understand, but it is really tough to write this logic out. I was, and the reason why I keep the data set small is that you can visually kind of understand, okay, I think it should be this person, but how do I write it, right? And I've worked with data that's very similar to this, trying to find consecutive visits to a hospital, consecutive visits, monthly visits to a hospital. I worked with a lot of hospitals. Those are things that are 100% real world applicable, but are very difficult to write. And when you're working with millions of rows of data, tens of thousands of patients in a hospital data set, real patients, you know, you can't just look at it and know you have to write code or a query or something to actually do it. But this is a deceivingly difficult one. This is a very difficult one, which is why it's very hard. Let me see, see what I think. Oh, my wife, no, it wasn't my wife. Who's messaging me? Oh, just getting messages from people. Deceivingly hard one. Now, I don't know if I'm gonna try one of these just yet, we've been doing the live stream for an hour and 20 minutes. These ones could take legitimately, you saw how I did with the hard one. The hard one was not easy. I made it much more difficult than it needed to be, but I got the right answer. But these very hard ones could take like 30, 45 minutes to solve one problem. And I don't think even still, even with the upgrades to chat GBT, that you can solve these with AI. They're very difficult problems, which kind of brings me to just something I'm gonna talk on a little bit. I mentioned earlier the difficulty. If you wanna practice these, easy and moderate are what you should know before you go in for a technical interview. I know this, because I conducted technical interviews as I was a hiring manager. I did it for over three years. I also have interviewed a ton myself where I was trying to get a job. These easy and moderate are things you need to know. Group by joins, self joins, different types of aggregations, sub queries, all these different things are mostly me moderate for some of those harder ones, but the easy ones are like the more simple ones. You need to know these for technical interviews, for real. The hard ones are like for like mid-level, senior level. The hard ones are still pretty hard. Let me come down here. The hard ones are still pretty hard and there's a lot of them. There's a ton of questions. You saw how long it took me to do one question. It'll take you a while to do a lot of these. And I just released new questions like two days ago or three days ago. So I'm gonna be adding new questions to these. So even if you're working on these, next time you come on, there'll be more questions, right? But there's a lot of really good ones on here. Oh, I love this question. Good dog, bad owner question. This is a tough question. I love this question. I might solve this one in a little bit because I'm trying to rank up. My goal is to get to, let me get my profile. My goal is to get to the next level. I wanna get to this level. So I may have to do a few more hard questions because I wanna rank up fast. But I think it's like, can't remember what the ranking name is. I can't remember. But I wanna get to that next level. Soon or in the future, we're gonna have a thing where you can generate a badge just like you can do with the certificate once you've completed a course. For new people, we've got a lot of new people join. Wait, let me answer. How do you participate in the giveaway? I'm gonna be doing the giveaway soon. I'm gonna be doing the giveaway soon. VELUS, is this like Stratoscratch platform? The coding section is similar, but I personally made all the videos. That's one of the biggest differences. So let me come in here. Go into a question. The difference between me and something like Stratoscratch, one, at least for the whole platform. One is I have a video explanation of every single question. I walk you through my thought process, how to solve it. The other thing is, is I have full courses. So you can come in here, take a full course, which I'll show you in a little bit, but you can come in here, let's do the pandas for data analysis. You can come in here, and I need to edit this because I actually have two full projects in here, but you can come in here, you learn about it, and I don't think I, these aren't labeled, but you learn about these things, so filtering on columns, and then I teach you, and then you come down here, and you have to actually implement what you learned. So the IDE that we were just looking at is integrated into the courses, and then you have to use what we're learning about in this actual problem, right? So for this one, write a query to return all the phone numbers that have area code of 701. This means the phone numbers beginning in 701, and then you have this right here, and you have to write it. You have to check your answer to move on to filtering using date functions, and then you'll learn about date functions in pandas. And so that is the difference between me and something like Strata Scratch, or something like Udemy or Coursera, is different platforms have different aspects of what we have here, but no one has one. So if you wanna get this, just the coding stuff, you can go to Strata Scratch, and you're gonna pay more money, one, but then you won't have access to courses, so you have to go buy another subscription to something like Coursera, or go somewhere else and buy something. Again, it's all put in one, and then probably the biggest thing, the best thing that I would say, honestly, is I genuinely think these are some of the best courses that you're gonna find out out there. I made these, and I've taken so many courses myself, so I made these specifically to be better than other courses with the integrated IDE to practice as you go, and the projects at the end are like ones that I, a lot of these are ones, especially this Panda's one. These are probably the two of the best courses I've ever made, or the best projects I've ever made. They're really in depth, and so are the Excel ones that I have in my Excel course that's coming out. The ones in these ones are great, too. I'm not saying they're bad. They are really good, but this Panda's one, I'm just like, these are ones that I would put in my portfolio today, even if I wasn't a beginner. Now, some of these other ones are kind of geared more towards beginners, or intermediate. These projects are geared more towards advanced because you have to know Python already to take this, or I really recommend you already know Python because I don't cover a lot of the basics. So if you take this Python programming for beginners course, and then you take the Panda's for data analysis, you are gonna be rocking and rolling. I genuinely go, I think it's everything you need to know for Python to get going in a real job and start using it. And so that's the difference between me and other platforms, or analysts builder and other platforms is it's all in one. And you may not have heard me before, but we're adding so many other things to this platform that are just gonna help a lot of people. A whole resources section with resume templates, cover letter templates, different communities that you can join and a lot of other things. We're gonna be integrating AI early next year into the platform for help with coding. And then if you have questions during the courses where you can kind of like ask questions live and it's all integrated. So you don't have to pay for a chat GPT subscription or go on bar and a separate thing. It's all gonna be in there. And then just a ton of other things. And I'll be adding more courses and I'll be adding more questions consistently. And so the differences is really just it's all there, right? Let's see. Oh, Kasun's in here. Hey, thanks man. I appreciate you being here. He's like my right hand man. He's the guy. If you have any issues, he's the guy or come to me. But oh, one other thing I wanna point out and this is, and I don't really, I need to explicitly say a lot of this is I've also modeled a lot of these questions after real world scenarios. So duplicate emails, I have things on data cleaning. So there's a lot of questions where you need to clean data. Usually like the harder ones, let's go here. I'm gonna see, let's see. Help request. I'm just trying to find one that I know is data cleaning. This is a good one. Okay, so this is like a data cleaning example. Not the expected output. Let's go to the preview. So this is our table. The question says, Jeanine is a mess, which I try to add some humor into this platform because I think it's funny. Let me see what was my wife saying. Oh, she's gonna bring me lunch? I'm gonna say that's so sweet. Anything really, maybe a sandwich. I love a good sandwich. Just give me a sec. Yeah, she's not feeling great today, but she still was doing that for me. It's super sweet of her. I try to add some humor into these and even in the video explanation, like oftentimes I'm just laughing at my own questions. So I hope you don't mind that. But it says Jeanine is a mess that has been putting product sales, has been putting product sales they have made incorrectly into the system, right? A query to standardize the names. So data standardization, data cleaning, all these things. So there's a lot in here like that. Note, to be formatted correctly, they need to be in proper case. First letter upper, lower case letters with no punctuation include all columns. Now, the issue with this data, and Jeanine did a horrible job and this happens all the time with real data, is one, we have a microphone here. It's the same product. So product ID of 101, microphone. This microphone is not capitalized and this microphone is capitalized but has an exclamation at the end. So we have a lot of data quality issues in here. And so I tried to model a lot of the questions around real world issues and examples, things that I've encountered in my job a lot. And you'll find these, and maybe I'll come back and do this question in a little bit because you need to use regular expression on this. But a lot of these questions are modeled around real world issues, especially the very hard questions. These ones are very hard because they're things I really did in my job a lot that I would consider a little bit more difficult. And so consecutive visits, how much time someone is spending on something, a hierarchy where you needed to use some type of recursive CTE, we're breaking out a very difficult address. So for example, you're given a database containing customer addresses, ready query to break out the address column into separate columns for streets, city, state, and postal code. This is something I've done a thousand times in my real job. But it adds a little twist and it's a little bit more difficult than other ones because it says note, some addresses may have additional unit or suite information like suite 5a. This should not be included as part of the street. So you kind of have to filter these out or get rid of some of the bad data in there and clean it up. It's just super realistic. And so I really, well, you need to, this is a very hard question, so this isn't part of the free, I'm just trying to share free ones with you guys so that you guys can go and try it right now. That's what I'm trying to do. But we did the cake versus pie, that was really tough. This temperature fluctuations is a really good one. I'm trying to level up in my SQL and I'll do Python later. But this is a really good one because you have to look at the, you have to look at the data and look at the previous day, which is really neat. In just a second, I'm gonna try this one. I'm gonna do a giveaway really soon. Wait, let me do next question. Next question I'll be doing. And you can try that, it's free to go do. Yes, my wife is lovely. So we have to buy the courses and questions separately. The answer is right now, yes. And the only reason for that is because I haven't set up the full subscription to have both courses and the questions. And the reason I'm having trouble with it, and let me come right here, the reason I'm having trouble with it is because we're a very unique platform, there's no other platform like it where it has both of these, both courses and the questions and then we're adding more things in the future, we're gonna have a full project section. So if it's $15 per month here and the courses, let's say, another 30 bucks per month, I don't wanna charge $45, that's way too much money, I don't wanna do it, I'd feel bad about doing it. And then I'm like, well, I'd wanna do maybe like $24, but then that's like $9 for all the courses per month and I don't know, I'm struggling trying to figure out what the pricing should be for that. And that was a relatively new suggestion by someone. And I was like, I should do that, but we also have to change some of the backend infrastructure to accommodate for it. And so because of that, we haven't implemented that yet. So as of right now, this is how our pricing works. If we ever change anything, you still will have access. So if you buy this, you'll still have it, you can always stop the subscription, change your subscription later. But the courses I wanted to genuinely keep a one-time purchase. I want you to be able to buy it once. Come in here, buy this MySQL interview crash course, get ready for your technical interview. And it goes really in depth into here's what you need to know for your technical interview. Just pay $34 and you'll never have to buy it again. You can just have it forever. And that's what I want. I don't want people to have to keep paying for the platform and just want them to be able to buy it once and have it for the courses specifically. But also we have these bundles and you can get 20% off right now. So if you wanna buy all the courses that we have right now, you can get them for 20% off of this is $99 or 20% off of our 349, you can get 20% off that too. And that'll give you access to all courses, all questions and all future courses and questions. So if I make 10 more courses next year, which is kind of, I think my plan is to make seven, you'll have access to all those when they launch and you won't have to pay anything else. So yeah, that's kind of our pricing model right now. It may change over time, but if you ever buy anything or do anything, you will have access to it, we'll never take away your access. So let's see, okay, I am going to do a giveaway here. I'm gonna be giving away a course, any course you want, you get to choose. I'm gonna be giving this away to two winners and here's how it works. It's semi-honor system, semi-not-honor system. What I'm gonna do is I'm gonna ask you to post something in the chat. If I select your name, send me a message or send me an email to alextheanalystyt at gmail.com. That's alextheanalystyoutube at gmail.com and just tell me your name, tell me that you won and which course you would like and I will, and so I've done this in the past and it works really well. I've never had anyone email me lying to me and it works really well and so let's do, all you have to type in the chat is I'll start it out. So all you're gonna type in is analyst builder is cool. That's all you have to type and when you type that, I will choose someone and then you guys can select any course you want. I will send you a code for you to have access to it. So go ahead and type that in the chat. I'm gonna start, I'm gonna wait for just a second while people start typing that in there. Give it a second. I see them starting to stroll in. Here we go. All right, very good, very good. All right, I'm going to kind of scroll up. This is, we'll just see how, to be honest, Mohanad, if that's how you pronounce it, he or she has been here the whole time since the beginning of the live stream and was the first person to post. So Mohanad, you are a winner today. Shoot me an email. I'm gonna choose one other person now but I'm gonna choose more people later. So don't worry, I'm gonna choose more people later and one lucky person is gonna win the Analyst Builder course bundle later in the stream. So you're gonna get all the courses, every single course. But for right now, Mohanad won the first one. Let me go down, let me choose one more person. Let's see, is there anyone else who, I'm not trying to be like select, I'm not selecting like, I'm trying to be somewhat random. I'm just, you know, if people have been here the whole time, that's wonderful. Let's see. All right, let's go with Alan. So Alan San Pedro, you are our second winner for this giveaway and I'm gonna type it right here. You guys are two winners. Thank you guys so much for joining. I'm gonna be doing more giveaways. I plan on giving away like 10 courses and the entire Analyst Builder course bundle today. In the future, in a different one, I'm gonna be giving away two lifetime access bundles. Once, I think once we reach 750,000 subscribers, just me next year, like in a couple months, I'm gonna be giving away two of these. These are the big ticket item but I want to start with some of these Analyst Builder course bundles. And there we go. So, congrats, thank you guys for joining. I'm going to be doing more giveaways. So if you did not win, that is okay. I will be giving away more. Now, let's come back here. We're gonna do a temperature fluctuations and I'm gonna post this again. Current question, oops. Current question working on. There we go. So go ahead and open up that question. We're gonna work through this temperature fluctuations question. Again, this is a hard one. I'm trying to rank up. I wanna get my badge. Let me get my profile. I did a new account. So I just created a new account. Why is it, oh, I'm at 110 right now. So it's from 100 to 500. Here's our current score, 110. So I need to get to 500. I really want to reach that level. I would really hope I can get there. But it takes a while. There's a lot of practice. Well, let's see what we can do. And I'm just gonna focus on my SQL for now. Once I get to that level of 500 points, I'm gonna switch over to Python to show you guys how Python works. Because Python is super fun too. So this is write a query to find all dates with a higher temperature compared to the previous dates yesterday. Order dates in ascending order. Okay, so let's go look at our data. So we have a date here and then we have the temperature. So it says that's a higher temperature compared to the previous date. For example, this O2 is 70 degrees. This is a higher temperature than this date. Now let's see what the expected output is. So we're just doing the date. We just are putting, it says write a query to find all the dates. So we're not doing date and temperature. We're just doing the date. So for something like this, I have, there's two schools of thought. One, I could do a self-join and I could join this to the previous days by saying this date plus one or this date minus one. And then I would have date, this date, temperature and then this date and temperature next to each other. So I could do that or I can just use a lag function. And the lag function will say this temperature lag minus one. Lead is the opposite. So we have lag and lead, but lag should look back one. Let me see, I think that should work. I think the lag should work. Let's just try it. So I'm going to, and I just need to choose the date. So maybe I just need to do everything and then do lag. Let me see if I know how to write this. Cause this is a, we're gonna do lag on the temperature I believe. Or is it the date? I don't know. Let's just start writing this. No order list. Oh, okay. I need to order this by the date, I think. I think that's what I need to do. So this gave me some context. It says unknown code, no order list and window specification for lag. So I think I just need to say order by date. Oh, order by. What am I doing? The amateur is a rookie mistake. Okay. So here now, this is essentially what I was going to do but with a self-join. But I didn't want to do those too much work. So now we have 01 and we're looking at the previous date. Now since this is the first one, it doesn't have one. But this one we have one and two, or sorry. We have January, the second of January. No, wait, wait. Yeah, second of January. But we have the temperature and then we have the previous days temperature. So let me call this as previous days temp. Let's run this and what I do wrong. What am I doing, guys? I'm making myself look like a fool here. Absolute fool. So let's, real quick, let me see if I have a, oh, I do have the thing in here and the code. Okay, I was just making sure. Yeah, so someone, I just got a glimpse. Someone asked what the lag function does. Hey, listen, if you don't know, go check out this lesson, it's free. I posted it in here. This is to the explanation of it. If you come here, you can watch this explanation of it. I describe exactly what the lag function does, how it works and how to solve this problem. But the lag function essentially takes, we're looking at the temperature. That's what we're gonna be putting in our output. We're doing that based off of the date. So we're ordering by the date and then taking the previous temperature in the previous row, essentially. So now we have this and now all we have to do is say where the temperature is greater than the previous day's temperature. Can I do that in this or do I need to use this as a subquery or CTE? I think I can do it because I can just, I think I can do it. Let me see if I can. So now I'm just trying to choose the date. Oh no, I don't think I can. I don't think I, because in my output is just the date. So I need to use this as a CTE. So I'm gonna say width and we'll do temps as, and then we'll wrap this in here. Maybe I can, I'll check the answer once I'm done, but I don't, I think I need to use a CTE. So this is my new CTE name. So now I'm gonna do select everything and I'll do from temps. So this is kind of like a little mini table. This is our data and then we're saving it as like a CTE, which is a common table expression and then we're selecting everything from that common table expression and now we can do this really easily. Oh wait, wait, maybe I could. I can just do it in the where statement maybe. What am I thinking? Let me try to do it with how I'm doing it right here but I think I don't need the CTE. I think I'm complicating it. Because I just need to say where the temperature is greater than the previous day's temperature. Let me run this. Now we have two, four, five, eight, nine. Two, four, five, eight, nine. So we got it. Now all we have to do is select the date. And there we go. Now let's check this. And there we go, we got the answer right. But let me just, let me see if I needed to use that temp table. Cause I think I could also just filter here. So let me get rid of this and let's run this. Oh no, I don't think I could. Cause again, I have to do where this, but I still am only trying to select the date. So I think I had it right. I think I had this right. Let's go look at the solution. It's in my SQL. Select the date. Oh, here I did, okay. So in this one, I didn't use the lag function. So in my answer here, I didn't use the lag function and this actually looks simpler. Let's check this out. So this actually looks simpler than what I decided to do. Here I used a lag function and I had to use a CTE with it because we had to select a specific column within this data. So I use a CTE. Now here, I just used a join, a self join. So if we go back and look at the data, I just joined it to itself based off of the date difference of these dates being one. And this is kind of my filter and the temperature of table one is greater than table two. That's how I did it in this answer. But you can do it with the lag function as well. That's the beauty of the platform as you can do it in any different way. There's one way that I force you to do it. But I do get hints. So let me see what the hints were. Try joining the data to itself. This way you can compare two columns together. Tie them together where the date is equal to the date before so you can compare them. That's a practical hint. That's a practical hint. So I got it right. Let's see, that one looks more difficult. I actually think this one was more easy, Diego, in my opinion. But hey, listen, go try it out. There's a few free hard ones on the platform. You can just try it out. Yes, Mohanad, us humans tend to over complicate things sometimes, absolutely. I tend to do that quite a bit. But that is what I would say is the thing that as you get more advanced in writing any programming language or query language like SQL, is once you write it out and you figure out how it works, I'm gonna, for example, like I used to work with tens of millions of rows of data, I would write a query and then it would take like 30 minutes to run, which is not ideal because it's really complex. Then I have to think, okay, how can I make this faster because I'm about to put this in a stored procedure that's gonna run every night. And if it takes 30 minutes, that's a lot of load time on our servers. In the advanced MySQL course, I talk about how some of these things, like how you have to think about these things. So query optimization is important, but also things like indexing, you know, you have to think about how you can speed these queries up. Maybe it's rewriting the code, redrawing your query, or maybe it's changing something to the database itself, like creating an index or storing the data differently. That's where it becomes a lot more complicated, a lot more advanced. But for something like this, to be fair, something like this, yes, you know, I wrote this, I complicated it a little bit, but I probably could have rewritten it and done this and made it, maybe it was a little simpler. Sometimes though joins, certain joins can take a long time depending on the size of the data. So maybe even a CT would have been faster. Completely depends on the data. But hey, we got it right. Got that green check mark. And let's go check our score right here. I want you guys to, maybe it is 75 points for the hard. Yeah, wait, I was at 110, it is 75 points. So I was at 110 before, I got a hard, and now I got, all right, I completed a hard question, I got 75 points for it. Yeah, 75, maybe it's 35 points for a moderate. What's 110 minus 75? 110, wait, I'm about to math right here. So 110 minus 75 is equal to 35. Ah, so then I do minus 10 because the easy question is 10. So the moderate questions are 25 points. So it goes 10, 25, 75, 100. Maybe I should make it more. I think very hard questions should be like 150 points. Because soon we gotta make those very hard ones 150 points. I'll send a note, I'm just kidding. But I might update that. Okay, so I'm working towards, right now I'm at 185 points, I'm trying to get to 500, so I think it's like, I came up with the badges for that. But then it goes novice, something master. I don't remember what it was. But anyways, I'm gonna take some questions really quick. And then I'll go back to answering some questions. So I want to, we've been at this for two hours now. I'm in here for two hours. We've already had thousands of people come through, a couple hundred people at a time. We're rocking and rolling. Let me, I see some good questions. That one looks more difficult. Okay, so what order would you recommend to complete the courses and starting from scratch? This is something that we're gonna be adding early next year as a roadmap of learning. Because right now they're just here and they're great courses, they're amazing. But you may not know which order to do it. And so specifically for beginners and people who don't know what order, I'm gonna recommend like a learning path. Here's how I would learn it. I would be taking, because right now we only have a selection of courses, I'm gonna be adding Excel and Tableau very soon. So, but for what is here right now, definitely start with MySQL for data analytics. This is a super comprehensive course. This will get you ready for like an entry level job, 100%. And the courses and the projects are really good at the end that you can add to your portfolio. You will be job ready just with this one. If you wanna go above and beyond, you can do the advanced MySQL for data analysis. This gets you introduced to a little bit more complex things. Things that you maybe haven't worked with a lot, but I think it's useful, really good. But I think this one is for most people, this one will be the one to take. Then I would take Python for programming and then Pandas. So I started with SQL and Python because you can, in the question section, get SQL and Python for right now. That's why I started with those. But Excel's gonna be coming out very soon, which is a standard, a staple, you have to take Excel. Or you have to know how to use Excel. And then Tableau, which is a really solid BI tool, then I'll be doing, then right after those two are released, I'll be doing an Azure, I may be doing an Azure and an AWS course or just an Azure and then a separate AWS course. I haven't decided yet. Depends on how much content I have for it, but I'm already planning that one. And then I'll be doing an AI course. With all of those, I'll create a learning path for it so that people know what to take and I'll create a few different paths to take. But I would start with my SQL for data analytics and then Python and Pandas. If you already know Python, take this Pandas one, my SQL and Pandas, that's the one I would start with. Let's see. Isn't database modification to improve performance, database admin job or is it data analyst job? It depends on where you work. When I was working in a big, large global company, I would not do that stuff. I go to a data engineer or one of our database developers and I would work with them saying, hey, this query is taking a long time, let's see how we can improve its performance. And then we'd work on that. And I was like, well, it's for this automated job that we run overnight to pull this data in and transform the data and they're like, okay, yeah, let's work on this and we'd optimize it and we get it done. But when I worked at a smaller company, I had to do all it. So I did all these things. And it can definitely be something that a data analyst has to do. Even though I would say it's more data engineering, data developers, it is something that you may need to do. It just is. You can make a leaderboard every week. I'll have a global, we'll have a global one, then we'll also have like a weekly one. So it's like an overall score and then like a weekly score. We will have that. Hello, I just graduated from a bootcamp and recently on the job search, do you have any advice? If you graduated from a bootcamp, hopefully you'll have people at the bootcamp who are helping you find a job. If they are not, if that's not what their program does, they don't offer a money back guarantee. I'm not a fan and I feel I'm sorry that you took it. I hope it really helped and I hope you have a team like a dedicated person to help you find a job. My recommendation is get in touch with a recruiter and start practicing for your technical interviews, a.k.a. doing technical questions. Focus primarily on easy moderate and once you have those down and you're like knocking them out and you're like, okay, these are a lot easier, then move on to the try the hard ones, which involves a lot more CTEs, a lot more window functions, more difficult types of joins, things like that. So that's what I would do if I were you, genuinely. J.C. Tupaz says, John from Phil's, I may ask that's Philippines. I just want to ask if you have, if you plan to have another plan, like get the analyst builder CRS bundle first, then later upgrade to lifetime for a lower price. We're trying to figure out how to do that because people have bought the bundle. They'll buy this bundle right here. And then they're like, well, we really, I really want to include the technical questions for life and get all the future courses because this one only gives you the courses right here. This one gives you access to all the starting courses for SQL, Python, Pandas. This will get you all the access to the courses and the questions and all future questions and courses. So people want to upgrade. We're trying to figure out how to do that. And I think we have figured it out. We just have to implement it, which may take a couple of weeks. So we'll check, hey, did you buy this bundle? Oh, you bought it for $99 after fees and taxes. That's $80 and then we'll take $80 off of this. So it's just a logic to it. But we actually have been looking into that because a lot of people have said they want to upgrade and we want you to be able to upgrade and get that discount. So yes, we are looking into that. Yeah. And adding a profile picture, yes, we'll have a place where you can add a profile picture for the leaderboard and stuff like that. We have to implement some type of system so that people don't post inappropriate things. But we are looking into that. And then the roadmap will be available in not too long. The Excel course is gonna launch in January, early January, then the Tableau course will launch probably in late February. The roadmap will be available right after Tableau is done. So early next year, probably by March, we'll have a full roadmap available and stuff like that. Data engineering. So I myself love data engineering. I consider myself quite good at it, but I would want maybe to bring in someone who's a little bit better at the in-depth engineering, which I would love, but I wanna focus more on how it relates to data analytics. So something like an analytics engineer and then do something, maybe data science and bring someone in for that. Cause again, that's not my specialty. I specialize in analytics. So in the future though, I do plan on having small sections where you can kind of branch out. Okay, I know data analytics, I've done it. I'm thinking about doing a little bit of data engineering or I wanna learn some of those skills. I plan on having things for that. I just kind of have been setting it up. Let's see. Why do I feel like Python is least used in data analyst jobs? I've actually used Python a ton in my job. Compared to SQL, it's not used as much. The primary skills that people use are gonna be SQL, Excel, and then a BI tool. Definitely the core skills to learn. But Python, I feel like I used a lot more as I got more advanced and especially as I got to a larger company, they used a lot more advanced things. So for example, in Python, I did a lot of automation. I also, the Python translated really well when I got into cloud. So I started using Azure a lot. I started being able to use a lot of Python and PySpark, which is a Python variation of Spark. And so I found that I used a lot more as I got more advanced. That's what I found. If you guys are just joining, I had a whole setup at home, ready to go is gonna look really professional and really great. And then my internet went out. And so I am at my dad's school right now, just chilling in a room. And so I hope you guys are okay with that. I brought my microphone. I hope the audio is good at least. Let me see. Yeah, we're still doing good. But it was last, like literally this morning, I'm like, oh, I have my live stream. Let's go set it up. Internet's down. Let's see. Completed the Google data analytics cert. The course primarily taught Google Sheets. I preferred so much over Excel, but I was wondering if for your resume or tech interview, if it matters. More companies use Excel than Google Sheets and Excel has more functionality. Google Sheets is great. I like Google Sheets myself. I use it myself for certain clients that I work with because I do consulting, but Excel does have more functionality. It does have a lot more features that you cannot get in Google Sheets. So I kind of recommend, you can have both on your resume, but I wouldn't just put Google Sheets. Although I think if you know Google Sheets, you should be able to put Excel on your resume, right? Cause there's still a lot of crossover. Do you need Power BI for an entry level job or just SQL? I started out with just SQL on Excel. Then I learned a BI tool on my first job. So you don't absolutely have to have it, but I look at it as like percentages. If you only know SQL, you're limiting yourself to a certain percentage of jobs. Then you know Excel, then you know a BI tool. You're opening up more jobs for yourself to apply for and actually have a chance of getting. Trust me, it's worth to not cancel this live. Thanks, Alex. Thank you. Thank you, Nora. Nora, you've been here since the beginning. I really appreciate you being here. You've been really supportive and you've been active in the chat, which I really appreciate, but thank you, thank you. Yes, this was my backup plan and I would have loved to been in my office and have all my lights and everything and my better camera. I'm using a webcam, which I never use. This is like in my junk drawer, but hey, I go with the flow. It's okay. Let's see. Do you have a recommended course for statistics and math or do you suggest to include some course for this in the roadmap? In my Excel course that's coming out early next month, that course I have a whole section on statistics that I think is probably all you need to know, in my opinion. Now, in certain positions like financial analytics, you might need to go more in-depth, but I have worked with a lot of clients in my consulting. I've worked for a healthcare analytics company. I've worked as an analytics manager in IT. Everything I teach in the Excel is probably all you need to know. Mean, median mode, standard deviations, percentages. Oh, what's the other stuff? There's a few other sections in that course. So in the Excel course, I have a section on statistics. I don't think I'm gonna make a whole course on statistics, because unless I bring someone in who specializes in it, because I have not found that you need to go crazy in-depth in the statistics for most data analyst jobs. That's my opinion. But I will, I will, it's in the Excel course. Will you offer management classes on how to review your team's code and dashboards? Maybe like in the future in like two years, that's not gonna be something I focus on at the beginning. Will it be data science? I plan on bringing someone in to do one or two courses on data science in the future. Say our or say our sign said, hello, Alex, I'm from a math background and you're a teacher. Hey, that's awesome. I come from a family of teachers. Now I'm on the way to learning data analysis, congrats. I really hope this platform can be helpful. Rohit Drone Academy said, how AI replace working of data analyst? I am a firm, firm, firm believer. And I've, I'm gonna give you my opinion on it as succinct as I can. And then I'll tell you kind of like what other people think. I genuinely think AI is gonna be an enabler and is going to really enlarge in the data community as a whole. A lot more jobs are gonna be opened up because of AI because there's so many people who are kind of dinosaurs with their data who are seeing AI really transform things and they have to now start implementing AI but you can't do that without a team. You can't do that without a data infrastructure team or data analysts who know what they're actually doing. And so that's gonna really expand what people need. And from what I've seen for the actual data analysis, AI is really only good for like the basics. Once you start getting into more advanced things, it doesn't work and I've tried it. I've really wanted it to work on certain projects that I've worked on. It just doesn't. And it gets you like sometimes 80% of the way there, sometimes 50% of the way there, but it helps, it's an enabler. Now I've talked to a lot of experts in the area who are like at big tech companies who are experts in the field, whether they're an analytics manager, senior data analysts, data scientists. I've talked to a lot of different people. I've only had one person who was like, I think AI is not going to be helpful for us or it's not going to be something that's gonna really change things for us because of XYZ. Most people, most people I talked to, that's the majority. We're all saying the same thing, which is AI, we're looking into it right now, but we see AI as something that we're gonna invest a lot of money, a lot of time and invest a lot of, I gotta put this guy at a time out. It's too many, too many messages. I can't see all the other ones. Sorry, sorry friend. That's a lot of time and money and we're gonna have to increase our headcount for this. More data analysts, more data scientists, more people. AI is not a one-size-fits-all cure to things and in fact, some areas it's gonna complicate things and you'll need to bring in more specialized people. So that's my take on it. I'm not gonna do a full, I have multiple videos on it if you're interested. Do you think R is a good program for data analysts? Absolutely, absolutely it is. But I just personally prefer Python but I used R in my job for like two years. I am no newbie to R, I know how to use it very well but I just always preferred using Python and that's why I recommend it. Other people at other jobs and at other backgrounds they recommend that you learn R, that's okay. But I personally think Python is just more versatile. Do you think, oh I just answered that one. Priya said, I just wanna say you're an amazing teacher, I can't wait to purchase this. Thank you so much. I really appreciate that. I really try to make these courses the best courses that you can buy genuinely. I really, I hope that comes across in the courses as well. Any suggestions to get jobs as a data analyst who has carrier gap, oh career gap, working on from six months? If you lost a job, really sorry to hear that or maybe you just took time off, right? Maybe you took a break to care for someone or have a child or who knows what it is. But if you have a career gap, I have never really seen that as a big red flag in my interviews although some interviewers or hiring managers may see that as a red flag. I really recommend the same thing I'd recommend to anyone searching for a job right now which is get with a recruiter, make a really good resume. I have videos on resumes on my YouTube channel. Make a really good resume, make a good portfolio with projects in it and start applying with the recruiters. Now if you don't know how to reach out to a recruiter I have a whole video how to use LinkedIn to get a job. That shows you how to reach out to recruiters on LinkedIn, how to get recruiters to reach out to you. So go check that out. Can an accountant become a data analyst 100%? If anything else, that's a great background to be in. I would have loved to have been an accountant. I was a recreational therapist. That's what I have to agree in guys. Recreational therapy, nothing to do with this field. But everything I kind of teach in these courses and on the platform and on my YouTube channel, I'm telling you from the perspective of I broke in myself and was able to make it happen and I know you can too. And here I kind of give a lot of tips and tricks on how I did and how you can too. It's expensive for Indian people. Yes, so right now our prices are USD. We're using Stripe. So we're trying to figure out how to do it based off of location. I'm not trying to figure out, there's a way to do it. It just takes a while to do. We will have a location-based payment in the future, hopefully. We just have to kind of figure out how to implement it on our backend. But it is possible. We just haven't been able to do it yet. Suraj said, love the platform, thank you. It's like learning from a friend. It's fun and educational, which is the best way to learn. I am so happy to hear that. That's exactly what I'm like. That's like my goal for this whole platform is just for it to be really fun and exciting to learn. I've taken a lot of courses where they were just really boring courses. I tried to make it fun. And I think the questions platform is also just like, the questions part of the platform is just really, really fun. I'm gonna solve another question just a little bit. Actually, yeah, I'm going to. I'm going to. I've thought about offering online consultation. I do, I have a whole consulting business, where I work with tech startups and larger tech companies in a lot of different areas for analytics. And so, yeah, I do consulting right now. That's like probably most of my work right now. Do you have members on your team from Latin number Europe? No, most of my team is in Asia. Most of my team is in Asia. Let's see. How good a background in international business or media buying when becoming a data analyst? I don't know. I'm not super familiar with both those jobs, I'm being honest. Dev said, thank you, Alex. Great platform, love the way you teach. Really appreciate it. Thank you. Aria said, sir, Alex, I've mirrored your portfolio and add to my Github. Is that okay? Absolutely. Take the projects, use them. Add them to your portfolio. But I do recommend going above that and trying to create your own projects and or improve on those projects and kind of make it your own, right? But those projects, I think, yes, you can 100% use them. And in the courses, it's like, if we come up here, in these courses, I have projects and except for in the crash course because it's not really a project base, it's more for interviews. But in all these ones where we have projects, these projects are meant for you to use and they're unique and they're really good. And yeah, I want you to use them. They're not just for you to look at. I want you to use them. I really do. Yeah, so I was talking about this a little bit ago. It says good platform and hope you manage to implement all other plan features. Do you plan like community forums where people could exchange and discuss solutions? Yes. That is something that, the thing is, is that when you start allowing people to post things on your platform, it opens you up to some risk of spam, of inappropriate things, of things you just need to take into consideration, right? It's like a social media platform at that point. It is more difficult. And so, yes, we are looking into it. I have a whole, we have a whole team that's working on this with us. It's not just me. And so the whole team is like really smart people who've built this whole platform. And yes, yes, we are looking into that. I'll answer this one question. Then I'm gonna do another question on Analyst Builder. It says, can you please tell me a little bit about what you do as a consultant? Now I have made a whole video on what I do as a consultant and how you can kind of get into it as well. So I'm not gonna talk too much about it, but go check out that video. It's a long form video. It's like an hour video on my YouTube channel. Now, I have people, I'm in a position which I'm extremely grateful for, where people reach out to me. They see me on YouTube or they see me on LinkedIn and they're a startup and they're like, hey, we want your services. They reach out to me saying, hey, here's our product. Here's what we're doing. Here's what we'd like you to do. Or here's what we need from someone like you. I'm just gonna kind of go into some of the things that I do for them. One is just general consulting. They're like, hey, we have this product. We want to do something. We don't know how to do it. Whether it's, we want to migrate to the cloud. We want to implement a BI service into this and I've done those things so I can advise on how to do that. Two is actually doing data analysis. Hey, we're encountering, we're trying to do this and we can't figure out how to do it. Can you come help us analyze this data or do something? And that's where like I have specialties, like SQL is a specialty of mine. I consider myself an expert at SQL and I'll come in and I'll help them figure, or in Python, I'll help them figure it out. And then I leave. I just help them figure out an issue they're having. Three is I'm helping them with go-to-market strategies for data products or market fits. So for example, when I was a hiring manager, I did a lot of the purchases for my team and for my department. And so I have a good perspective when people have a product, I can say, okay, you don't wanna target that at CIOs, which is what they were doing, or CTOs, you wanna target that at the managerial level. And so here's how you get into that market because I was there and so that's how you do it. And then sometimes I make videos, like internal or external videos for people because I have some video background. So that's what I do. So I do a little bit of everything. It's pretty all over the place. Paul said, sorry, just rejoined. Is Power BI in the future? Yes, Power BI in the future, absolutely. 100%. Can we get passwords throughout web script? I don't know what that means. You'll have to clarify for me. All right, I'm gonna go over to the questions page. As you should, go ahead and actually I'm gonna do join this question. Actually, let me choose a question first and then I'll do it. All right, let's choose a question. I'm gonna do a moderate one because the hard ones take a long time. I also wanna show you ones that are moderate, right? Tech Layoffs could be an interesting one. I don't remember what was in that question. These are all the free questions, by the way. So you can go and take any of these questions. Right now, you have access to everything. Let me do this too much information. This sounds like a good one. So again, I'm going to post this question. Do this question with me. So go over to Analyst Builder. All you have to do is create an account. It's free to create an account and try this question with me. So this is called TMI, Too Much Information. Often when you're working with customer information, you'll want to sell that data to a third party, just being honest. Every company I've worked for has done this. Most companies do this. Unless they have contracts with people where you can't sell their data. Sometimes it is illegal to give away sensitive information, such as a full name. Here you're given a table that contains a customer ID and their full name. Return the customer ID with only their first name for each customer. Now this is a moderate question. And so we're gonna need to do a little bit of separation here. We have John McGarry, but we don't want John McGarry. We're just gonna include John. So we have to get rid of this, McGarry, somehow. This is something, I've done this no joke, hundreds of times in the real world, where we're like, hey, we need to pass this data off to this person who is a client of ours. We have to get rid of some of this information because it's, what's it called? TMI, personal, is it TMI? What's the, it's just personal information. Personal identification information. I don't remember what it's called. My brain isn't working right now. But you can't have full names in there. It has to be, quote unquote, de-identified data, which is if I had like an address, a phone number, social security number, I can't include some of that information when I send data to these companies. So let's see how we can do this. Let's get rid of this limit 10 here. Let's run this. Now, my first thought is one, we just need the customer ID. So let's do customer under square ID. And then we need the full underscore name for now. But then let's come down here. Actually, let's run this. Now we need a new column for now and then we'll get rid of this full name. But we need a new column. We just need to separate this out. We can do that. Let me think. There should be a function. And what's this function called? Is it's not substring. I have to think of it off the top of my head. I could Google it. It's not substring, it's where we can use a delimiter to look at a delimiter. Give me a second. I'm trying to think of what that's called. It's not substring, is it substring? I don't think it is substring. Because if we do substring full name, I think we do like five. Let's run this. Yeah. So we're starting at number five and going forward. But I think there's a function where we can look at the delimiter. I'm just forgetting what it's called. Is it substring index? Substring index, that sounds right. Full name and then we have like, how do we do this? This is a substring index. There's a parameter count, incorrect parameter count in the call to native function. Yeah, because I need to specify what we're doing. I think it's like this, or a space. Let me look at the hints real quick. You'll need to split on a delimiter. The space, split on this and only keep the first name. I already knew that. Alex, what a terrible hint. That's my own hint. I think, I'm pretty sure it is substring index. I'm just trying to remember what the parameters are for this. I think maybe you pass through this first. Let's try this. And then we'll do a comma. I think we passed through the delimiter first. Let's try it. All right, I'm gonna Google substring index. Substring index, MySQL. Let's see what the parameters are for this. The string delimiter number. Ah, I was so close. Okay, okay. Hey, listen, even I forget these things. I can't remember every single one. We'll just do this, and then the first one. That's what we needed. There we go. Okay. So the issue was, is we have a parameter here. And the parameter is we have to have the strings. That's our full name. Then we have the delimiter. What do we wanna split this string on? We need it on the space in between. And then we wanna only do it on the first space on the first delimiter, which is this one. So now we just have John, Sally, Jenny. It takes the first part of the full name. And we're gonna do this as, what do we need it as? First name. So we'll do it as first underscore. Now we can get rid of this. We'll run this. And now this looks exactly like the output we were looking for. And it says return the customer ID with only, yeah. This should be right. Let's go ahead and check our answer. And there we go. We got that solution correct. Try this one out. Substring index for this one, but I don't think it's the same for Microsoft SQL Server. I think it's different for this one. And it's definitely different for Python. But once I get this badge in a little bit, at 200 points, that's what I'm talking about. Once I get this next badge, because right now I'm a MySQL beginner, once I earn more points, and I get the next badge, I'm gonna try Python. Just so you know, and we're gonna add this to the questions page, but when you do an easy question, you get 10 points. When you do a moderate or medium question, you get 25 points. When you do a hard question, you get 75, and then for a very hard question, you earn 100 points. And so right now I'm at 210, and you rank up, and you can become MySQL master. That takes like 3,500 points, but you can also earn points by doing a course. So if you complete a MySQL course, you earn 500 points towards your rank here. We're also gonna be adding a leaderboard over here. We have all the data on the back end. We're just adding a leaderboard soon of people on a month, like an overall leaderboard, right? So if you've taken a lot of courses, you've done a ton of questions, you have a ton of points, you're gonna be like high up on our leaderboard, and then if you, each week, we'll have a leaderboard for weekly users. So you can become, even if you just started today, you can get a leaderboard, whoops. So we're still looking at the free ones. These are all free to do right now. You can go on here, you can try it out, test it out, I want you to. I just did one. Yes, okay, Alan. Thank you for telling me now. I already did the question. I'm just kidding, thanks Alan, I really appreciate it. Yeah, yeah, PII, personally identifiable information. That's what I was trying to say. Can we separate based on the space between the names yes, and I did? We were able to figure it out. Great way to solve problems you're reforming, like how most of us would perform and utilize the website to find the answer, exactly. Now listen, if I couldn't find it, let's go back to that question. Where was that question? Too much information. Now if I couldn't figure it out, you can get hints, you can look at the expected output. If you can't figure it out, you can always go to the solution and take a look. What I do here, I use trim. That's probably smart to do, just to make sure you don't have any spaces or gaps in the data. I should have done that. Previous Alex was much smarter than current Alex. I'm finding very quickly. And if you couldn't figure it out, even after looking at the solution, you didn't understand it, I walk through that solution with you. Now right now, just a note, I only have MySQL videos, but I'm gonna be adding ones in Python later. There's like over a hundred questions right now in the questions page, I'll be adding more. And so it just takes a long time to record every single video. But I will be doing that. I will be doing that. I, one thing I want you guys to try just it'll take a long time. I really want you guys to try one of these very hard questions. These questions are very hard. Very, very, very difficult. I want people to try them. I've had a few people solve them already and sent me confirmation. Here's my, this is what I told people when they were beta testing it, I was like, if you can solve this question, you can send this to me. I will be very impressed. I was like, this, you really know how to use the tool if you can solve these questions. Like you really understand it. And when people would send it to me, I'd be like, dude, you did it. You were the first one or, you know, you were able to solve it. You're one of the very few who have solved it. There's very few people who can solve these very hard questions. And I'm not making them so incredibly hard where they're impossible. They just really, it takes, it'll probably take like, if you know MySQL pretty well, if you're doing it in MySQL, it'd probably take you a solid 30, 45 minutes, maybe even an hour or so to solve it if you don't get any hints or you don't watch the solution video or anything like that. And so I really want people to try those. Now let me clear this. I'm gonna just go back to the free questions here. You can also search by completed and incomplete. So if you only wanna look at the incomplete, we can do that. So now we don't have to go look at the ones we've already done. Let me do an easy one. I'll do a moderate one and I'll do the last free hard one, which is Kelly's third purchase. Cause that's a cool one. Let's do art attack risk. Here we go. Now this is one that inspired me because this is something that I used, this is like a crazy simplified version of it. But you know, I used to work with a lot of patient data and hospital data from doctor's offices and all these different things. So this one kind of brings me back. I really like it. Let me share this one with you guys. Try this question out. If you're just joining, this is not my normal setup. I apologize. Alex is surprised. Yes. Yeah, I'm finding that previous Alex was a lot smarter than current Alex. Like a couple of months ago, Alex, I was, so Milton said he's looking at like aspect, like ratios for points. I need to change the point system a little bit, I think, but it's currently 10 points for easy, 25 for moderate, 75 for hard, 100 for very hard. The hard questions you, if yeah, that would be the fastest way if you're just doing questions to level up. But they're hard. So they take a little while longer. I think the very hard questions I'm gonna change to 150 points. I think it needs to be. They're much harder. And there's not a lot of them because they're so hard. I didn't put a lot of them on here. Oh, we'll do this heart attack question in just a second. So some questions and then we'll get to the question, but it says a bit off topic, but this is from C chef. How did you find yourself working on it as a data analyst, as a junior data analyst? I look forward to learning from your site. I was working at a nonprofit as a caretaker, essentially. I made food for people. I had a degree in recreational therapy, but I could not find a job with that degree. And I was working at a caretaker at a nonprofit and a job opened up at the nonprofit for a data collection specialist and analyst. Had no idea what it was, but my girlfriend at the time, my now wife, said I was really smart and I should do it. And it was just Excel, it was just Excel work, just basic numbers, nothing crazy, just collecting data for grants. And I was like, I don't think I would really enjoy it or know how to do it or like it, but I was like, let me try it because it was a higher pay. I was making like, I was making like 36,000. And then when I got the data collection job at the nonprofit, I was making $47,000. So it was a jump in pace, I was willing to do it. Well, I got in there and I really liked it. I was like, man, I really like this data stuff. It was pretty neat. And then I got started looking up, like how do I advance my career in this? Cause this seems more of a better career than recreational therapy, which is what I was doing. And then I just went from there. I started learning SQL, I got a different job, got a better job, learned Python, learned Power BI, learned Azure, top low, got a promotion of manager. And then during that whole time I created this YouTube channel. And so yeah, that's kind of like my progression. These comments, Diego said, maybe it's because you don't do these problems more often now. Yeah, that's kind of true. I mean, but I should, I know these. If I really think about it hard enough, I know it. That's what's so fun about it. It's like it really is a challenge to get to these questions, which is super fun. That's funny. Yeah, there's your answer. Leho, Lejo, Leho, Phillip, said, will lifetime access to Analyst Builder include future courses? Yes. Lifetime access is gonna include all future courses and questions. So if you buy now, and it's 20% off too, so it's 20% off the 349, but if you buy now, when I release the Excel courses, I have another course that's coming out in a couple of weeks, but it's a condensed version of the Pandas course. It's the Python interview crash course. So that's for people interviewing in Python. That there's a crash course for that, really, really good, but it's kind of like a condensed version of the Pandas course. And then it's more focused on interviewing. That's what it's for. Then after that, a couple of weeks after that, the Excel course will come out. It's already being edited, it's being finalized, and then I'll put it up. And then right now I'm recording the Tableau course. Those courses will all be done in the next like couple months, and you'll have access to all of them with the Lifetime Bundle. And just so you guys know that 20% off, there's a 20% off, let's go look at it. Ba-bum, 20% off applies to anything, anything you purchase. So if you purchase the 349, 20% off, if you just do the questions, 20% off, yearly 20% off Lifetime for the questions. Now don't, if you're looking for the Lifetime Bundle for questions and courses, don't buy this one. This is only for the questions under the Questions tab. So if you just really like the questions, you wanna grind those out, that's how you learn best, you don't like courses, do that. But it's 20% off, and the courses. So be sure to use this when you check out, and it will work. You'll get 20% off anything you purchase. All right, let's go, I'm gonna stay over here just in case I wanna go back to it later. But let's go back, let me see real quick, if there's any other questions. Yes, Lifetime Bundle will give you access to everything, all courses, all questions in the future. And I just released the Pandas course like three days ago, and I just released several questions last week. And so I will be continually rolling them out. I wanna be a data analyst in SQL, should I learn MySQL or Microsoft SQL Server? The reason that I made a MySQL course is because one, it is very popular in the real world. Two, anybody can learn it. If you're on a Mac, if you're on a PC, yeah, PC, Microsoft SQL Server is specific. You can use it in ways on Macs, but it's harder to do. I recommend people learning MySQL first. If you get a job where you are using Microsoft SQL Server, you can pick it up pretty quick. If you already know MySQL, you can pick up SQL Server very quickly. Do you know that now the market has become more hard for entry-level positions? If so, how can we stand out? Well, right now the market's harder for everyone. Genuinely, this is not a reflection on entry-level jobs, genuinely. It is, even at the senior level, it's more difficult right now. More than anything, the reason is is because inflation is causing a lot of issues. And because of that and over hiring during the pandemic in 2020, 2021, they did layoffs. And so there's a lot of qualified people out there. So it's not just entry-level jobs that are, it's tough to find a job. It is across the board. Now this ebbs and flows, this is a natural progression. If you go and you start Googling this and looking at this, you will find that this is a natural progression of the job market. And right now we're just in like a slow season. Some people got, a lot of people got laid off in 2022 at the beginning. I think that near the end of 2022, I have talked to a lot of people. A lot of people think that 2024, the end of 2024, which is summer and on, is going to be a big hiring season for a lot of companies. And so that's kind of like where I'm looking at. I'm kind of keeping my tabs on and track of it so I can keep people up to date. But how to make yourself stand out, genuinely is, and I say the same things, but you'd be surprised how many people don't do it. The people who end up getting jobs are usually the people who do the exact steps that I recommend and they consistently do them. They don't just try it and then quit. They do it. Is one, you got to learn the skills. You have to know the skills. Two, create a really good resume. On my YouTube channel, I have a really great resume. We'll have a complete section on the platform for resumes, cover letters, all communities, all these things on the platform next year. But take that, go watch that video now. Make a great resume. Make a portfolio with projects. Have a really good resume. The resume is super important. Then start reaching out to recruiters and have recruiters reach out to you. So go on LinkedIn. I have a video how to get a job on LinkedIn. Use that video to reach out to recruiters and use it to understand how recruiters work and what they're looking for. Optimize your LinkedIn profile and work with recruiters to apply for jobs. I at one point when I was first starting out I was working with six or seven recruiters at a time. Now, when I say working with, they had my, I said, hey, I'm looking for an entry level job. Here's my experience, which wasn't much. And I was like, I would email them and they were like, okay, yeah, great. If anything comes across, we'll email you. I didn't want to just rely on them to email me. So every single week I had a list of people. I would email them once a week and I would call them once a week to say, hey, has anything come across your desk? And here's what I'm working on right now. And I just, I was relentless. And if you do that, you will be more successful than almost everybody else trying to apply right now. Cause most people applying are just creating a resume and applying on Indeed or LinkedIn. There are some people who are working with recruiters and then they reach out to the recruiters once and they hope that they'll reach out to them again. You need to be consistent and you need to really work hard. This is, this is, you know, but once you get that experience, it becomes a lot easier to get land the next job. But that is how you, that is how you set yourself apart. I see other questions. Let me see someone. As someone who became a manager, what is something you consistently saw in hopeful data analysts that you were looking to hire prevented you from continuing with their interview. Usually it was domain knowledge. So, and this isn't not every place, but when I was a manager, we were working with very specific types of data that required some domain knowledge. I couldn't hire someone if they didn't have it cause that would take way too long to catch them up to speed on the domain side of things. And so, if you know a little, when I was the manager I was working in IT, so that was cybersecurity data, ticket data, help request data, all these different things. Now, some of the cybersecurity data and all these other things were, you know, if you've never looked at it, it's extremely confusing. And so, that would have taken many months to get them up to speed, whereas if I hired someone who had the domain knowledge, I could teach them their tools cause we use proprietary, some proprietary tools, some Microsoft tools that no one else uses. And so, I wasn't worried as much about tools as I was. I needed someone who knew a little bit about IT, who had either worked in IT before or, you know, something like that. So, that's like something that pretty quickly, you know, I could tell if they knew some domain or not. Now, it was a big bonus if they already had some of the skills, a big bonus. But I kind of was willing to step that aside because we really need someone with the domain knowledge. Main difference to MySQL, Microsoft SQL Server is that Microsoft SQL Server is a paid service. They do have a free option, but Microsoft SQL Server is a paid service through Microsoft and they have something called T-SQL, Transact SQL, which has a few different features that MySQL does not have. I learned T-SQL for, I used T-SQL for years. I actually prefer it over the syntax and functionality of MySQL. I just think MySQL is better to learn at the beginning. Truly believe that. But MySQL is open source, it's created by Oracle, created by Oracle, so Oracle also has a paid version, but MySQL you can use as a full solution, but then you can buy their full solution for added features, of course. So that's really it. Oh, geez. Let me get rid of this. Yeah, I gotta hide that, sorry friend. That was too much, that was exhausting. Just looking at it. Will Google cert really help you get a job? Here's my take on the Google certification. It will help you, if you're a complete beginner, you've never watched my videos before taking my data analyst bootcamp. You're a complete beginner, just wanna understand like the basic concepts of data analysis, see if it's for you. That's what it's good for. And it teaches you some of the basic skills. My data analyst bootcamp on YouTube is better than the Google certification. It just is, because you learn way more skills, you learn a lot more things, goes more in depth. It's just way better. Then if you wanna go above my free data analyst bootcamp, then you have Analyst Builder, where you get to practice your skills, you get to practice technical questions, which you'll need to know for technical interviews when you're applying for jobs. And not only that, we have better courses than what's on my data analyst bootcamp. So it's kind of like a progression. If you're a super, super, super beginner, the data analyst bootcamp is great to kind of understand the concepts and the basics. My data analyst bootcamp on YouTube is way better than that and is free. So I highly recommend that. And then Analyst Builder is just its own beast. It's just amazing. It's like a lot of different platforms combined into one. And we have so many things planned for the future where it's gonna be even better. So if you're thinking about getting in like three months, if you're like, in six months, I wanna be a data analyst and I wanna start taking courses now. And then you'll grow if you buy like the lifetime, you're gonna grow and learn with as I release more courses like the Excel courses coming out soon. The Tableau will be coming out early next year. And of course then you can practice with these questions. Where was I? I gotta go back. We'll practice with these questions. Now let me put this in the chat again because now I'm gonna do a chat. I'll need chat GBT. There we go. Let's do current, let me say try this question with me. If you guys are just joining, I'm at my dad's school because my internet went out of my house and I didn't wanna cancel the live stream. So I'm doing this for you guys. I really am. I hope my wife, I have my wife's key. I hope she can get in the building when she comes. Whoops. I need to, I need to be on the lookout for her texts. Because I used her keys to get into the building. We're gonna do this question and then I'll answer more questions. I just put this in the chat, didn't I? I put this in the chat. There we go. I just put this in the chat and then I'll answer more questions after this. But this is our questions section. This is an easy question. And then we have other ones. But there's a bunch of free questions that you should try them out. Dr. O'Brien has seen an uptick in heart attacks for his patients over the past few months. He's been noticing some trends across his patients and wants to get ahead of things by reaching out to current patients who are at high risk of a heart attack. We need to identify which clients he needs to reach out to and provide that information to Dr. O'Brien. If a patient is over the age of 50, cholesterol level of 240 or over and a weight of 200 or greater, then they are at risk of having a heart attack. Write a query to retrieve those patients, include all columns in your output as cholesterol level is a large indicator, is the largest indicator, or do the output by cholesterol from highest to lowest so you can reach out to them first? There's a lot of talking, so I'm gonna get some water. Now I'm still trying to earn that MySQL badge. Remember you can try it in any of these variations in Python, MySQL, PostgreSQL or Microsoft SQL Server. I'll be doing Python later. Believe it or not, we've been going for almost three hours now. This live stream's been going for almost three hours. I am probably gonna go for another hour or so, maybe an hour or two. I wanna get that badge though, but we'll do this question. Maybe, I don't know, we'll see if I can get there. But you get points by completing questions or taking courses. If you take a full course, you earn 500 points, which is a lot. If you take questions, you earn a little out of time. Easy questions, 10 points, moderate, 25 points, hard, 75, or very hard, 100 points. Which I'm gonna change to 150. I've already decided. So let's go look at our data right here. So we have a patient ID, age, cholesterol and weight. And what we need to do is we're ready to retrieve these patients, include all columns in your outputs. That's really nice. But we need to order by that. So we have all these different things, different conditions that need to be met in order for it to be in our output. So let's come right down here. Let's say where. So what we need is where the age is, is over the age of 50. So we're gonna say where age is greater than 50. Doesn't say greater than equal to, right? So let's keep it like that. And cholesterol level of 240 or over. So now we have to do, let me copy this. I don't wanna misspell it. I'm bad at spelling. Where cholesterol is greater than or equal to, this says 240 or over. So greater than 240. And, cause we're doing and, this isn't just one. All these have to be true. And the weight of 200 or greater. So now we'll do a weight is greater than or equal to 200. Now let's run this and let's just check. So this guy's over 50, cholesterol is really high over 240 and the weight is over 200. So that meets and it looks like all the other ones meet. So we have five people, but we need to order by and we need to do that by cholesterol. So let's do cholesterol. It starts from highest to lowest. So if I do it just like this, cholesterol is gonna be lowest to highest cause it's automatically by default in ascending. But we need to put it as descending which is highest to lowest. So now we have our cholesterol, boom, boom, boom, boom, highest to lowest and let's see if I got this done. That should be it. So this is our answer. Let's go ahead and check our answer. And there we go. Our solution is correct. And let's go see, we got 210 points now. So we're working our way up. I'm going to choose a new question. Let's go back to our technical questions. These are all the free ones. We could do media addicts, separation, direct reports, bike price, senior citizen discount. Who divides us? These are all interesting. I'm trying to think of which one would be a good one to show. They're all really good. What's this tech layoffs? Okay, okay. Yeah, I don't wanna do that one. It's an interesting one, I don't wanna do that one. Let's do this bike price. Yeah, let's do the bike price. This is gonna be the next question. I'll share it in just a second. But let's see. How come my previous degree in manufacturing engineering in data analysis? Well, what was your, do you have any experience? I don't know much about that degree, to be honest. But what's your experience in? Was it, do you have any actual, in a certain domain where you were using that degree and now you're trying to transfer it over? So you probably have a lot of knowledge with that domain. Not a lot of questions. So if you have any questions, let me know. I'll try to answer them as I go. I know I was just showing you the platform, but just wanna say your system is awesome. Hacker Rank was used before, it doesn't go into Python, so it's nice to have a compare and contrast on how you'd solve the same question. Absolutely, absolutely agree. Really glad to hear that. So if there's any other questions, post them in here, I'll get to them in a little bit. I'm gonna post this question. I know I've been live streaming for three hours, guys. I'm still going strong. I'm gonna say try this question with me. Now let me make sure I'm still talking. My face was, oh yeah, I'm doing all right. I'm doing good. Let's see. Now real quick before I go to the next question, you can use a 20% off with the AB Live 23 code at checkout, be sure to do that. I don't want you to pay full price. I want you to use the 20% off, and that's for everything. So even with the lifetime bundle or the analyst builder, highly recommend, highly recommend picking something up. Now just note that the questions, these are only subscriptions or payments for the questions page. Courses will only be for the courses page. The bundles will be multiple courses for here for the analyst builder course bundle. The lifetime access will give you access to all the current courses and the current questions and all future courses and questions. So if you take 20% off of 30, that's like, say 275, you'll get my courses now that I have. You can start taking them. I'm gonna be releasing courses as I go. So the Excel course is gonna be done soon or it's already done but it's being edited. It'll be on the platform soon. Then I'll have my Tableau and then Azure and AWS and then my AI course all gonna be on here. So if you get that, you'll get access to all those future courses as well. Just wanted to note that. Now, let's take a look at this bike price. Now this is an intermediate one or a moderate one. So it's easy, medium, hard and very hard. This is an intermediate one. So a little bit harder than the previous one we just did. Now this question says Sarah's bike shop sells a lot of bikes and wants to know what the average sale price is of her bikes. She sometimes gives away a bike for free charity event and if she does, she leaves the price of the bike as blank but marks it as sold. So oh, she's super nice. So Sarah gives away to a charity. She marks it as sold but it's just left blank. She didn't make any money from it. Ready query to show her the average sale price of bikes for only bikes that were sold, not donated. Round the answer to two decimal places. This is a really interesting question. A little pat on the back, the old Alex here made a cool question. I like all the questions on here. I think they're all really, really unique. And then when I, and I haven't, you know, I did this a while back. So I haven't looked at this for like a month or two since we launched beta. I just remember there's a really cool question. So we have bike ID, the bike price and the bike sold. Now let's see. So this one was marked as sold, yes, but it's no, which means she donated this one. So we'll have to filter that out. And we're also looking for the average sale price of bikes for only bikes that were sold. So okay, let's start with this. Let's just take it step by step. Let's get rid of this. First, the bike has to be sold. So we're gonna say where bike underscore sold is equal to why? So let's start with that. So now all of these are yes, they've been sold but we need to filter out and this is not no. So we'll do and bike underscore price is not no. Let's run this. And there we go. Now we need to take the average bike price. Now let's see. Right here to show the average sale price of bikes for only bikes that were sold and not donated then rounded to two. So I think our output, and let's look, our output should be just a number. So let's see if we can get this. We'll do the average and then we're gonna do the average bike price with those conditions that we had. Let's run this. So we got 196.86, is that right? Oh it is, but we have to round it to two decimal places. So we'll do round and then we'll do comma two. So that'll go to two decimal places. Let's run this. So now our answer is 196.86 and 196.86. So when we submit this, there you go. Your solution is correct. Again, just a huge shout to the team for building this out. I'm just gonna give a huge shout to them. Kasun and I have been working together in his team. We've been working together for over a year on this. This all is like just, it's so good. It's so good. I'm so happy with how it turned out. It's better than my original plan, if I'm being honest. I was not a graphic designer. I was an ideas guy, but him and his team really helped make it happen. So I say that's our team, but he's like, I would say the head of the team. Let's see how I did it here. Okay, I did the exact same. Sometimes I have different answers for how I do it. Now, uh-oh, application error, what did I do? Whoa, whoa, whoa, whoa, whoa. Let me go back to that real quick. I think I just had an issue with it. What was that question? Not temperature fluctuations, heart attack risk. There was a bike one, right? Bike price. What was the issue? Uh-oh, hey Kasun, if you're looking at this, maybe it's a, I don't know what the issue would be for that, but Kasun, if you're here, just take a glance of that if you can. Everything else is working. I don't know, maybe the, we're using, we use Vimeo to host our videos. Maybe it's a Vimeo issue, but the video explanation should work for you guys, so go ahead and try that out. Let's see, so I got that one right. So there we go. Now, I'm coming back here. Do you need to take the advanced MySQL course to find an entry-level data analyst shop? No, I think I really do recommend taking this MySQL for data analytics. If you take this, and let's just click and do it real quick. You're gonna learn querying basics. And by the way, some of these you can take for free, like you can just kind of like see what it looks like, so you can go in here and look at it. And then if you click on one that doesn't have that, you won't be able to access it, it'll just prompt you to buy it. But it's gonna teach you all the like basics of querying, and then it goes much more in depth. So data types and functions, this is probably something that most people don't teach on data types and all these different functions that are really useful. String functions, date, and date format functions, if functions, case statements, cast and convert functions. But then you'll do group, buy, join, subqueries, window functions, regular expression, how to actually work with files and importing them and exporting them. Then a whole data cleaning section on how to clean your data. And then of course, full projects. So there's two, it's quote unquote for projects, but it's world life expectancy data cleaning project, then the world life expectancy exploratory data analysis. Same with US household income, same for that. And so if you just take this and you know everything in here and you really understand it, you're gonna be good. The advanced one I think is more for people who wanna go a little bit above and beyond, you're gonna learn CTEs. So this is kinda like the intro to more advanced, I would say, CTEs and temp tables. But then the more advanced things are like store procedures, how those work, how you can actually use store procedures to kind of automate things. Triggers and events, which is how you, if data comes into a table, you can trigger that data to trigger a store procedure or cause something to happen. Then we have indexing, so this is indexing. And then we have a full project. These are automated data cleaning. Now this is a short course, it's three hours and 30 minutes, which is why I priced it a lot lower. So if you come over here, this is the shortest course, it's the lowest price, not because it isn't valuable, just because it's a shorter course and I think because it's shorter, you shouldn't have to pay a lot more. But these other ones like, this is my sequel for data analytics, which is the one I recommend taking, I think that one's like 11 or 12 hours, yeah. But it says 11 hours, that's 11 hours of content to actually go through the course, practice everything, build all the projects, that's several days, right? Cause doing it and replicating it and actually learning it takes a lot longer. So, just take that into consideration. If you're doing two hours a day, let's just estimate, it's gonna take three days of actual work to get it done. That's 24, 24, jeez, what's 24 times three? This is bad, this is bad, 24 times three. And then let's say you do it for two hours, oops, two hours a day, which would be a lot, that'd take you like a month to do. And so this course is not something that you should fly through. There's a lot of content, especially when you get to like the projects and there's questions in here like bad bonuses. So there's questions in here too. These should take you time. You shouldn't just fly through it and like get the solution and get the answer. You need to learn, this is for learning. So that's the one I would recommend. That's the one I'd recommend. My volume is a little low, low for you? Oh jeez, I wanna get it close to my face. Kasun, how does it look? How is it sounding better? It's too low for me. I gotta lift this up, is that better? Let me, that should be good, that should be good. Sorry if the volume is a little low. How do you use regex functions in SQL? Well, take the course, it's in there. It's in there. Have you encountered anyone that has gained analytical skills but has not jumped fully into the data analytics career path? I am mid-career as a project manager and I hope that makes sense, absolutely. In fact, I get a lot of messages from different people who I wouldn't expect. So like my Excel for data analysis stuff on YouTube, I get a lot of accountants who take that. I get a lot of project managers who take that. What did you say you were? You're a product manager? So yeah, product management, program managers, data scientists, different roles in the data space who will take it. They're just like, I just need to learn how to use Excel and kind of analyze some data and they take it. Same thing for different roles. Like if you are working on a team that uses SQL, you should know how to use a bit of SQL to understand like how long things might take or understanding their problems so they can better help them, genuinely. Mamoon said this is the best time-saving course to be a data analyst. I'm not gonna lie, this is probably one of the, these courses are some of the best courses that I've seen out there. I didn't wanna make a course that was just like somewhere in the middle and then try to sell it. I genuinely tried to make the best course that you can find online, whether it's Udemy, Coursera, a different course platform. I tried to make the best that I can make better than other platforms and then I launched it, right? And so genuinely, I think that my SQL course, if you take that, you are gonna be genuinely really good at, you're really gonna understand what you're doing after it. And that's why the practice questions are in there too. Like throughout the course, you have all these different, there's 17 questions in the course. So as you're going through and you're doing data type functions, here's numeric data types. Then you have to do profit margins where you have to use those numeric data types or string functions or gamer tags. And just, you know, maybe I'm not saying it well. I force you, if you wanna complete the course, I force you to have to practice it. So I say, okay, if you want to use this, you have to know how to use this date and date format functions. You just have to, that's part of it. There you go. I'm also noticing that those gamer tags should be above this date and date format. I'll have to fix that later on. I won't fix it now, because I don't wanna go into the admin panel. But yeah, I mean, it's just, I don't know. I really, really, really, really, really put a lot of effort into this to make it really good. How much SQL should you know for entry level job? Everything in that MySQL for data analytics course. That's what I would take. Everything in that course. How much Python do I need to take the pandas course? That's a good question. I think you need to know up to like, just understanding, probably like data types and for loops. I think would be enough. The pandas course you could take, just straight out the gate. It would just be kind of tough to keep up, because you do, there's some Python stuff in there that I don't really dive into, because it's in the Python for beginners course. So, all that being said. Let me see, did I miss any? Like you said, it's learning and applying. Absolutely, I'm a firm believer that you need to learn it and then apply it through either projects or practice. And I do both in the courses. And I just think they're really great courses. How do you know that your course is better than others? Have you watched other courses before creating yours? Well, I was once not a data analyst. I was once a recreational therapist. And in order to become a data analyst, I took a lot of courses. If you go on my YouTube channel, going back three, four years, I have videos on best Udemy courses that I have taken, best Coursera courses that I have taken, different platforms that I've used. So for the past six years, I've taken courses on all these different things. And so because of that, I've taken, I took so many SQL courses, so many, because I just need to know it in my job. Because of that, I have a really good idea of what a good course should look like and what it should include in a lot that, and I've taken a lot that don't include some of these things. So I condensed all of my experience from the past seven years as being a data analyst and analytics manager, using these tools, and I condensed it and really dived into how it's applicable to you as a data analyst. And I walked through my thought process, I go really in depth, and then there's questions and courses, which is really good, just really good. So that's kind of how it's better. It just, if you were to take almost any other MySQL course, and then you forgot everything and then took my course, and then you somehow were able to compare, you'd be like, I think most people would be like, this was a better course. I genuinely believe that. Can a fresher become a data analyst? Yes. Wayne said, hello, Alex, thank you for creating the Analyst Builder. Are the achievements on the platform uploadable to LinkedIn? My name is pronounced one day. Hey, one day. Yes. So right now, I haven't, on this, I created a new, whoops. I created a new, you can also make it dark themed in the courses, but I created a new account here. So I haven't completed, let me go back, I'm gonna go to my dashboard. I haven't completed any of these courses, but once you complete the course, you can come over to completed and download your certificate. And it's custom to use, you can change your name if you need to, but you can download it and you can upload that directly as like a, directly as a picture. So you can download as a PDF or a PNG or you can actually, this becomes your public profile. So then when you earn a certificate, it comes right down here and you can share this link with LinkedIn or X or Twitter or anywhere you want. And then people can actually come here and they can say, oh, you know, he's got this badge in my sequel or this in Python. It's just fun to share. I wouldn't say this is like the end all be all of creating a portfolio or anything like that, but soon we'll have, you know, in the future, we'll have a place where you can upload your resume where you could share this, you know, and I think that's gonna be really, really neat. But I've only worked on my sequel on this one. If I went to my other profile, you'd see I was like a MySQL master. So I got that badge on my other profile because it's just really fun. And we'll be adding leaderboards and all sorts of other things. But these badges right now are not shareable because this is just a logo. But in the future we'll have a share button where you can share and download your badge just like you can a certificate, but the badge is gonna look super cool. It's like a really unique design and it looks really neat. It has the logo and your rank. And, you know, it's gonna say like, you know, you're a MySQL master or whatever rank you have, that'll be really fun. So that'll be really, really neat. Let me see if there's any other, oh, a bunch more questions just came in. Will it be a separate course or just more projects to help build one's portfolio? I do plan on having some, because I have a video on my YouTube channel on how to make a portfolio for free, add projects to it. I do think I need to add something specific to Analyst Builder and how to build that. So I will probably do that. And it'll probably be free. That video or that course or whatever I make, I'll be free on how to create a portfolio. You know, and not everything is gonna be paid on the platform. It says, I have a great passion for data analytics, but unfortunately in, I'm guessing in your country, Aria, or Aria, it isn't a common job, only two, three big companies hire analysts. Well, you know, these skills, and that's 100% true. There are some countries that don't hire as much, but here's what I will say, you know, especially in Europe, and then especially in the United States, and then, you know, certain parts of Asia hire a lot of data analysts. And so a lot of people will work remote and try to get those, or they'll try to get a visa to come to those locations to get those jobs. But I have found that a lot of people have been messaging me saying, hey, I got this job, which is the equivalent of something like a data analyst at this company. And they're like, there weren't a lot of data analyst jobs in my country, but they're like, at this company, I was able to use these skills to get this job, which is very similar. And so maybe it's not a data analyst role. Maybe it's called something different, or you can use these skills because companies are gonna use these skills. These skills are very transferable. So maybe for a different position, right? Can I use these questions as inspiration to do a project? Are the final projects of each course similar to those questions? The questions are like practice questions. They're not usually projects, but you can absolutely use them as inspiration. If you find a question that you're like, this is really neat or unique, by all means, try to create a project out of that. I think that'd be super cool. The final projects of the course are similar to the questions. No, the final projects are like real projects. Real data that I got from lots of different places, like gov.com, nasa.com, real places with real data, right? So the projects are like more realistic with realistic data cleaning and realistic stuff. Is Bessell and Sequel like this while practicing if it will make you a master sequel as a beginner in no time? Genuinely, I think Sequel can be mastered within like two months. Mastered is in like, you can get a job with it really confidently. I think you can learn the basics of Sequel in like a couple days. Then of course, the tougher stuff like Joins takes a little while to get used to and all the stuff in the course is like, it just takes time to get used to it. But then to reach like, you have to really know the skills well to get really good at it. There's a high, high, high skill cap for these skills. Does taking multiple courses, Sequel, does it help anyway? Most of the contents are the same, right? Have you done in your past journey? Well, I've taken a lot of different Sequel courses because one I was taking, at the beginning I was taking my Sequel courses when I didn't have a job yet that used Sequel. Then when I got a job using Sequel, they used Microsoft Sequel Server. So then I went and found a whole course just on Microsoft Sequel Server. Then I got another job and they used Microsoft Sequel Server and my Sequel. So then I had to go back and take a my Sequel and then I just wanted to improve my skills so I took multiple more after that. They all have a different variation, a different flavor. If I knew it already, I'd kind of skip over it. I'm like, okay, I really know aggregations in Group By, let me skip that section. But you can learn, I mean, if you take this course now and you learn from it, then in a couple, you build a project, you come back to it later in like a month or two, you'll learn something new because now you know more. So I'm a person that I like to take things multiple times and that's why it's a one-time payment on the courses because I want you guys to be able to just come back, take the course multiple times so you can learn from it repeatedly. That is kind of the thought process behind that. Hugh said, I just bought the Lifetime Bundle. Hopefully there are a lot of jobs in Vancouver. Absolutely agree. I've heard the Canadian job market is actually pretty good. I mentored a guy about two years ago who moved from Vancouver to Minnesota for a data analyst job, which was really neat. Just looking at my phone. My wife said she was gonna bring me food sometime. That was really sweet of her. I have no idea when she'll be here. There's a cool video of it in Analyst Builder Discord if you want to showcase the certificates and stuff. That is true. Is there any alternative for Python libraries for visualizations or huge data frame? Yes. Well, yes and no. Let me actually go over there. In the Pandas course, there is an introduction to Polars. Now Polars is kind of a smaller, niche library, but it's gaining popularity. Pandas is like one that everyone uses. That's why I created a course on it. But I even included in this course an introduction of Polars because I think that Polars is gonna be the future in five years. So I'll be creating a Polars course in the future because Polars is another data frame but it's built specifically for giant data frames. Now, there are tools that I have used in the past in my real work and that people have sent to me. There are tools where you can you can have Pandas work with super large data frames really quickly. Maybe it uses like a Rust backend or uses GPUs or CPUs to enhance the processing speed or something like that, right? There's a lot of different options. But Polars is a built-in library that's made specifically for very large data frames and it's based upon Pandas. So the very similar, it's not the same. If you go in there, I just talk about what Polars is, how it works and then I walk through Polars basics. Just an introduction to it, right? But Polars, I would look into that one. That's what I'd look into. Could your courses replace Google's certificate? My courses genuinely are much, in my opinion, are better than the Google's certificate. I was talking about this earlier. The Google certificate is for people who are just learning what data analytics is. So what is data analytics? How does it work? How do companies use it? They teach you the very, very, very basics of a few couple skills, which are good skills but then you get it and you're like, I'm not job ready. Then you go and take my data analyst boot camp for free on YouTube and you learn a ton from that. 10 times more than the Google data analytics certificate. I promise and it's free. Then you're like, okay, I know all these skills. I wanna dive even more and I wanna get ready for my technical interviews when I start interviewing. That's when you'll come over to Analyst Builder. So then you come over here, you practice these technical interviews to get ready for your technical interviews. You take these courses and these courses go more in depth into these skills. So if you're trying to learn Python or trying to learn pandas or MySQL and then soon to be Excel and Tableau and all these courses are coming soon. Then you learn these a lot more in-depth and you get better projects. So it's kind of like a progression, you know? And I just think the Google data analytics certificate today, when it first came out, it was really novel. It was like, Google's coming out with it. And even I reviewed it and I was like, this is really neat, it's a good introduction. But now where other things are out, like my free bootcamp, my free bootcamp is way better and it's free. I don't recommend buying the Google certification anymore. I just don't think it's worth it. Unless you're a complete, complete, complete beginner and just wanna know what's more about, my bootcamp kind of dives more into the skill-based, whereas Google goes more into the theory, if that makes sense. Let's see. You have any courses to recommend for a beginner in data analysis? Take the MySQL for data analytics course on Analyst Builder. This is recorded. This is, although I don't know how many people will watch it. This is gonna be like a five-hour live stream. So I don't know. I don't know how many people are gonna watch it afterwards. Let's see. Alex, I've been out of corporate for a year. I'm currently teaching, but I would like to go back to corporate, but I wanna know if you can add this to your experience in my CV and take some courses to add on my CV. What's, you mean like corporate data analytics or were you like corporate as in like a vice president or CEO of something? But then in the comments below a second, I can figure that out. What about NoSQL? Do you think it's demand growth? Ivy is NoSQL. NoSQL is really neat, but is definitely not as popular as SQL. Not even remotely. Like NoSQL is like 5% of the market, whereas SQL is like 90% of data analyst jobs have some variation or use of SQL. So no, NoSQL is pretty niche, but I used it in my last job, which was really neat. Thank you, Milton. That's what I need to hear. I took Coursera's Google Data Analytics course. Alex's program is far more thorough. I agree, and I appreciate the feedback. Could you please give us some tips or prepare a course on how to prepare for job interviews as a data analyst? Wait a second. I have my MySQL interview crash course, which is gonna help you prepare for interviews. But specifically on the skill side, but I think, okay, I see what you mean. Maybe just like an interview course. I might make that one and make that free, because that's one that I think everyone should just take and just have access to. But if you're looking specifically for the MySQL interview crash course to get ready for technical interviews, take this. I'm also gonna have kind of a subset of this one, which will be Python interview crash course. So it's just gonna come out in just a couple of weeks, and then the Excel one after that. But see how I'm looking up here. I look weird. I look weird as this webcam. I'm not a fan of it. Wish I had my setup. I'm not home if you're just joining. I'm not home right now because my internet went out and I didn't wanna cancel the live stream. So I'm up at my dad's school. Not ideal was not where I wanted to be. All right, let's go back, see if there's any more questions I'll do. I'll do another question. I really hope to gain one course of the giveaway. Sounds really good. Yes, I'll be doing another giveaway probably after the next question. I already gave away two courses and I'll be giving away another two courses. And at the very end of the live stream, I'll be giving one person the Analyst Builder course bundle, which will give them access to all five courses that are on here right now forever. And so I'll be giving that away at the end, at the end or near the end of the live stream, which was probably gonna be in like 45 minutes. I've been going since 9.30. I've been doing this for like three and a half hours now. Okay, my wife is heading to get me a sandwich. But now I'm nearing the end of the live stream. I don't know how much the long girl will go. We'll see. She might get here right near the end and then she can choose the winner. Whoa. Let's see. So does your course make a beginner job ready? I mean, the market is really tough for beginners. So how can your course make a beginner different from others in order to land a job? I think, well, one, you need to know the skills well to get a job right. I've always talked about you need to learn the skills well. So the courses really help you learn the skills. For applying for jobs, what is an extra part on top of your resume is you can have a project section and I have free projects on my YouTube channel. Recommend doing those. I think the projects in my courses are better. And so you can add those projects to your portfolio and a portfolio website. Excuse me. When you get into interviews, you can then point to those projects and be like, I built this project in SQL. Here's what I did. Here's how I used it. That goes a long way. I've talked a lot about that on my channel about not just when somebody asks, they use SQL in their job. You know they use SQL. You go into the interview and they're like, hey, how have you used SQL? Or how much do you know about SQL? And you're just like, well, I took a course. Well, you need to be able to point to something. Like, oh, I've used SQL to do data cleaning and data exploration. I'm really comfortable using joins and Windows functions and CTEs. And those are all things in the course. So it's good to point to them and just have you ready to do. But honestly, a lot of part of getting the job is after you learn all the skills, you need to know how to apply for jobs, which is where working with a recruiter, knowing how to use LinkedIn, knowing how to apply, like those things are really important. So, you know, this is like the learning phase, but landing the job is also an independent phase of, and I'm gonna have a whole section on the platform to help people land jobs in the future. But it's just not, you know, we're still, this is like, we just finished the beta launch a month ago. So, you know, in the several months, we'll have a lot more things on the platform. Um, do a master's degree help? Yeah, sure. I'm sure it would, depends on what it is. Right. But let me see. She am, sorry. Yeah, I'm just showing the platform. We're just hanging out. We're doing the full launch today, which I'm super proud of. You can go on the platform, you can get 20% off using this code. And I'm just showing off the platform to people who've never seen it before. I'm gonna also have a full video tomorrow about the platform. So that'll be like an actual YouTube video. And yeah, today's just a week for Analyst Builder to kind of do a harder launch because we did a soft launch with the beta. Had people tested out, fixed a lot of things, but now things are looking really good. We're starting to add new features like the point systems and the certificates and adding more courses. I just added the, I just added this pandas course like two days ago. So, you know, and I added new questions too. So, you know, we're kind of like, we're rocking and rolling now, I think is where it's gonna really take off because it took like a year to get to the beta. But now we're here, now we just get to build on top of our existing architecture and we can add so many new things. And we're hiring more people onto the team to add and push, I feel like a startup because we push so much stuff to production so quickly. It feels like a startup environment. It's been really, really fun. Let's see. Purchasing power parity pricing? Yes, based off location. I do plan on doing that in the future. We're trying to figure out how to do that with our current architecture with Stripe and then on the backend when you purchase something. So, we're trying to figure that out. I used to work as a data analyst, but now I'm teaching now, okay. I'm ready to start my career again as a data analyst. Okay, I see what you're saying. So, you went from data analyst to teacher and you wanna go back. I think being a teacher can, genuinely, it could be really neat. Although someone might ask you why you switched to teaching, but I think teaching, I've told a lot of teachers, like teaching is a really good skill to kind of go into to have because you have to have really good communication skills, really good soft skills and the ability to present information well. So, you can really lean into that if you want to. But since you already have data analyst experience, you could leave it off your resume and still be fine. You couldn't. Let's see. I'm getting to the last interview, but so far I'm not chosen. I think a motivational course would be great. Hey, man, I can be super motivational. I thought about making like a video about that. I'm just like motivating people. I love motivating people. I really do. It's definitely a passion of mine. A master doesn't feel like GIS, not specifically Python or SQL, et cetera. Yeah, could be, could definitely be helpful. Could definitely be helpful. I just, I, it's hard to say, right? It's hard to say exactly what field you want to go into or what you want to do, but a master's can definitely be helpful, for sure. Now I'm going to go back real quick. We already solved this one, didn't we? Yeah, we already solved this one. I'm not going into this one again. All right, I have this on free. If you haven't already, check out these free questions you can take them for free. All you have to do is have an account. My wife has a sandwich, she's buying a sandwich for me, but she doesn't have the key to get into the building. So in like one minute, I may, a few minutes, I may have to like sprint downstairs, open the door. She'll come up and then I'll, I'll come back up really, really quickly. Let's do that last hard question. So I'm going to filter on incompleted ones. I'm going to go down and find that hard one. Here's Kelly's third purchase. All right, let's get ready, because this is another hard one. So I've solved two hard ones already. This is the third free hard one, that I believe is the last one. Let's see how we can solve this. Kelly's third purchase. This says at Kelly's ice cream shop, Kelly gives a 33% discount on each customer's third purchase. Write a query to select the third transaction for each customer that received this discount. Output the customer ID, transaction ID amount and the amount after the discount as discounted amount. Order the output on customer ID in ascending order. Note, transaction IDs occur sequentially. The lowest transaction ID is the earliest ID. That's important. I'm glad whoever wrote this, aka me. I'm glad they added that because that is important. Now let's go look. So we have customer IDs and we have the transaction ID and then we have the amount here. So we need to, the first thing we need to do is identify, well, there's actually multiple things we need to do. Here, let me post this question real quick if you wanna try this with me. Try this question with me. There we go. What's this ID plan to bring over all the free training on YouTube as an intro course and analyst builder? No, that's just gonna be on my YouTube channel. This is gonna be all content that is mostly gonna be premium, more in-depth content on here. The YouTube stuff is just gonna stay on YouTube. It's not, and I'm gonna keep adding to it. I'm not, I don't plan on not doing it. My wife's texting me. Give me one sec. Yeah, I'll probably go to two o'clock. She said she's gonna be here in like 30 minutes. I thought she was close, but she's like, just leaving the house. She has to go get the sandwich at them, so I got plenty of time. But in just a second, after we finish this, did I say that earlier? After we finish this question, I'll be doing a giveaway of two courses, and then near the end of the live stream in about one hour, I'll be giving away this analyst builder course bundle, where you can get all five of the current courses that are on the platform. So one lucky person. So let's come over here. So what we need to do is figure out the third transaction for each customer. Now, I already can tell, because we're gonna need to figure out the third transaction, we'll have to use some type of Windows function. Since it's sequential and all transaction IDs should be the same, we most likely can use row number. We could use rank or dense rank as well. Honestly, I believe any of those will work, but we'll just use row number to keep it simple, keep it the most straightforward, I think. So here's what we're gonna do. We need to add to this. We need to order this on customer ID. And based off of the customer ID, we have to order on the transaction ID as well, because the transaction ID is sequential, right? So the lowest transaction ID is the earliest ID. Then we do the earliest, second earliest, third earliest, that's the third transaction. That's what they should be getting the discount on. So let's see how we can write this. Let's try row underscore number. We're gonna do the row number on, I don't think we need to do it on anything. We're gonna do it over. Let me see. We're walking through this problem together. Now, this is a hard problem. Then remember, this is a hard one. So we're gonna do row number over, I think we just need to do order by, let's do customer ID, comma, transaction ID. Let's run this. Okay, so let's take a look. So we have a customer ID of 1001. Then this is the lowest to the highest. So this is the third transaction right here. And let's just confirm. Let's just confirm this. So this person had five transactions. So then we have two, two, two is the same person. Then this is in order. And uh-oh, that's not it. Because I need to partition this. Because right now I'm just doing it on customer ID and transaction ID, but the row number is being applied to all of them. So I have to partition this. So I need to say partition by, and we wanna partition it by each customer. Because we have to separate up for each customer's transactions. So the customer ID, let's go right here. And when we run this, this number is gonna reset. It's gonna go one, two, three, four, five. Then at the next customer, it resets. One, two, three, four. One, two, three, one, two, three, four, five. One, two, three, four, five. So now we need to select just this third purchase. Let me make sure. And then we need the discounted amount, okay? So I can do this in a few different ways. I can do this as a subquery, and if you weren't watching the previous stream, I'd been using CTEs and two separate problems. I'm gonna use a subquery just to change up a little bit. We can use this in the from statement. So, or yeah, from clause or from statement, I can't remember. But we need to label this. So I'm gonna label this. The table name can be as, we're gonna call this. I'm gonna label this too as purchase num. There we go. Spelling issues. So we'll do this as purchases. We'll just do that. So select everything from this as purchases. And what we can do is we can then filter on this. Now, let me go back just a second because if we're gonna use this as a learning opportunity, I'm gonna do that. So if we run it just like this, we can't then come in here and say where, and then we'll label this, I'm gonna say as purchase num. We cannot say where purchase num is equal to three. I just can't say it. And what if I do having? Can't do that either. So we cannot filter on this just within that query. That's why we're doing what we're doing, which is we're making this as a subquery. So we're saying from all of this, we'll do select everything and we'll run it. And what do I do wrong here? Oh, I gotta label this. So I'll call this purchases and we're just renaming, because this is the purchases table and so we're just kind of renaming it. But I could call this purchases underscore numbered. You do that too. So now we have this data, but now it's in like this subquery, which is kind of like a little temporary table that we're just querying off of. So now we can come in here and say where the purchase num is equal to three. And now we can filter it down. So now we have all their third purchases. Now the last thing we need to do, so we need purchase ID, transaction ID, amounts and the amount after discount. So we need to figure out these first or we have to get these first. So we have to get customer underscore ID, then we need the transaction ID, then we need amount and we're not gonna keep this purchase num in our output. We're just filtering on it. But now we need the discounted amount. So I'm gonna say as discounted amount because that's gonna be the name of our column. What we need to do is we need to calculate the discount. It says that she gives a 33% discount on their third purchase. This is their third purchase. So we need to do this and give them a 33% discount. So we have to take the amount and multiply it times a 33% discount to give you a calculator view of it. If we have, let's say $100, if we multiply it times 0.33, which is 33%, that gives us what their discount is going to be. That doesn't give us the discounted amount. What we, because the final price should be $77, right? So what we need to do is 100 times 0.67. And I didn't do that right. Give me a sec. 100 times 0.67. So that's gonna give us $67. Is that correct? 67 to 33? That should be correct. I think before I said 73 or something random. Yeah, it should be $67. So that's the discounted price. So if it originally cost 100, we gave a 33% discount, our final price is 67. So what we need to do is we need to do the amount, which is this amount right here, times 0.67. And let's run this. So now here's our amount and then here's our discounted amount. And we also need to do one other thing because we're really close. We just need to order the output on customer ID in ascending order. So we'll do order by, and we'll do, and I need to spell that right, order by, and I'll just copy this, customer ID in ascending order. Let's run this. This should be our final output. I'm not even gonna check the expected output. I'm not even gonna look at the hints. Let's just try it. And there we go. We got the correct solution. We nailed it. Let's see how I solved this before or how I tell people to solve it. Yeah, essentially the same thing. So we use this row number and we partitioned by the customer ID and then we ordered by the transaction ID. Now, I ordered by the customer ID and transaction ID but you don't need to it looks like but I think it's better to do it. So maybe I wanna update that answer a little bit but then then we put it in a sub query and then we filtered on it. So that's exactly how I would do it. And then we got it right and because of that we should be closer in our rank. Now we have 320 points, we're almost to 500. I think those are all the free questions of that are hard. So I may not be able to, I may need to do a bunch of moderate questions. Yeah, we'll see, we'll see. But all right, let's see. Alex, your webcam is stuck. Yeah, I believe that. Let me go over here. I'm using public wifi. Let me activate it. Oh, is it working now? Oh, what am I doing, maybe it's this. Give me a sec. I'm not at home because my internet went out at home and it was really unfortunate, really unfortunate. There we am. All right, I'm back. Thanks for telling me. Seems like rank should be used here. Well, you could use row number, rank or dense rank because there's no duplicates in the transaction ID. And let me go back. Actually, let me go to the data. Because there's gonna be no duplicates in the transaction ID, it doesn't actually matter. Because if you use rank or use dense rank, it's gonna look like one, two, three, four, five anyways because there's no duplicates. Rank and dense rank only are useful when you have duplicate, you have non-unique numbers in a specific column. That's the only time where they're needed. So yeah, you don't need to use rank or dense rank, although you could, you just don't have to. You just don't have to. Setting up my phone for when my wife gets here. Let's see. See, am I better now? Yeah, now I'm moving. I appreciate you telling me about those, that is by the way. Hey, Alex, is the lifetime purchase also part of that 20% discount? Yes, it is. It absolutely is. So you come over here, you can apply this discount to anything in here, any single thing you want, and it will work. So yes, it applies to the lifetime access as well. The SQL course on Analyst Builder is more in depth. Yes, it is. Oh, who was asking? I must have missed it. Do you plan to bring over? Oh, never mind. Let's see. Where you have, where purchase num is equal to three, could you put where purchase num is divisible by three, in case someone has multiple purchase, which are multiple three? That's not what the question says. It just says that it says, select the third transaction for each customer, because on each customer's third purchase. So it doesn't say third, sixth, ninth. That's actually a really good thought if it was every third purchase, but it says only the third purchase. So the wording is just a little bit different, but that's actually a really good thought. So if it's divisible by three, so if it was three, six, nine, 12, 15, 18, that's actually really, that's a good note. So yeah, really interesting. So all right guys, I just finished that question. It is time for another giveaway. I'm gonna be giving away two courses. Now, you can choose any course you want. You can choose this one, this one, this one, or this one, whichever one you'd like, and I will send you a code to get it for free. Now, how this is gonna work is I'm gonna tell you to put something in here, and I'll type it in in just a second. And someone who puts that in there, I will choose them. Now, I do this based on the Honor system, and if I choose you, just send me an email to alextheanalystyt at gmail.com, and I will give you that free course. It is not, the Analyst Builder is cool. Nice try, are you? I'm sorry, it is not that one. It is a new one. All right, I'm typing the code to do in here. I'm gonna wait just a second. The code is AB for life, AB for life. That's Analyst Builder for life because nothing's better than Analyst Builder. I was going somewhere else with that, but then I just stuck with it. But it is Analyst Builder for life. Type that in the chat. I will choose someone in just a little bit. I'll choose two people to get two courses. Are there any available positions in Analyst Builder? No, not right now, although I do consulting, and I've been really considering bringing someone on. Can I do it all myself? So I've really considered bringing it on for just to expand the business. All right, I'm gonna choose two people. Josh Kitchen, if you don't know what this means, that means he supports me on YouTube. He hit that join button. He just did it out of the kindness of his heart. There was no obligation to do it. So Josh Kitchen, I'm giving back. All right, Josh, shoot me an email. I will get you a course of your choice for free. Just tell me which one you want. I'll send you a code. Now I got one more person. Let's see who I see in here. Let's see, Alina Avalos. Avina Alina Avalos. You are a second winner, actually our fourth winner because we've given right four. Now listen, in about when my wife gets here, that's what I'm gonna say. When my wife gets here, I will be giving away the bundle, okay? So stick around for that if you wanna win that. But both you guys shoot me an email and I will get you that course on her system, guys. Okay, it's all about kindness and love around here. Now in just a little bit, I'll be doing one more giveaway where I will be giving away this bundle right here, the Analyst Builder course bundle where you get all five of the courses on this page, which is SQL, Python, MySQL, Pandas, Advanced and a Crash Course. So one person will win that in a little bit. And I plan on doing more giveaways in the future. I love doing giveaways, especially because we're at 642,000 subscribers. When we get to 750, I'm probably gonna do a big giveaway then of some of the lifetime plans. So just be aware that I'm gonna be doing that in the future. I do plan on doing some big giveaways, milestones or milestones for Analyst Builder as well. Absolutely. Now let's go back real quick. Here's the incomplete. These are the free ones that we haven't completed yet. Now let's see what we have. Okay, we still have quite a few, but we did all the hard ones. Now I did those hard ones because they were free and then you can try them. But if we come over here to the hard ones, there's a ton of hard ones. So if you get a subscription or you pay for the lifetime or go to pricing and you look at that, you can get access to all these ones. And these are really neat ones, really, really cool one. I like this unfair taxation one. I think that one's really neat. And then Janine, this is one I was showing you earlier. This is one where it's like data cleaning, where the data's bad and this column, you have to clean it. I'd really tried my best to make these really fun and just like really interesting. I genuinely think that these are just like so fun to do. That's why I like doing them right now. So let's go back to the free ones. Excuse me, my nose is itching. And let's choose one in here. I want to choose another one. I'm gonna do some moderate ones. I really do, because I wanna get to that next rank. I don't know if I'm gonna have enough time. I talk too much. LinkedIn famous, who divides us? What's this one? Okay, okay. Yeah, maybe I'll do this one. Because we haven't done one with Group Buy yet that I've demonstrated to you guys, but there's lots of questions in here with Group Buy. Let me put this question in the chat. Yeah, congrats winners. Thank you one day. Just got to hear how much I lost on the giveaway. We just gave away four courses in the past. I've been doing this live stream for four hours. But I'm gonna be doing one more giveaway where I give away this Analyst Builder course bundle of five courses. So let's see. I'll do this question once I answer a few more questions. So is this like a better version of your data analyst bootcamp on YouTube? Yes. It goes more in, well, let me take a step back. The courses are kind of like the data analyst bootcamp, but these go a lot more in depth and there's questions built in. So like let's go to this. This is a pandas for data analysis. Let's go down to filtering and ordering. So there's questions built in. So you're gonna learn about string methods and you'll learn how that works, what they are. And then you'll have to apply it in a question and you cannot go, well, you can move on. You could skip it if you want, but you can't, to finish the course, you have to do these questions. And so it's built in, which is really neat, but then the projects themselves are like really, really, really good projects. They're more in depth, more kind of, I would say slightly more advanced projects. This one's the movie genre data analysis project. And then we have the food marketing data analysis project. This one is like, this one is my favorite project I may have ever built. I think it was just super, super, super unique and really cool. I think you should add it to your portfolio. I give you the CSV. I give you a PDF kind of describing what it is. And then a data dictionary for it. One of my favorite projects, how long is this, an hour and a half? That's a long project, but it was a good project. Those are my favorites. So that's what the courses are. But something that obviously my YouTube channel doesn't have is there's a coding section where you can practice for technical interviews. My itch is, my lip is really itchy right now. I apologize. So you can come in here and you can practice for your technical interviews. So when you start applying for jobs for everyone out there when you start applying for jobs you're going to get technical interviews. And a lot of them are going to be in SQL or Python the vast majority, most of them being SQL. And so this allows you to come in and practice some of the questions that you'll probably like the types of questions that you'll get asked. If you aren't interested in that this is still a great way to learn. So you can just come in here and practice MySQL, PostgreSQL, Microsoft SQL Server whichever flavor or Python and we'll be adding more flavors as it goes on. Like R and a few others that I don't, I'm not, we have to figure make sure we can integrate it into the system. So I'm not going to, you know start talking about other ones that we have planned but we'll integrate R and then hopefully some other ones as well. Let's see, on media addicts but this whole section is nothing that like what I have on YouTube. And so this is just like a really great resource and way to learn and practice for your technical interviews. Apart from this coming, you know next year we'll have a lot of new features and functionalities. We'll have a project section where there'll be full length projects. We'll have a resources section where we'll have all sorts of different resources like resume templates and communities and all sorts of different things. So, you know, this plot this is like the most the minimum viable products and MVP but now we're going to be building it into a huge, huge thing. It's just going to be amazing. It's going to be amazing. Now I'm going to answer this question and then I'll come back. Actually, let me see if anyone else was asking questions. The volume may be a bit soft and I'm really, I really do apologize for it. Hey, congratulations, Alina. You are most welcome. Thank you for being part of the live stream and thank you for checking out Analyst Builder. I'm really excited to hear your feedback. Just shoot me an email and I'll send you a code for it. Does Python and SQL enough to be a data scientist? Depends, you need to know certain things within them. It's like with Python, you'll need to know certain, you know, machine learning concepts and models and stuff like that. Let's see. It's a marathon stream. Yes, I've been going for over like almost four hours. Oh, four hours now. It's a long one. When do you subqueries? Subqueries, you could use subqueries. You can use a lot of different things. It's very dependent on the query. You can use a lot of different things in a lot of different places, but subqueries are good for, we need to look at like a small portion of a table. You don't want the whole table, you just want a portion of the table. There you go. Anyways, let's keep going. In just a little bit, my wife's such as bringing me food, which is extremely sweet of her. And when she does, I'm going to have to run downstairs, let her in, because I'm not at home, if you guys didn't notice. I'm not at home because my internet went out of my house. So I'm at my dad's school in a random room. That's exactly what happened, but I'm in a random room. And so I thanks dad for letting me in the building. So I'm gonna do this question. I might do one or two. I was trying to get, by the way, trying to get to the second rank. So as you learn these skills, you earn points and you can rank up. I've just been talking a lot during this. I've done several questions, but you earn less points for easy questions and medium questions. The hard and the very hard, you earn a lot of points, but you also learn a lot of points by taking a course. If you take a course, you earn 500 points. If you take a crash course, you earn 250 points. And so you can rank up in your skill. Now you can also earn certificates and put them here. This page is shareable. So this page you can share and you can write something in here. Let me do that real quick because I haven't done that. Go to settings. Here we go, wait, here we go. I'm a data analyst, YouTuber who loves analyst builder. I'm just saying things. I'm gonna save that. And then if I go back to my profile, it's right up here. And so you can earn badges in Python and my SQL. And then when we have courses and projects, you'll be able to learn Excel badges and Power BI and Tableau badges and all that stuff. This isn't shareable just yet. We're creating the custom badges for this that you can share to social media and other places. And then certificates you can. Certificates you can already share. So once you complete a course, like if I go to my dashboard, once I complete this course, it'll be in this completed section. It'll say generate certificate and you can go ahead and do that. Meet me at the entrance in five to 10 minutes. I'm gonna tell her one second. I am still in my live stream, period. When you are here, let me know and I'll run down and let you in. Hello, the super sweet of her. She just got me a sandwich and I really, really, really appreciate that. Where was I? I need to go back now, don't I? There we go. Food divides us. All right, I'm gonna do this question. I might do a few other questions and then we'll do the big giveaway at the very end. Now, this is for people who, you don't have to be there the whole time but if you're just joining. This may be the perfect time that you join. You may be the lucky winner. This question says, and just so you know, you can share a lot of these things. Like the courses you can share with people. You can come in here and like share these with people. You know, say you're taking a course or you're learning. A lot of this is like the social stuff is just to show that you're learning and advancing and learning new skills. Same with certificates and badges. Like it's just really cool to share and you know, share with people what you're learning. And so if you really like this question, you can share that online. Just copy that and or click on one of these things and it'll automatically populate it for you. Now, this question is food divides us. It says in the United States fast food is the cornerstone of its very society. I don't remember writing that but that's funny. Without it, it would cease to exist. What was I thinking when I wrote this? I think it's funny though. But which region spends the most money on fast food? Where I agreed to determine which region spends the most money on fast food. That was repetitive but which region? All right, so let's look at our data. So we have the state, we have the region and we have the fast food millions. So really all we need to do is work with this region and then do a sum of the fast food millions and then filter to see which one is the highest. I believe that should work. So let's come over here. We're gonna need to do the region and then just for now I'll take the fast food millions but I'll have to do a group by on that. So what I need to do is I need to come down here. I need to say group by and we need to group all of these regions. Wait, why is that in my output? Why is state in my output? Select region fast food millions. Let me refresh this. Maybe something weird is going on. Let me see. Select everything. Uh-oh. My SQL, my SQL just, it's probably post-gray SQL. Oh, post-gray SQL is working fine. Because soon if you're looking, if you're watching this, maybe the servers are a little overloaded. It's our launch day so maybe that's the issue but our server should be able to handle it. Yeah, I'm not sure what's going on with that. Let me try it in post-gray SQL real quick. I'm gonna try to test this while we're on it. Let's do region. Okay, so that one worked. Let's copy this. Let's go back over here. Let's do fast food millions. I'm just queueing this while we're here. Okay, this is an issue that I thought we had patched up. It's just a small issue where sometimes it doesn't recognize that it's my SQL. It's reading in the post-gray SQL code instead. And so, because soon if you're watching this, if you wanna take a look at that. CT over subqueries, I usually prefer CTs, if I'm being honest. And someone asked what order should we do the courses in? So not all of my courses are done. I'm already done recording the Excel for data analysis course. It's being edited by my editor right now. And I'm recording the Tableau course. Once that one's done, those are my core courses. Then I'm gonna do AWS Azure course and then an AI course. And then after that Power BI and R and a bunch of other ones. If I were just starting out and I was watching this and I've never taken a course before, take the MySQL for data analytics course is phenomenal. And that's the one I would take. Next one I would take is the Python programming for beginners and then the pandas for data analysis. Those are the three that I would start with. If you really wanna dive even more into MySQL, I do the advanced MySQL for data analysis. And then if you have an interview coming up, you can do the MySQL interview crash course. So those are the three I would do though, in that order. Let's see. Yeah, sorry, we're not doing the giveaway just yet. We have one more, what am I looking at a calendar? It is 121 and about 30 minutes or maybe when my wife gets here, I'll do, unless she doesn't come up. If she doesn't come up, then I won't do that. Oops, but let's take a look. And yeah, the MySQL is just being weird. I think that might just be me. It might be localized to just me because I've been on here too long, I don't know. But I'll have my team look into that one. So we have the region and we need to group by the region. So we need to group by, and then we'll do group by region. We can run this, oh, there's a comma here. And we can run this. So we have Midwest, Southwest and Northeast. Now all we have to do is we need to figure out which spends the most amount of money on fast food. So we need to do the sum of the fast food millions. And there we go. Let's run this. There we go. Now we need to order by. So we'll do order by. And for simplicity purposes, I could do it like, I'll just do two, right? Order by two. Oops, descending. Now is this perfect the written SQL? No, it's not, but it's gonna get us the answer. Now I'm gonna limit it to the top one. Now this is a moderate question. If this was a more difficult question, I may have to do a subquery and then rank it. Cause what if this was tied? What if this person had 1,043 as well, or West had 1,043 as well. Then we would wanna select both of them cause they're tied. But since we can visually see it's not, I'm just gonna select the top one. And we don't actually need this region anymore. Let me see. Cause I need the output needs to be just the region. Let me think, how would I do that? Order by. Oh, I don't even think I need that. I think I need to do this in like this. Get rid of this comma. Now I'll explain this in just a little bit. There we go. There we go. That's how you answer in one in a simple query. So right here, I could see that the sum was the highest and we're limiting it to one, right? But in our output, we only wanted to select the region. So I can't have this in my output. So what did I do? All I did was I said, okay, I know that this works. Excuse me. So I put this in my order by. So now we're ordering on a column, but we're not gonna keep it in our output. And my wife just said here, so give me one sec. I gotta submit this is more important. Sorry, wife. I'm just kidding. You're more important. Anyways, I'm gonna run this and our solution is correct. All right. Let me add a note. I'm gonna say be right back getting food from wife and then we add a little heart. All right guys. So we'll be back in like 30 seconds. Give me just a second. She's right downstairs. Oh my goodness. Oh my goodness. I've never ran so fast in my life. Oh, I forgot to shut the door. Give me a sec. You ran so fast, I got it. All right guys, I'm back. All right. My wife bought me a sandwich and a brownie. Best wife ever. Thanks, baby. I know you were watching this, so I appreciate it. Now listen, my wife didn't come up. She said, I know you're doing a live stream. She had places to be, better things. Sad, but, oh my goodness. I'm out of breath. It's running too, it's running lightning speed. Anyways, I am back and very soon, probably the next couple of minutes, I'm gonna be giving away one Analyst Builder course, but I know we can win all five courses. Let me catch my breath for a second because I was actually running pretty fast. Up and down stairs too. It's not pretty. It's not pretty. Now I got that solution correct. There we go. And I earned some points for it. I'm almost at 500. But hey, listen, I've almost reached, oh, I didn't post Gray's Seagull. So I earned 25 points for that moderate question. But listen, as you take courses, as you do questions, you earn these badges. Soon, we will have a thing where you can share your badge with people, which we're gonna have a really cool design stuff. It'll just be like, it's something cool to share. It's like, you got a lot of points there, it works really hard to learn this skill. Now give me a sec. I'm gonna take a breath, because I actually was running a lot. Ooh, oh my goodness. I'm just gonna rate these. Yes, it does. The Lifetime Access to Analyst Builder includes all future courses and questions. So you just get, as I roll them out, you get them. You're most welcome, you're most welcome. Thank you. I'm glad that you liked the livestream. Thank you. Thank you, Arya, I appreciate it. My wife texted me, sent hearts. She was listening. She got my message. Let's see. Yes, best wife ever. Yeah, ooh. I just lost, lost, I'm gonna gain it back with that brownie she bought me. She shouldn't have done that. Oh my goodness. Cardio for life. Oh boy. Um, so the courses that I have right now do not cover statistics, but the Excel for Data Analysis course has an entire statistics module. So I'm not gonna make an entire course on statistics. I don't think I have enough that I think would be valuable to make an entire course with. But I do have an entire section or module. It's like six lessons on statistics in the Excel one. Now the Excel one's already done. It's just being edited. And then it'll be released. And that one, that one covers statistics. I think is all the statistics that you'll most likely use, especially as like beginner and intermediate. I'm in deep. Thank you for joining the live stream. I really appreciate it. Really, thank you, Wanda. I really appreciate it. No, they don't teach database administration. It's mostly data analysis. Yes, SJ, yep, I'm sorry. I just missed it. The beta prices are gone. And the beta prices were much lower price, not much lower. They were slightly lower price because when people were working through them, they were finding bugs, right? We were a new platform. We had just launched. So people were figuring out bugs and all these things. And it was really appreciated that there were so many people giving valuable, good feedback. It really was. And now we're doing the full launch. And we'll do more promotions like this where we'll do big discounts and stuff. And that'll be really fun. And I'll do giveaways because I love doing that. And so, yeah, lots of fun stuff coming. All right, let me do, here's what we're doing. I'm gonna do one more question. That's it. Then I'm gonna be doing a giveaway of this Analyst Builder course bundle. That'll include all five of these courses. To one lucky winner. I'll be doing more giveaways in the future, so don't worry. But I do want you guys to check out the platform. Like I really do. It's just, I'm super, super proud of it. So I'm just gonna share this in the chat. I'm gonna try out the questions here. There you go. Let's see. Just trying to go up here. So let's go back to the free questions because that's what I'm trying to do them with you so that anybody can do them. And let's go to the difficulty. We've already done the hard, I think. Yeah, we completed all the hard ones. So the temperature fluctuations, cake versus pie, Kelly's third purchase already did it. So let's get rid of that. Let's do moderate. And let's see. Let's also do where I haven't completed it. So let's choose one of these. Senior Citizen Discount, LinkedIn Famous Media Addicts. Let me see what this Media Addicts one is. This is an interesting one. I like this one. Let's try this one. We'll do this one and then we'll do the giveaway. All right, so this is Media Addicts. Let me share it with you guys if anyone wants to try it with me. Try this question with me. There we go. We'll keep on postcards. I don't think it's gonna be any different. Now, this says Media Addicts. Social media addiction can be a crippling disease affecting millions every year. We need to identify people who may fall into that category. Write a query to find the people who spent a higher than average amount of time on social media. Provide just their first names alphabetically so we can reach out to them individually. So we actually have two tables here. We have the user ID and the media time minutes. And then we have user ID and their first name. So we're gonna have to use both these tables because we use the minutes to determine if they're higher than average. And then we have to have their first name in the output. Just their first names alphabetically. So the first thing that we need to do is identify the average time spent. And that's under user time. So what we can do, let's run this. What we can do is we can do the average of media time minutes. So just like that. So this is the average, let's just round this just for visual purposes of nothing else. So the average is 282 minutes. I believe that's maybe per day or something, we'll see. But that's the average. So if they have higher than average, that means that they fall into the category of social media addiction. So what we can do is we can select, we can say, oops, we'll say where media time minutes is greater than the average. Now I'm just doing this for visual purposes because what we'll do is we'll say select everything or actually everything comma. Let's run this. What did I do? Oh, aggregate functions, let me do having. What am I talking about, what am I even doing? Here we go. Aggregate functions are not allowed in the where. Oh, what, I am the last question of the day and I'm losing it. It's because we need to use a subquery. So I can just do it like this. Where select that from user time. Last one of the day and I'm just losing it, losing my mind. I just need to wrap this in a parenthesis. Let's try this. Select from user time. Let's see. Okay, I'm about this needs to be where. Select everything from user time where the media time minutes is greater than the select, maybe it's the round, I don't think it is. Oh, oh, yeah, no, that was an issue. So if I go back, I didn't have enough parentheses. So if I actually add this parentheses right here, let me see, use an aggregate function. Let me read this. This user time user ID must appear in the group by clause or be used. Oh, it's because I had having. What, this keeps changing on me, that's confusing me. It was the issue earlier was I didn't have this, what's it called, parentheses closed. That's the only difference, that's the only thing. So the average was 282 and all of these people have higher than 282 media time minutes. Now what we need to do, because the names aren't in the same tables, now we have to join this to this table. So we have to join this to this user's table. So I need to come here and I need to say, join to the user's table and I'll say on, it's gonna be user ID is equal to user ID? Yeah, so we'll do user time dot user under square ID. Is equal to users dot user ID. Thank you, autocomplete. So let's run this. And where's the first name? That's being weird. Oh, it's because I selected everything. Oh, okay, okay. So let me come here, we'll do a first underscore name. There we go. So now we have Adam, Chris, Christine and Bella, but we needed to provide their names alphabetically. The very last thing that we have to do is we have to order by, and we'll order by their first name ascending order, which it looks like, no, it's not, it's ACCB. So it's not an ascending order. First name ascending, let's run this. And we have Adam, Bella, Chris and Christine. And let's just double check the expected output. That's perfect. Let's go ahead and run this. And there we go, our solution is correct. Perfect, nailed it. I didn't do great at first, but I nailed it in the end. All right, so let's come back over here. Awesome, let's see if there's any more questions. And then we're gonna wrap it up. I've been doing this for like four or five hours now. So it was the longest live stream of all time. And we're at the lowest streams, which means you have the highest percentage of winning now, then you have throughout this entire live stream. Cause at the first giveaway, there was like 300 people. The second giveaway, there was like 180. Now there's like 117. So you're doing great. Let's see. Analyst Builder is fantastic. So glad you quit your job for us. Thank you to you and your wife. Absolutely, thank you, that's very, very sweet of you. Which career language can I do with NodeJF? I'm not sure. Great design for a platform, thank you. First time working with pandas, forget about the heart attack, awesome, good work. Are you still here? Yes, I'm still here. Let me see if my thing, oh yeah, it's still working. It's still working. Nailed it, that's right. Yep. No, I don't plan on increasing the price. You know, maybe like two years or something with inflation rates and whatnot. Believe it or not, this website is actually not super cheap to maintain. We have a lot of AWS servers running. We have different clusters. We have different products and services running on the back end that cost quite a bit of money. And so, you know, unfortunately, this is not free, but I don't want to increase prices that much. It just, it doesn't feel right and I don't like doing it. I don't like what other people do. So I'm gonna try to keep the prices as low as I can, genuinely. I don't plan on like, as this gets more popular, raising the prices and raising the prices, raising the prices until like prices people out. I really wanna keep it very affordable for everybody. And so if this is something that you can afford and you're like, I can afford that because I know I'll be using it for the next six months, eight months a year and you're not gonna get all the new courses and the questions and the resources, then I'm really happy to hear that. This to me is, this is how much you pay for Coursera for one year. So if you buy Coursera for one year, you can get Analyst Builder for life, including all future courses, all future questions and everything. We talk more about the difference between lifetime courses and lifetime questions. Yes, if you just go to the questions, this is unlimited access to questions for life. That's just this questions page. That's all it is. The bundle, the lifetime access to Analyst Builder is gonna give you lifetime access to all questions and all courses on Analyst Builder forever. So that's all future questions, all future courses that we add, then you will have access to them, all of them forever. That is the difference. All right, we're doing the last giveaway now and then I'm gonna end the live stream soon afterwards. But the winner can email AlexAnalystYT at gmail.com, email this for a winner. All right, here is the last one. My beautiful wife brought me, oh, what is it, a sandwich and a brownie. So we're gonna say AB Brownie Love. That's all it is. That's our code. I'm gonna wait for just a second. AB Brownie Love. And if you type that in the chat, and thank you, Christine, for this, I really do appreciate. I'm gonna eat all this food after the live stream. I don't feel right, it doesn't feel right eating it when people are watching, so I'm not going to. But go ahead and put that in the chat and then I will choose someone in just a little bit. There is no rhyme or reason to it, but if you are chosen, just please shoot me an email. I go off the honor system. I've never had an issue with it in the past, so if you win, shoot me an email and I will get you a code for that and I really appreciate it. All right, I'm gonna choose one person. Again, I'm gonna be choosing someone for this Analyst Builder course bundle. There's gonna be all five courses that are on the platform right now, but again, there's more courses coming, already completely ready to go, or almost done editing. All right, I'm gonna choose in just a second. Whoa, there's a big uptick. Give me a second. I'm gonna, I'll scroll back up in just a second and then we'll see who I got. All right, let's take a gander. All right, we got Austin Glenn Dinning. I just thought that last name was cool. That's the only reason I chose it. Austin, go ahead and shoot me an email. Congratulations. I really hope you enjoy the courses, really hope you enjoy the platform. Thank you for joining the live stream. Thank you for everyone for joining the live stream. I want you guys to, I want you guys to know I really do appreciate you watching and joining and for all the support you guys have given because I feel incredibly, incredibly blessed and I hope you try out the platform. I really, really do. I'll be doing more live streams and more giveaways like this. And so I hope that you guys can join and try out the platform. I see this platform becoming one of the main platforms for data analysts to learn from, like paid. I already think my YouTube channel is one of the main places for that people go to learn for free content. I want this to be one of the main places that people go for paid content as well. It goes even more in depth and it is even more useful than my YouTube channel. And so I'm not trying to monopolize out here. I just really think I have a good perspective and a good way of understanding what people want and how to build it. And so I'm trying to build it and I'm trying to do things differently and I'm trying to make things fun again because a lot of learning platforms out there, they're just, I don't know, they're kind of boring. It's just not, it's not super fun, right? It's just like, it feels like you're grinding through it. I want it to make it fun again. And I feel like this platform is like the fun way to learn. And so I really hope, really hope you guys enjoy the platform. We have a Discord, if you come over here to Analyst Build, you come all the way down to the bottom. You can join our Discord server. So you can talk about, you can talk about the courses if you have any questions, if you have any issues, you can talk to other people. It's just a really, there's like 1500 people in it already that were part of the beta program, but now we'll have more coming in, of course, now that we're doing the full lunch and as we launch more courses and more features and all these things. So join that and then get on here and try this out. See if you like the questions, try all the free ones. There's a lot of free ones. Like these are all the free ones. And we did a bunch of them today. You can see with the check marks but these are all the free questions. There's even I think one more on the other page. So go ahead, try these out, see if you like them. If there's a course that you are interested in, go ahead and get that. And if you have, if you want to really invest in it and kind of grow with the platform, then there are the Analyst Builder course bundles and the Lifetime course bundles, which will get you access for life to the platform for courses and questions. And I have a lot more stuff coming out. While I got you guys for just like even a second longer, kind of our plan for the future of the platform is to, I mean, I already feel like one thing is, is there's no other platform like this right now that has a question, a technical question section like this and courses on it. So that in and of itself is unique but the things we have planned for the future are just, it's just gonna be so amazing. We're gonna have a full project section where you can build projects and take projects and add to your portfolio. We'll have a resources section where you can get cover letters and resumes and all these different things. And we're looking into the ability to process it through one of those automated systems. So you can run your resume through an automated system to see if it performs well. We're gonna be incorporating AI into it. So like in this, in these technical questions, we plan on having some type of like AI feedback in here as well as in the courses. So when you watch a course, one of our plans is to, you're coming, you're learning about joins, you're learning about inner joins. And you wanna know more about it, you can click like, you can ask AI question about the video and then ask him more about it. So you don't have to leave over here to go to chat GPT or barred or anything, it'll be all in-house. And it'll just make for a much better learning experience. And so that's what we're trying to do. So those are just a few of the things. One of the things is we're gonna make roadmaps. So right now, how it is on the platform is all the courses are just kind of here. And if you know what to take, that's amazing. You know you wanna learn MySQL, come and take the MySQL. But if you're kind of new to it, you don't know exactly what to choose, we're gonna create a roadmap. So it says take this, then this, then this, do these questions, you know, use these resumes and it'll kind of be like, it's kind of like a really more advanced, interactive free day-nails bootcamp, except on the YouTube one is just videos, whereas on here, it's gonna be much more interactive and you know, I think it's just gonna be amazing. I'm hoping to get that out like middle of early 2024 to middle of 2024. That's like my goal for that. But we have so many, like if I showed you my spreadsheet, I have like 20 different things that are like really unique that we plan on implementing. And so this platform's just gonna grow and get better and better and better. And I genuinely think it's gonna be one of the best platforms out there on the market for data analysts to learn and learn really affordably. Because it kind of, it didn't hurt, but when I saw what people would buy like the Coursera for a year, I'm like, dang, they spent like $399 for one year. So if you wanted it next year, you gotta pay another $399. I'm trying to make it more affordable for people to get in-depth, really great resources that don't cost an arm and a leg every single year. So I hope you guys, I hope you guys see that. Like I really am trying to not, I'm really trying to make it affordable. And we plan on doing, I plan on doing a lot more giveaways and a lot more of these discounts that throughout the year you guys can pick stuff up as you need it. With that being said, I really, really, really appreciate you guys joining. We had several thousand people come through. Some stayed for the whole thing, which is way too long. Goodness gracious, this is a long livestream. It was like five hours. But really, really, really appreciate you guys. Check out the platform. Let me put the link, let me put the link in here. Oops, there we go. I'm gonna say try out Analyst Builder. Go ahead and try it out. See if you like it. If you do like it, I hope you try it out, join the Discord and see what other people think, but really, really, really appreciate it. And oh yeah, I'm gonna create leaderboards. I didn't know lead code had leaderboards. I haven't gotten a lead code in many years. But yeah, so one of the things that we have is if you didn't notice, under the profile you can earn points for different skills. And if I didn't do any Python today, I thought I was going to. But if you get ranked up, we're gonna have shareable badges. Right now it's just on here, but soon you'll be able to share them like a badge. But also in the question section have up here like a leaderboard, where it's an overall leaderboard for all points, as well as like a weekly leaderboard, where even if you haven't done it for months, if you come in and you start coding, you can get on that leaderboard. And it's just really cool, kind of like a fun competitive game. And that's gonna be coming fairly soon. That won't take a long time. We'll probably have that up in a couple weeks. But genuinely try it out. This is just a blast. Like I love doing this live stream. I gotta do a ton of questions, but I've talked to so many people who've tried it already in the beta. And now we're fully launching today, who just have given such, they're just like, it's so much fun. And that's what I was trying to create. And that's what's made me the most happy about it, is people are just having a lot of fun learning again. And they're like, it was so boring on this platform. And they're like, this is really fun. That's what I'm trying to create. So I hope you guys can see like it's, you know, I'm really, really, really trying to make a great platform for you guys. And I couldn't do without you guys. I really could not. I appreciate it. So with that being said, I'm gonna get out of here because I'm gonna eat the sandwich and this brownie, because it is calling my name. Thank you, Christine. Shout out to my wife. I love you. Shout out to the Wave Sync team. And shout out to you guys. I love you all. I really do. I really appreciate it. All right, I am gonna get out of here, but I will see you very soon. I'll make a video tomorrow that I'm gonna release on the platform, talking about all the features and everything. So if you joined, you probably saw a lot of that, but all right guys, have a good one. I'm signing out.