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.  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.  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.  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.  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.   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 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.  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.  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.  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.  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.  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.  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.  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.  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.  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.  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?  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.  Let's look at this, this is right. 601, 12 pie, 601, 12 pie, guys, we did it. Let's look at the bottom.  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.  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.  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.  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.  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.  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.  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.  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.  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.  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