how to do it. Can you come help us analyze this data or do something? And that's where like I have specialties, like SQL is a specialty of mine. I consider myself an expert at SQL and I'll come in and I'll help them figure, or in Python, I'll help them figure it out. And then I leave. I just help them figure out an issue they're having. Three is I'm helping them with go-to-market strategies for data products or market fits. So for example, when I was a hiring manager, I did a lot of the purchases for my team and for my department. And so I have a good perspective when people have a product, I can say, okay, you don't wanna target that at CIOs, which is what they were doing, or CTOs, you wanna target that at the managerial level. And so here's how you get into that market because I was there and so that's how you do it. And then sometimes I make videos, like internal or external videos for people because I have some video background. So that's what I do. So I do a little bit of everything. It's pretty all over the place. Paul said, sorry, just rejoined. Is Power BI in the future? Yes, Power BI in the future, absolutely. 100%. Can we get passwords throughout web script? I don't know what that means. You'll have to clarify for me. All right, I'm gonna go over to the questions page. As you should, go ahead and actually I'm gonna do join this question. Actually, let me choose a question first and then I'll do it. All right, let's choose a question. I'm gonna do a moderate one because the hard ones take a long time. I also wanna show you ones that are moderate, right? Tech Layoffs could be an interesting one. I don't remember what was in that question. These are all the free questions, by the way. So you can go and take any of these questions. Right now, you have access to everything. Let me do this too much information. This sounds like a good one. So again, I'm going to post this question. Do this question with me. So go over to Analyst Builder. All you have to do is create an account. It's free to create an account and try this question with me. So this is called TMI, Too Much Information. Often when you're working with customer information, you'll want to sell that data to a third party, just being honest. Every company I've worked for has done this. Most companies do this. Unless they have contracts with people where you can't sell their data. Sometimes it is illegal to give away sensitive information, such as a full name. Here you're given a table that contains a customer ID and their full name. Return the customer ID with only their first name for each customer. Now this is a moderate question. And so we're gonna need to do a little bit of separation here. We have John McGarry, but we don't want John McGarry. We're just gonna include John. So we have to get rid of this, McGarry, somehow. This is something, I've done this no joke, hundreds of times in the real world, where we're like, hey, we need to pass this data off to this person who is a client of ours. We have to get rid of some of this information because it's, what's it called? TMI, personal, is it TMI? What's the, it's just personal information. Personal identification information. I don't remember what it's called. My brain isn't working right now. But you can't have full names in there. It has to be, quote unquote, de-identified data, which is if I had like an address, a phone number, social security number, I can't include some of that information when I send data to these companies. So let's see how we can do this. Let's get rid of this limit 10 here. Let's run this. Now, my first thought is one, we just need the customer ID. So let's do customer under square ID. And then we need the full underscore name for now. But then let's come down here. Actually, let's run this. Now we need a new column for now and then we'll get rid of this full name. But we need a new column. We just need to separate this out. We can do that. Let me think. There should be a function. And what's this function called? Is it's not substring. I have to think of it off the top of my head. I could Google it. It's not substring, it's where we can use a delimiter to look at a delimiter. Give me a second. I'm trying to think of what that's called. It's not substring, is it substring? I don't think it is substring. Because if we do substring full name, I think we do like five. Let's run this. Yeah. So we're starting at number five and going forward. But I think there's a function where we can look at the delimiter. I'm just forgetting what it's called. Is it substring index? Substring index, that sounds right. Full name and then we have like, how do we do this? This is a substring index. There's a parameter count, incorrect parameter count in the call to native function. Yeah, because I need to specify what we're doing. I think it's like this, or a space. Let me look at the hints real quick. You'll need to split on a delimiter. The space, split on this and only keep the first name. I already knew that. Alex, what a terrible hint. That's my own hint. I think, I'm pretty sure it is substring index. I'm just trying to remember what the parameters are for this. I think maybe you pass through this first. Let's try this. And then we'll do a comma. I think we passed through the delimiter first. Let's try it. All right, I'm gonna Google substring index. Substring index, MySQL. Let's see what the parameters are for this. The string delimiter number. Ah, I was so close. Okay, okay. Hey, listen, even I forget these things. I can't remember every single one. We'll just do this, and then the first one. That's what we needed. There we go. Okay. So the issue was, is we have a parameter here. And the parameter is we have to have the strings. That's our full name. Then we have the delimiter. What do we wanna split this string on? We need it on the space in between. And then we wanna only do it on the first space on the first delimiter, which is this one. So now we just have John, Sally, Jenny. It takes the first part of the full name. And we're gonna do this as, what do we need it as? First name. So we'll do it as first underscore. Now we can get rid of this. We'll run this. And now this looks exactly like the output we were looking for. And it says return the customer ID with only, yeah. This should be right. Let's go ahead and check our answer. And there we go. We got that solution correct. Try this one out. Substring index for this one, but I don't think it's the same for Microsoft SQL Server. I think it's different for this one. And it's definitely different for Python. But once I get this badge in a little bit, at 200 points, that's what I'm talking about. Once I get this next badge, because right now I'm a MySQL beginner, once I earn more points, and I get the next badge, I'm gonna try Python. Just so you know, and we're gonna add this to the questions page, but when you do an easy question, you get 10 points. When you do a moderate or medium question, you get 25 points. When you do a hard question, you get 75, and then for a very hard question, you earn 100 points. And so right now I'm at 210, and you rank up, and you can become MySQL master. That takes like 3,500 points, but you can also earn points by doing a course. So if you complete a MySQL course, you earn 500 points towards your rank here. We're also gonna be adding a leaderboard over here. We have all the data on the back end. We're just adding a leaderboard soon of people on a month, like an overall leaderboard, right? So if you've taken a lot of courses, you've done a ton of questions, you have a ton of points, you're gonna be like high up on our leaderboard, and then if you, each week, we'll have a leaderboard for weekly users. So you can become, even if you just started today, you can get a leaderboard, whoops. So we're still looking at the free ones. These are all free to do right now.  I just did one. Yes, okay, Alan. Thank you for telling me now. I already did the question. I'm just kidding, thanks Alan, I really appreciate it. Yeah, yeah, PII, personally identifiable information. That's what I was trying to say. Can we separate based on the space between the names yes, and I did? We were able to figure it out. Great way to solve problems you're reforming, like how most of us would perform and utilize the website to find the answer, exactly. Now listen, if I couldn't find it, let's go back to that question. Where was that question? Too much information. Now if I couldn't figure it out, you can get hints, you can look at the expected output. If you can't figure it out, you can always go to the solution and take a look. What I do here, I use trim. That's probably smart to do, just to make sure you don't have any spaces or gaps in the data. I should have done that. Previous Alex was much smarter than current Alex. I'm finding very quickly. And if you couldn't figure it out, even after looking at the solution, you didn't understand it, I walk through that solution with you. Now right now, just a note, I only have MySQL videos, but I'm gonna be adding ones in Python later. There's like over a hundred questions right now in the questions page, I'll be adding more. And so it just takes a long time to record every single video. But I will be doing that. I will be doing that. I, one thing I want you guys to try just it'll take a long time. I really want you guys to try one of these very hard questions. These questions are very hard. Very, very, very difficult. I want people to try them. I've had a few people solve them already and sent me confirmation. Here's my, this is what I told people when they were beta testing it, I was like, if you can solve this question, you can send this to me. I will be very impressed. I was like, this, you really know how to use the tool if you can solve these questions. Like you really understand it. And when people would send it to me, I'd be like, dude, you did it. You were the first one or, you know, you were able to solve it. You're one of the very few who have solved it. There's very few people who can solve these very hard questions. And I'm not making them so incredibly hard where they're impossible. They just really, it takes, it'll probably take like, if you know MySQL pretty well, if you're doing it in MySQL, it'd probably take you a solid 30, 45 minutes, maybe even an hour or so to solve it if you don't get any hints or you don't watch the solution video or anything like that. And so I really want people to try those. Now let me clear this. I'm gonna just go back to the free questions here. You can also search by completed and incomplete. So if you only wanna look at the incomplete, we can do that. So now we don't have to go look at the ones we've already done. Let me do an easy one. I'll do a moderate one and I'll do the last free hard one, which is Kelly's third purchase. Cause that's a cool one. Let's do art attack risk. Here we go. Now this is one that inspired me because this is something that I used, this is like a crazy simplified version of it. But you know, I used to work with a lot of patient data and hospital data from doctor's offices and all these different things. So this one kind of brings me back. I really like it. Let me share this one with you guys. Try this question out. If you're just joining, this is not my normal setup. I apologize. Alex is surprised. Yes. Yeah, I'm finding that previous Alex was a lot smarter than current Alex. Like a couple of months ago, Alex, I was, so Milton said he's looking at like aspect, like ratios for points. I need to change the point system a little bit, I think, but it's currently 10 points for easy, 25 for moderate, 75 for hard, 100 for very hard. The hard questions you, if yeah, that would be the fastest way if you're just doing questions to level up. But they're hard. So they take a little while longer. I think the very hard questions I'm gonna change to 150 points. I think it needs to be. They're much harder. And there's not a lot of them because they're so hard. I didn't put a lot of them on here. Oh, we'll do this heart attack question in just a second. So some questions and then we'll get to the question, but it says a bit off topic, but this is from C chef. How did you find yourself working on it as a data analyst, as a junior data analyst? I look forward to learning from your site. I was working at a nonprofit as a caretaker, essentially. I made food for people. I had a degree in recreational therapy, but I could not find a job with that degree. And I was working at a caretaker at a nonprofit and a job opened up at the nonprofit for a data collection specialist and analyst. Had no idea what it was, but my girlfriend at the time, my now wife, said I was really smart and I should do it. And it was just Excel, it was just Excel work, just basic numbers, nothing crazy, just collecting data for grants. And I was like, I don't think I would really enjoy it or know how to do it or like it, but I was like, let me try it because it was a higher pay. I was making like, I was making like 36,000. And then when I got the data collection job at the nonprofit, I was making $47,000. So it was a jump in pace, I was willing to do it. Well, I got in there and I really liked it. I was like, man, I really like this data stuff. It was pretty neat. And then I got started looking up, like how do I advance my career in this? Cause this seems more of a better career than recreational therapy, which is what I was doing. And then I just went from there. I started learning SQL, I got a different job, got a better job, learned Python, learned Power BI, learned Azure, top low, got a promotion of manager. And then during that whole time I created this YouTube channel. And so yeah, that's kind of like my progression. These comments, Diego said, maybe it's because you don't do these problems more often now. Yeah, that's kind of true. I mean, but I should, I know these. If I really think about it hard enough, I know it. That's what's so fun about it. It's like it really is a challenge to get to these questions, which is super fun. That's funny. Yeah, there's your answer. Leho, Lejo, Leho, Phillip, said, will lifetime access to Analyst Builder include future courses? Yes. Lifetime access is gonna include all future courses and questions. So if you buy now, and it's 20% off too, so it's 20% off the 349, but if you buy now, when I release the Excel courses, I have another course that's coming out in a couple of weeks, but it's a condensed version of the Pandas course. It's the Python interview crash course. So that's for people interviewing in Python. That there's a crash course for that, really, really good, but it's kind of like a condensed version of the Pandas course. And then it's more focused on interviewing. That's what it's for. Then after that, a couple of weeks after that, the Excel course will come out. It's already being edited, it's being finalized, and then I'll put it up. And then right now I'm recording the Tableau course. Those courses will all be done in the next like couple months, and you'll have access to all of them with the Lifetime Bundle.  Ba-bum, 20% off applies to anything, anything you purchase. So if you purchase the 349, 20% off, if you just do the questions, 20% off, yearly 20% off Lifetime for the questions. Now don't, if you're looking for the Lifetime Bundle for questions and courses, don't buy this one. This is only for the questions under the Questions tab. So if you just really like the questions, you wanna grind those out, that's how you learn best, you don't like courses, do that. But it's 20% off, and the courses. So be sure to use this when you check out, and it will work. You'll get 20% off anything you purchase. All right, let's go, I'm gonna stay over here just in case I wanna go back to it later. But let's go back, let me see real quick, if there's any other questions. Yes, Lifetime Bundle will give you access to everything, all courses, all questions in the future. And I just released the Pandas course like three days ago, and I just released several questions last week. And so I will be continually rolling them out. I wanna be a data analyst in SQL, should I learn MySQL or Microsoft SQL Server? The reason that I made a MySQL course is because one, it is very popular in the real world. Two, anybody can learn it. If you're on a Mac, if you're on a PC, yeah, PC, Microsoft SQL Server is specific. You can use it in ways on Macs, but it's harder to do. I recommend people learning MySQL first. If you get a job where you are using Microsoft SQL Server, you can pick it up pretty quick. If you already know MySQL, you can pick up SQL Server very quickly. Do you know that now the market has become more hard for entry-level positions? If so, how can we stand out? Well, right now the market's harder for everyone. Genuinely, this is not a reflection on entry-level jobs, genuinely. It is, even at the senior level, it's more difficult right now. More than anything, the reason is is because inflation is causing a lot of issues. And because of that and over hiring during the pandemic in 2020, 2021, they did layoffs. And so there's a lot of qualified people out there. So it's not just entry-level jobs that are, it's tough to find a job. It is across the board. Now this ebbs and flows, this is a natural progression. If you go and you start Googling this and looking at this, you will find that this is a natural progression of the job market. And right now we're just in like a slow season. Some people got, a lot of people got laid off in 2022 at the beginning. I think that near the end of 2022, I have talked to a lot of people. A lot of people think that 2024, the end of 2024, which is summer and on, is going to be a big hiring season for a lot of companies. And so that's kind of like where I'm looking at. I'm kind of keeping my tabs on and track of it so I can keep people up to date. But how to make yourself stand out, genuinely is, and I say the same things, but you'd be surprised how many people don't do it. The people who end up getting jobs are usually the people who do the exact steps that I recommend and they consistently do them. They don't just try it and then quit. They do it. Is one, you got to learn the skills. You have to know the skills. Two, create a really good resume. On my YouTube channel, I have a really great resume. We'll have a complete section on the platform for resumes, cover letters, all communities, all these things on the platform next year. But take that, go watch that video now. Make a great resume. Make a portfolio with projects. Have a really good resume. The resume is super important. Then start reaching out to recruiters and have recruiters reach out to you. So go on LinkedIn. I have a video how to get a job on LinkedIn. Use that video to reach out to recruiters and use it to understand how recruiters work and what they're looking for. Optimize your LinkedIn profile and work with recruiters to apply for jobs. I at one point when I was first starting out I was working with six or seven recruiters at a time. Now, when I say working with, they had my, I said, hey, I'm looking for an entry level job. Here's my experience, which wasn't much. And I was like, I would email them and they were like, okay, yeah, great. If anything comes across, we'll email you. I didn't want to just rely on them to email me. So every single week I had a list of people. I would email them once a week and I would call them once a week to say, hey, has anything come across your desk? And here's what I'm working on right now. And I just, I was relentless. And if you do that, you will be more successful than almost everybody else trying to apply right now. Cause most people applying are just creating a resume and applying on Indeed or LinkedIn. There are some people who are working with recruiters and then they reach out to the recruiters once and they hope that they'll reach out to them again. You need to be consistent and you need to really work hard. This is, this is, you know, but once you get that experience, it becomes a lot easier to get land the next job. But that is how you, that is how you set yourself apart. I see other questions. Let me see someone. As someone who became a manager, what is something you consistently saw in hopeful data analysts that you were looking to hire prevented you from continuing with their interview. Usually it was domain knowledge. So, and this isn't not every place, but when I was a manager, we were working with very specific types of data that required some domain knowledge. I couldn't hire someone if they didn't have it cause that would take way too long to catch them up to speed on the domain side of things. And so, if you know a little, when I was the manager I was working in IT, so that was cybersecurity data, ticket data, help request data, all these different things. Now, some of the cybersecurity data and all these other things were, you know, if you've never looked at it, it's extremely confusing. And so, that would have taken many months to get them up to speed, whereas if I hired someone who had the domain knowledge, I could teach them their tools cause we use proprietary, some proprietary tools, some Microsoft tools that no one else uses. And so, I wasn't worried as much about tools as I was. I needed someone who knew a little bit about IT, who had either worked in IT before or, you know, something like that. So, that's like something that pretty quickly, you know, I could tell if they knew some domain or not. Now, it was a big bonus if they already had some of the skills, a big bonus. But I kind of was willing to step that aside because we really need someone with the domain knowledge. Main difference to MySQL, Microsoft SQL Server is that Microsoft SQL Server is a paid service. They do have a free option, but Microsoft SQL Server is a paid service through Microsoft and they have something called T-SQL, Transact SQL, which has a few different features that MySQL does not have. I learned T-SQL for, I used T-SQL for years. I actually prefer it over the syntax and functionality of MySQL. I just think MySQL is better to learn at the beginning. Truly believe that. But MySQL is open source, it's created by Oracle, created by Oracle, so Oracle also has a paid version, but MySQL you can use as a full solution, but then you can buy their full solution for added features, of course. So that's really it. Oh, geez. Let me get rid of this. Yeah, I gotta hide that, sorry friend. That was too much, that was exhausting. Just looking at it. Will Google cert really help you get a job? Here's my take on the Google certification.   That's what it's good for.  My data analyst bootcamp on YouTube is better than the Google certification. It just is, because you learn way more skills, you learn a lot more things, goes more in depth. It's just way better. Then if you wanna go above my free data analyst bootcamp, then you have Analyst Builder, where you get to practice your skills, you get to practice technical questions, which you'll need to know for technical interviews when you're applying for jobs. And not only that, we have better courses than what's on my data analyst bootcamp. So it's kind of like a progression. If you're a super, super, super beginner, the data analyst bootcamp is great to kind of understand the concepts and the basics. My data analyst bootcamp on YouTube is way better than that and is free. So I highly recommend that. And then Analyst Builder is just its own beast. It's just amazing. It's like a lot of different platforms combined into one. And we have so many things planned for the future where it's gonna be even better. So if you're thinking about getting in like three months, if you're like, in six months, I wanna be a data analyst and I wanna start taking courses now.  The Tableau will be coming out early next year. And of course then you can practice with these questions. Where was I? I gotta go back. We'll practice with these questions. Now let me put this in the chat again because now I'm gonna do a chat. I'll need chat GBT. There we go. Let's do current, let me say try this question with me. If you guys are just joining, I'm at my dad's school because my internet went out of my house and I didn't wanna cancel the live stream. So I'm doing this for you guys. I really am. I hope my wife, I have my wife's key. I hope she can get in the building when she comes. Whoops. I need to, I need to be on the lookout for her texts. Because I used her keys to get into the building. We're gonna do this question and then I'll answer more questions. I just put this in the chat, didn't I? I put this in the chat. There we go. I just put this in the chat and then I'll answer more questions after this. But this is our questions section. This is an easy question. And then we have other ones. But there's a bunch of free questions that you should try them out. Dr. O'Brien has seen an uptick in heart attacks for his patients over the past few months. He's been noticing some trends across his patients and wants to get ahead of things by reaching out to current patients who are at high risk of a heart attack. We need to identify which clients he needs to reach out to and provide that information to Dr. O'Brien. If a patient is over the age of 50, cholesterol level of 240 or over and a weight of 200 or greater, then they are at risk of having a heart attack. Write a query to retrieve those patients, include all columns in your output as cholesterol level is a large indicator, is the largest indicator, or do the output by cholesterol from highest to lowest so you can reach out to them first? There's a lot of talking, so I'm gonna get some water. Now I'm still trying to earn that MySQL badge. Remember you can try it in any of these variations in Python, MySQL, PostgreSQL or Microsoft SQL Server. I'll be doing Python later. Believe it or not, we've been going for almost three hours now. This live stream's been going for almost three hours. I am probably gonna go for another hour or so, maybe an hour or two. I wanna get that badge though, but we'll do this question. Maybe, I don't know, we'll see if I can get there. But you get points by completing questions or taking courses. If you take a full course, you earn 500 points, which is a lot. If you take questions, you earn a little out of time. Easy questions, 10 points, moderate, 25 points, hard, 75, or very hard, 100 points. Which I'm gonna change to 150. I've already decided. So let's go look at our data right here. So we have a patient ID, age, cholesterol and weight. And what we need to do is we're ready to retrieve these patients, include all columns in your outputs. That's really nice. But we need to order by that. So we have all these different things, different conditions that need to be met in order for it to be in our output. So let's come right down here. Let's say where. So what we need is where the age is, is over the age of 50. So we're gonna say where age is greater than 50. Doesn't say greater than equal to, right? So let's keep it like that. And cholesterol level of 240 or over. So now we have to do, let me copy this. I don't wanna misspell it. I'm bad at spelling. Where cholesterol is greater than or equal to, this says 240 or over. So greater than 240. And, cause we're doing and, this isn't just one. All these have to be true. And the weight of 200 or greater. So now we'll do a weight is greater than or equal to 200. Now let's run this and let's just check. So this guy's over 50, cholesterol is really high over 240 and the weight is over 200. So that meets and it looks like all the other ones meet. So we have five people, but we need to order by and we need to do that by cholesterol. So let's do cholesterol. It starts from highest to lowest. So if I do it just like this, cholesterol is gonna be lowest to highest cause it's automatically by default in ascending. But we need to put it as descending which is highest to lowest. So now we have our cholesterol, boom, boom, boom, boom, highest to lowest and let's see if I got this done. That should be it. So this is our answer. Let's go ahead and check our answer. And there we go. Our solution is correct. And let's go see, we got 210 points now. So we're working our way up. I'm going to choose a new question. Let's go back to our technical questions. These are all the free ones. We could do media addicts, separation, direct reports, bike price, senior citizen discount. Who divides us? These are all interesting. I'm trying to think of which one would be a good one to show. They're all really good. What's this tech layoffs? Okay, okay. Yeah, I don't wanna do that one. It's an interesting one, I don't wanna do that one. Let's do this bike price. Yeah, let's do the bike price. This is gonna be the next question. I'll share it in just a second. But let's see. How come my previous degree in manufacturing engineering in data analysis? Well, what was your, do you have any experience? I don't know much about that degree, to be honest. But what's your experience in? Was it, do you have any actual, in a certain domain where you were using that degree and now you're trying to transfer it over? So you probably have a lot of knowledge with that domain. Not a lot of questions. So if you have any questions, let me know. I'll try to answer them as I go. I know I was just showing you the platform, but just wanna say your system is awesome. Hacker Rank was used before, it doesn't go into Python, so it's nice to have a compare and contrast on how you'd solve the same question. Absolutely, absolutely agree. Really glad to hear that. So if there's any other questions, post them in here, I'll get to them in a little bit. I'm gonna post this question. I know I've been live streaming for three hours, guys. I'm still going strong. I'm gonna say try this question with me. Now let me make sure I'm still talking. My face was, oh yeah, I'm doing all right. I'm doing good. Let's see. Now real quick before I go to the next question, you can use a 20% off with the AB Live 23 code at checkout, be sure to do that. I don't want you to pay full price. I want you to use the 20% off, and that's for everything. So even with the lifetime bundle or the analyst builder, highly recommend, highly recommend picking something up. Now just note that the questions, these are only subscriptions or payments for the questions page. Courses will only be for the courses page. The bundles will be multiple courses for here for the analyst builder course bundle. The lifetime access will give you access to all the current courses and the current questions and all future courses and questions. So if you take 20% off of 30, that's like, say 275, you'll get my courses now that I have. You can start taking them. I'm gonna be releasing courses as I go. So the Excel course is gonna be done soon or it's already done but it's being edited. It'll be on the platform soon. Then I'll have my Tableau and then Azure and AWS and then my AI course all gonna be on here. So if you get that, you'll get access to all those future courses as well. Just wanted to note that. Now, let's take a look at this bike price. Now this is an intermediate one or a moderate one. So it's easy, medium, hard and very hard. This is an intermediate one. So a little bit harder than the previous one we just did. Now this question says Sarah's bike shop sells a lot of bikes and wants to know what the average sale price is of her bikes. She sometimes gives away a bike for free charity event and if she does, she leaves the price of the bike as blank but marks it as sold. So oh, she's super nice. So Sarah gives away to a charity. She marks it as sold but it's just left blank. She didn't make any money from it. Ready query to show her the average sale price of bikes for only bikes that were sold, not donated. Round the answer to two decimal places. This is a really interesting question. A little pat on the back, the old Alex here made a cool question. I like all the questions on here. I think they're all really, really unique. And then when I, and I haven't, you know, I did this a while back. So I haven't looked at this for like a month or two since we launched beta. I just remember there's a really cool question. So we have bike ID, the bike price and the bike sold. Now let's see. So this one was marked as sold, yes, but it's no, which means she donated this one. So we'll have to filter that out. And we're also looking for the average sale price of bikes for only bikes that were sold. So okay, let's start with this. Let's just take it step by step. Let's get rid of this. First, the bike has to be sold. So we're gonna say where bike underscore sold is equal to why? So let's start with that. So now all of these are yes, they've been sold but we need to filter out and this is not no. So we'll do and bike underscore price is not no. Let's run this. And there we go. Now we need to take the average bike price. Now let's see. Right here to show the average sale price of bikes for only bikes that were sold and not donated then rounded to two. So I think our output, and let's look, our output should be just a number. So let's see if we can get this. We'll do the average and then we're gonna do the average bike price with those conditions that we had. Let's run this. So we got 196.86, is that right? Oh it is, but we have to round it to two decimal places. So we'll do round and then we'll do comma two. So that'll go to two decimal places. Let's run this. So now our answer is 196.86 and 196.86. So when we submit this, there you go. Your solution is correct. Again, just a huge shout to the team for building this out.  Kasun and I have been working together in his team. We've been working together for over a year on this. This all is like just, it's so good. It's so good. I'm so happy with how it turned out. It's better than my original plan, if I'm being honest. I was not a graphic designer. I was an ideas guy, but him and his team really helped make it happen. So I say that's our team, but he's like, I would say the head of the team. Let's see how I did it here. Okay, I did the exact same. Sometimes I have different answers for how I do it. Now, uh-oh, application error, what did I do? Whoa, whoa, whoa, whoa, whoa. Let me go back to that real quick. I think I just had an issue with it. What was that question? Not temperature fluctuations, heart attack risk. There was a bike one, right? Bike price. What was the issue? Uh-oh, hey Kasun, if you're looking at this, maybe it's a, I don't know what the issue would be for that, but Kasun, if you're here, just take a glance of that if you can. Everything else is working. I don't know, maybe the, we're using, we use Vimeo to host our videos. Maybe it's a Vimeo issue, but the video explanation should work for you guys, so go ahead and try that out. Let's see, so I got that one right. So there we go. Now, I'm coming back here. Do you need to take the advanced MySQL course to find an entry-level data analyst shop? No, I think I really do recommend taking this MySQL for data analytics. If you take this, and let's just click and do it real quick. You're gonna learn querying basics. And by the way, some of these you can take for free, like you can just kind of like see what it looks like, so you can go in here and look at it. And then if you click on one that doesn't have that, you won't be able to access it, it'll just prompt you to buy it. But it's gonna teach you all the like basics of querying, and then it goes much more in depth. So data types and functions, this is probably something that most people don't teach on data types and all these different functions that are really useful. String functions, date, and date format functions, if functions, case statements, cast and convert functions. But then you'll do group, buy, join, subqueries, window functions, regular expression, how to actually work with files and importing them and exporting them. Then a whole data cleaning section on how to clean your data. And then of course, full projects. So there's two, it's quote unquote for projects, but it's world life expectancy data cleaning project, then the world life expectancy exploratory data analysis. Same with US household income, same for that.  The advanced one I think is more for people who wanna go a little bit above and beyond, you're gonna learn CTEs. So this is kinda like the intro to more advanced, I would say, CTEs and temp tables. But then the more advanced things are like store procedures, how those work, how you can actually use store procedures to kind of automate things. Triggers and events, which is how you, if data comes into a table, you can trigger that data to trigger a store procedure or cause something to happen. Then we have indexing, so this is indexing. And then we have a full project. These are automated data cleaning. Now this is a short course, it's three hours and 30 minutes, which is why I priced it a lot lower. So if you come over here, this is the shortest course, it's the lowest price, not because it isn't valuable, just because it's a shorter course and I think because it's shorter, you shouldn't have to pay a lot more. But these other ones like, this is my sequel for data analytics, which is the one I recommend taking, I think that one's like 11 or 12 hours, yeah. But it says 11 hours, that's 11 hours of content to actually go through the course, practice everything, build all the projects, that's several days, right? Cause doing it and replicating it and actually learning it takes a lot longer. So, just take that into consideration. If you're doing two hours a day, let's just estimate, it's gonna take three days of actual work to get it done. That's 24, 24, jeez, what's 24 times three? This is bad, this is bad, 24 times three. And then let's say you do it for two hours, oops, two hours a day, which would be a lot, that'd take you like a month to do. And so this course is not something that you should fly through. There's a lot of content, especially when you get to like the projects and there's questions in here like bad bonuses. So there's questions in here too. These should take you time. You shouldn't just fly through it and like get the solution and get the answer. You need to learn, this is for learning. So that's the one I would recommend. That's the one I'd recommend. My volume is a little low, low for you?  Kasun, how does it look? How is it sounding better? It's too low for me. I gotta lift this up, is that better? Let me, that should be good, that should be good. Sorry if the volume is a little low. How do you use regex functions in SQL? Well, take the course, it's in there. It's in there. Have you encountered anyone that has gained analytical skills but has not jumped fully into the data analytics career path? I am mid-career as a project manager and I hope that makes sense, absolutely. In fact, I get a lot of messages from different people who I wouldn't expect. So like my Excel for data analysis stuff on YouTube, I get a lot of accountants who take that. I get a lot of project managers who take that. What did you say you were?  So yeah, product management, program managers, data scientists, different roles in the data space who will take it. They're just like, I just need to learn how to use Excel and kind of analyze some data and they take it. Same thing for different roles. Like if you are working on a team that uses SQL, you should know how to use a bit of SQL to understand like how long things might take or understanding their problems so they can better help them, genuinely. Mamoon said this is the best time-saving course to be a data analyst. I'm not gonna lie, this is probably one of the, these courses are some of the best courses that I've seen out there. I didn't wanna make a course that was just like somewhere in the middle and then try to sell it. I genuinely tried to make the best course that you can find online, whether it's Udemy, Coursera, a different course platform. I tried to make the best that I can make better than other platforms and then I launched it, right? And so genuinely, I think that my SQL course, if you take that, you are gonna be genuinely really good at, you're really gonna understand what you're doing after it. And that's why the practice questions are in there too. Like throughout the course, you have all these different, there's 17 questions in the course. So as you're going through and you're doing data type functions, here's numeric data types. Then you have to do profit margins where you have to use those numeric data types or string functions or gamer tags. And just, you know, maybe I'm not saying it well. I force you, if you wanna complete the course, I force you to have to practice it. So I say, okay, if you want to use this, you have to know how to use this date and date format functions. You just have to, that's part of it. There you go. I'm also noticing that those gamer tags should be above this date and date format. I'll have to fix that later on. I won't fix it now, because I don't wanna go into the admin panel. But yeah, I mean, it's just, I don't know. I really, really, really, really, really put a lot of effort into this to make it really good. How much SQL should you know for entry level job? Everything in that MySQL for data analytics course. That's what I would take. Everything in that course. How much Python do I need to take the pandas course? That's a good question. I think you need to know up to like, just understanding, probably like data types and for loops. I think would be enough. The pandas course you could take, just straight out the gate. It would just be kind of tough to keep up, because you do, there's some Python stuff in there that I don't really dive into, because it's in the Python for beginners course. So, all that being said. Let me see, did I miss any? Like you said, it's learning and applying. Absolutely, I'm a firm believer that you need to learn it and then apply it through either projects or practice. And I do both in the courses. And I just think they're really great courses. How do you know that your course is better than others? Have you watched other courses before creating yours? Well, I was once not a data analyst. I was once a recreational therapist. And in order to become a data analyst, I took a lot of courses. If you go on my YouTube channel, going back three, four years, I have videos on best Udemy courses that I have taken, best Coursera courses that I have taken, different platforms that I've used. So for the past six years, I've taken courses on all these different things. And so because of that, I've taken, I took so many SQL courses, so many, because I just need to know it in my job. Because of that, I have a really good idea of what a good course should look like and what it should include in a lot that, and I've taken a lot that don't include some of these things. So I condensed all of my experience from the past seven years as being a data analyst and analytics manager, using these tools, and I condensed it and really dived into how it's applicable to you as a data analyst. And I walked through my thought process, I go really in depth, and then there's questions and courses, which is really good, just really good. So that's kind of how it's better. It just, if you were to take almost any other MySQL course, and then you forgot everything and then took my course, and then you somehow were able to compare, you'd be like, I think most people would be like, this was a better course. I genuinely believe that. Can a fresher become a data analyst? Yes. Wayne said, hello, Alex, thank you for creating the Analyst Builder. Are the achievements on the platform uploadable to LinkedIn? My name is pronounced one day. Hey, one day. Yes. So right now, I haven't, on this, I created a new, whoops. I created a new, you can also make it dark themed in the courses, but I created a new account here.  I haven't completed any of these courses, but once you complete the course, you can come over to completed and download your certificate. And it's custom to use, you can change your name if you need to, but you can download it and you can upload that directly as like a, directly as a picture. So you can download as a PDF or a PNG or you can actually, this becomes your public profile. So then when you earn a certificate, it comes right down here and you can share this link with LinkedIn or X or Twitter or anywhere you want. And then people can actually come here and they can say, oh, you know, he's got this badge in my sequel or this in Python. It's just fun to share. I wouldn't say this is like the end all be all of creating a portfolio or anything like that, but soon we'll have, you know, in the future, we'll have a place where you can upload your resume where you could share this, you know, and I think that's gonna be really, really neat. But I've only worked on my sequel on this one. If I went to my other profile, you'd see I was like a MySQL master. So I got that badge on my other profile because it's just really fun. And we'll be adding leaderboards and all sorts of other things. But these badges right now are not shareable because this is just a logo. But in the future we'll have a share button where you can share and download your badge just like you can a certificate, but the badge is gonna look super cool. It's like a really unique design and it looks really neat. It has the logo and your rank.  So that'll be really, really neat. Let me see if there's any other, oh, a bunch more questions just came in. Will it be a separate course or just more projects to help build one's portfolio? I do plan on having some, because I have a video on my YouTube channel on how to make a portfolio for free, add projects to it. I do think I need to add something specific to Analyst Builder and how to build that. So I will probably do that. And it'll probably be free. That video or that course or whatever I make, I'll be free on how to create a portfolio.  It says, I have a great passion for data analytics, but unfortunately in, I'm guessing in your country, Aria, or Aria, it isn't a common job, only two, three big companies hire analysts. Well, you know, these skills, and that's 100% true. There are some countries that don't hire as much, but here's what I will say, you know, especially in Europe, and then especially in the United States, and then, you know, certain parts of Asia hire a lot of data analysts. And so a lot of people will work remote and try to get those, or they'll try to get a visa to come to those locations to get those jobs. But I have found that a lot of people have been messaging me saying, hey, I got this job, which is the equivalent of something like a data analyst at this company. And they're like, there weren't a lot of data analyst jobs in my country, but they're like, at this company, I was able to use these skills to get this job, which is very similar. And so maybe it's not a data analyst role. Maybe it's called something different, or you can use these skills because companies are gonna use these skills. These skills are very transferable. So maybe for a different position, right? Can I use these questions as inspiration to do a project? Are the final projects of each course similar to those questions? The questions are like practice questions. They're not usually projects, but you can absolutely use them as inspiration. If you find a question that you're like, this is really neat or unique, by all means, try to create a project out of that. I think that'd be super cool. The final projects of the course are similar to the questions. No, the final projects are like real projects. Real data that I got from lots of different places, like gov.com, nasa.com, real places with real data, right? So the projects are like more realistic with realistic data cleaning and realistic stuff. Is Bessell and Sequel like this while practicing if it will make you a master sequel as a beginner in no time? Genuinely, I think Sequel can be mastered within like two months. Mastered is in like, you can get a job with it really confidently. I think you can learn the basics of Sequel in like a couple days. Then of course, the tougher stuff like Joins takes a little while to get used to and all the stuff in the course is like, it just takes time to get used to it. But then to reach like, you have to really know the skills well to get really good at it. There's a high, high, high skill cap for these skills. Does taking multiple courses, Sequel, does it help anyway? Most of the contents are the same, right? Have you done in your past journey? Well, I've taken a lot of different Sequel courses because one I was taking, at the beginning I was taking my Sequel courses when I didn't have a job yet that used Sequel. Then when I got a job using Sequel, they used Microsoft Sequel Server. So then I went and found a whole course just on Microsoft Sequel Server. Then I got another job and they used Microsoft Sequel Server and my Sequel. So then I had to go back and take a my Sequel and then I just wanted to improve my skills so I took multiple more after that. They all have a different variation, a different flavor. If I knew it already, I'd kind of skip over it. I'm like, okay, I really know aggregations in Group By, let me skip that section. But you can learn, I mean, if you take this course now and you learn from it, then in a couple, you build a project, you come back to it later in like a month or two, you'll learn something new because now you know more. So I'm a person that I like to take things multiple times and that's why it's a one-time payment on the courses because I want you guys to be able to just come back, take the course multiple times so you can learn from it repeatedly. That is kind of the thought process behind that. Hugh said, I just bought the Lifetime Bundle. Hopefully there are a lot of jobs in Vancouver. Absolutely agree. I've heard the Canadian job market is actually pretty good. I mentored a guy about two years ago who moved from Vancouver to Minnesota for a data analyst job, which was really neat. Just looking at my phone. My wife said she was gonna bring me food sometime. That was really sweet of her. I have no idea when she'll be here. There's a cool video of it in Analyst Builder Discord if you want to showcase the certificates and stuff. That is true. Is there any alternative for Python libraries for visualizations or huge data frame? Yes. Well, yes and no. Let me actually go over there. In the Pandas course, there is an introduction to Polars. Now Polars is kind of a smaller, niche library, but it's gaining popularity. Pandas is like one that everyone uses. That's why I created a course on it. But I even included in this course an introduction of Polars because I think that Polars is gonna be the future in five years. So I'll be creating a Polars course in the future because Polars is another data frame but it's built specifically for giant data frames. Now, there are tools that I have used in the past in my real work and that people have sent to me. There are tools where you can you can have Pandas work with super large data frames really quickly. Maybe it uses like a Rust backend or uses GPUs or CPUs to enhance the processing speed or something like that, right? There's a lot of different options. But Polars is a built-in library that's made specifically for very large data frames and it's based upon Pandas. So the very similar, it's not the same. If you go in there, I just talk about what Polars is, how it works and then I walk through Polars basics. Just an introduction to it, right? But Polars, I would look into that one. That's what I'd look into. Could your courses replace Google's certificate? My courses genuinely are much, in my opinion, are better than the Google's certificate. I was talking about this earlier. The Google certificate is for people who are just learning what data analytics is. So what is data analytics? How does it work? How do companies use it? They teach you the very, very, very basics of a few couple skills, which are good skills but then you get it and you're like, I'm not job ready. Then you go and take my data analyst boot camp for free on YouTube and you learn a ton from that. 10 times more than the Google data analytics certificate. I promise and it's free. Then you're like, okay, I know all these skills. I wanna dive even more and I wanna get ready for my technical interviews when I start interviewing. That's when you'll come over to Analyst Builder. So then you come over here, you practice these technical interviews to get ready for your technical interviews. You take these courses and these courses go more in depth into these skills. So if you're trying to learn Python or trying to learn pandas or MySQL and then soon to be Excel and Tableau and all these courses are coming soon. Then you learn these a lot more in-depth and you get better projects. So it's kind of like a progression, you know? And I just think the Google data analytics certificate today, when it first came out, it was really novel. It was like, Google's coming out with it. And even I reviewed it and I was like, this is really neat, it's a good introduction. But now where other things are out, like my free bootcamp, my free bootcamp is way better and it's free. I don't recommend buying the Google certification anymore. I just don't think it's worth it. Unless you're a complete, complete, complete beginner and just wanna know what's more about, my bootcamp kind of dives more into the skill-based, whereas Google goes more into the theory, if that makes sense. Let's see. You have any courses to recommend for a beginner in data analysis? Take the MySQL for data analytics course on Analyst Builder. This is recorded. This is, although I don't know how many people will watch it. This is gonna be like a five-hour live stream. So I don't know. I don't know how many people are gonna watch it afterwards. Let's see. Alex, I've been out of corporate for a year. I'm currently teaching, but I would like to go back to corporate, but I wanna know if you can add this to your experience in my CV and take some courses to add on my CV. What's, you mean like corporate data analytics or were you like corporate as in like a vice president or CEO of something? But then in the comments below a second, I can figure that out. What about NoSQL? Do you think it's demand growth? Ivy is NoSQL. NoSQL is really neat, but is definitely not as popular as SQL. Not even remotely. Like NoSQL is like 5% of the market, whereas SQL is like 90% of data analyst jobs have some variation or use of SQL. So no, NoSQL is pretty niche, but I used it in my last job, which was really neat. Thank you, Milton. That's what I need to hear. I took Coursera's Google Data Analytics course. Alex's program is far more thorough. I agree, and I appreciate the feedback. Could you please give us some tips or prepare a course on how to prepare for job interviews as a data analyst? Wait a second. I have my MySQL interview crash course, which is gonna help you prepare for interviews. But specifically on the skill side, but I think, okay, I see what you mean. Maybe just like an interview course. I might make that one and make that free, because that's one that I think everyone should just take and just have access to. But if you're looking specifically for the MySQL interview crash course to get ready for technical interviews, take this. I'm also gonna have kind of a subset of this one, which will be Python interview crash course. So it's just gonna come out in just a couple of weeks, and then the Excel one after that. But see how I'm looking up here. I look weird. I look weird as this webcam. I'm not a fan of it. Wish I had my setup. I'm not home if you're just joining. I'm not home right now because my internet went out and I didn't wanna cancel the live stream. So I'm up at my dad's school. Not ideal was not where I wanted to be. All right, let's go back, see if there's any more questions I'll do. I'll do another question. I really hope to gain one course of the giveaway. Sounds really good. Yes, I'll be doing another giveaway probably after the next question. I already gave away two courses and I'll be giving away another two courses. And at the very end of the live stream, I'll be giving one person the Analyst Builder course bundle, which will give them access to all five courses that are on here right now forever. And so I'll be giving that away at the end, at the end or near the end of the live stream, which was probably gonna be in like 45 minutes. I've been going since 9.30. I've been doing this for like three and a half hours now. Okay, my wife is heading to get me a sandwich. But now I'm nearing the end of the live stream. I don't know how much the long girl will go. We'll see. She might get here right near the end and then she can choose the winner. Whoa. Let's see. So does your course make a beginner job ready? I mean, the market is really tough for beginners. So how can your course make a beginner different from others in order to land a job? I think, well, one, you need to know the skills well to get a job right. I've always talked about you need to learn the skills well. So the courses really help you learn the skills. For applying for jobs, what is an extra part on top of your resume is you can have a project section and I have free projects on my YouTube channel. Recommend doing those. I think the projects in my courses are better. And so you can add those projects to your portfolio and a portfolio website. Excuse me. When you get into interviews, you can then point to those projects and be like, I built this project in SQL. Here's what I did. Here's how I used it. That goes a long way. I've talked a lot about that on my channel about not just when somebody asks, they use SQL in their job. You know they use SQL. You go into the interview and they're like, hey, how have you used SQL? Or how much do you know about SQL? And you're just like, well, I took a course. Well, you need to be able to point to something. Like, oh, I've used SQL to do data cleaning and data exploration. I'm really comfortable using joins and Windows functions and CTEs. And those are all things in the course. So it's good to point to them and just have you ready to do. But honestly, a lot of part of getting the job is after you learn all the skills, you need to know how to apply for jobs, which is where working with a recruiter, knowing how to use LinkedIn, knowing how to apply, like those things are really important. So, you know, this is like the learning phase, but landing the job is also an independent phase of, and I'm gonna have a whole section on the platform to help people land jobs in the future. But it's just not, you know, we're still, this is like, we just finished the beta launch a month ago. So, you know, in the several months, we'll have a lot more things on the platform. Um, do a master's degree help? Yeah, sure. I'm sure it would, depends on what it is. Right. But let me see. She am, sorry. Yeah, I'm just showing the platform. We're just hanging out. We're doing the full launch today, which I'm super proud of. You can go on the platform, you can get 20% off using this code. And I'm just showing off the platform to people who've never seen it before. I'm gonna also have a full video tomorrow about the platform. So that'll be like an actual YouTube video. And yeah, today's just a week for Analyst Builder to kind of do a harder launch because we did a soft launch with the beta. Had people tested out, fixed a lot of things, but now things are looking really good. We're starting to add new features like the point systems and the certificates and adding more courses. I just added the, I just added this pandas course like two days ago. So, you know, and I added new questions too. So, you know, we're kind of like, we're rocking and rolling now, I think is where it's gonna really take off because it took like a year to get to the beta. But now we're here, now we just get to build on top of our existing architecture and we can add so many new things. And we're hiring more people onto the team to add and push, I feel like a startup because we push so much stuff to production so quickly. It feels like a startup environment. It's been really, really fun. Let's see. Purchasing power parity pricing? Yes, based off location. I do plan on doing that in the future. We're trying to figure out how to do that with our current architecture with Stripe and then on the backend when you purchase something. So, we're trying to figure that out. I used to work as a data analyst, but now I'm teaching now, okay. I'm ready to start my career again as a data analyst. Okay, I see what you're saying.  I think being a teacher can, genuinely, it could be really neat. Although someone might ask you why you switched to teaching, but I think teaching, I've told a lot of teachers, like teaching is a really good skill to kind of go into to have because you have to have really good communication skills, really good soft skills and the ability to present information well. So, you can really lean into that if you want to. But since you already have data analyst experience, you could leave it off your resume and still be fine. You couldn't. Let's see. I'm getting to the last interview, but so far I'm not chosen. I think a motivational course would be great. Hey, man, I can be super motivational. I thought about making like a video about that. I'm just like motivating people. I love motivating people. I really do. It's definitely a passion of mine. A master doesn't feel like GIS, not specifically Python or SQL, et cetera. Yeah, could be, could definitely be helpful. Could definitely be helpful. I just, I, it's hard to say, right? It's hard to say exactly what field you want to go into or what you want to do, but a master's can definitely be helpful, for sure. Now I'm going to go back real quick. We already solved this one, didn't we? Yeah, we already solved this one. I'm not going into this one again. All right, I have this on free. If you haven't already, check out these free questions you can take them for free. All you have to do is have an account. My wife has a sandwich, she's buying a sandwich for me, but she doesn't have the key to get into the building. So in like one minute, I may, a few minutes, I may have to like sprint downstairs, open the door. She'll come up and then I'll, I'll come back up really, really quickly. Let's do that last hard question. So I'm going to filter on incompleted ones. I'm going to go down and find that hard one. Here's Kelly's third purchase. All right, let's get ready, because this is another hard one. So I've solved two hard ones already. This is the third free hard one, that I believe is the last one. Let's see how we can solve this. Kelly's third purchase. This says at Kelly's ice cream shop, Kelly gives a 33% discount on each customer's third purchase. Write a query to select the third transaction for each customer that received this discount. Output the customer ID, transaction ID amount and the amount after the discount as discounted amount. Order the output on customer ID in ascending order. Note, transaction IDs occur sequentially. The lowest transaction ID is the earliest ID. That's important. I'm glad whoever wrote this, aka me. I'm glad they added that because that is important. Now let's go look. So we have customer IDs and we have the transaction ID and then we have the amount here. So we need to, the first thing we need to do is identify, well, there's actually multiple things we need to do. Here, let me post this question real quick if you wanna try this with me. Try this question with me. There we go. What's this ID plan to bring over all the free training on YouTube as an intro course and analyst builder? No, that's just gonna be on my YouTube channel. This is gonna be all content that is mostly gonna be premium, more in-depth content on here. The YouTube stuff is just gonna stay on YouTube. It's not, and I'm gonna keep adding to it. I'm not, I don't plan on not doing it. My wife's texting me. Give me one sec. Yeah, I'll probably go to two o'clock. She said she's gonna be here in like 30 minutes. I thought she was close, but she's like, just leaving the house. She has to go get the sandwich at them, so I got plenty of time. But in just a second, after we finish this, did I say that earlier? After we finish this question, I'll be doing a giveaway of two courses, and then near the end of the live stream in about one hour, I'll be giving away this analyst builder course bundle, where you can get all five of the current courses that are on the platform. So one lucky person. So let's come over here. So what we need to do is figure out the third transaction for each customer. Now, I already can tell, because we're gonna need to figure out the third transaction, we'll have to use some type of Windows function. Since it's sequential and all transaction IDs should be the same, we most likely can use row number. We could use rank or dense rank as well. Honestly, I believe any of those will work, but we'll just use row number to keep it simple, keep it the most straightforward, I think. So here's what we're gonna do. We need to add to this. We need to order this on customer ID. And based off of the customer ID, we have to order on the transaction ID as well, because the transaction ID is sequential, right? So the lowest transaction ID is the earliest ID. Then we do the earliest, second earliest, third earliest, that's the third transaction. That's what they should be getting the discount on. So let's see how we can write this. Let's try row underscore number. We're gonna do the row number on, I don't think we need to do it on anything. We're gonna do it over. Let me see. We're walking through this problem together. Now, this is a hard problem. Then remember, this is a hard one. So we're gonna do row number over, I think we just need to do order by, let's do customer ID, comma, transaction ID. Let's run this. Okay, so let's take a look. So we have a customer ID of 1001. Then this is the lowest to the highest. So this is the third transaction right here. And let's just confirm. Let's just confirm this. So this person had five transactions. So then we have two, two, two is the same person. Then this is in order. And uh-oh, that's not it. Because I need to partition this. Because right now I'm just doing it on customer ID and transaction ID, but the row number is being applied to all of them. So I have to partition this. So I need to say partition by, and we wanna partition it by each customer. Because we have to separate up for each customer's transactions. So the customer ID, let's go right here. And when we run this, this number is gonna reset. It's gonna go one, two, three, four, five. Then at the next customer, it resets. One, two, three, four. One, two, three, one, two, three, four, five. One, two, three, four, five. So now we need to select just this third purchase. Let me make sure. And then we need the discounted amount, okay? So I can do this in a few different ways. I can do this as a subquery, and if you weren't watching the previous stream, I'd been using CTEs and two separate problems. I'm gonna use a subquery just to change up a little bit. We can use this in the from statement. So, or yeah, from clause or from statement, I can't remember. But we need to label this. So I'm gonna label this. The table name can be as, we're gonna call this. I'm gonna label this too as purchase num. There we go. Spelling issues. So we'll do this as purchases. We'll just do that. So select everything from this as purchases. And what we can do is we can then filter on this. Now, let me go back just a second because if we're gonna use this as a learning opportunity, I'm gonna do that. So if we run it just like this, we can't then come in here and say where, and then we'll label this, I'm gonna say as purchase num. We cannot say where purchase num is equal to three. I just can't say it. And what if I do having? Can't do that either. So we cannot filter on this just within that query. That's why we're doing what we're doing, which is we're making this as a subquery. So we're saying from all of this, we'll do select everything and we'll run it. And what do I do wrong here? Oh, I gotta label this. So I'll call this purchases and we're just renaming, because this is the purchases table and so we're just kind of renaming it. But I could call this purchases underscore numbered. You do that too. So now we have this data, but now it's in like this subquery, which is kind of like a little temporary table that we're just querying off of. So now we can come in here and say where the purchase num is equal to three. And now we can filter it down. So now we have all their third purchases. Now the last thing we need to do, so we need purchase ID, transaction ID, amounts and the amount after discount. So we need to figure out these first or we have to get these first. So we have to get customer underscore ID, then we need the transaction ID, then we need amount and we're not gonna keep this purchase num in our output. We're just filtering on it. But now we need the discounted amount. So I'm gonna say as discounted amount because that's gonna be the name of our column. What we need to do is we need to calculate the discount. It says that she gives a 33% discount on their third purchase. This is their third purchase. So we need to do this and give them a 33% discount. So we have to take the amount and multiply it times a 33% discount to give you a calculator view of it. If we have, let's say $100, if we multiply it times 0.33, which is 33%, that gives us what their discount is going to be. That doesn't give us the discounted amount. What we, because the final price should be $77, right? So what we need to do is 100 times 0.67. And I didn't do that right. Give me a sec. 100 times 0.67. So that's gonna give us $67. Is that correct? 67 to 33? That should be correct. I think before I said 73 or something random. Yeah, it should be $67. So that's the discounted price. So if it originally cost 100, we gave a 33% discount, our final price is 67. So what we need to do is we need to do the amount, which is this amount right here, times 0.67. And let's run this. So now here's our amount and then here's our discounted amount. And we also need to do one other thing because we're really close. We just need to order the output on customer ID in ascending order. So we'll do order by, and we'll do, and I need to spell that right, order by, and I'll just copy this, customer ID in ascending order. Let's run this. This should be our final output. I'm not even gonna check the expected output. I'm not even gonna look at the hints. Let's just try it. And there we go. We got the correct solution. We nailed it. Let's see how I solved this before or how I tell people to solve it. Yeah, essentially the same thing. So we use this row number and we partitioned by the customer ID and then we ordered by the transaction ID. Now, I ordered by the customer ID and transaction ID but you don't need to it looks like but I think it's better to do it. So maybe I wanna update that answer a little bit but then then we put it in a sub query and then we filtered on it. So that's exactly how I would do it. And then we got it right and because of that we should be closer in our rank. Now we have 320 points, we're almost to 500. I think those are all the free questions of that are hard.  Yeah, we'll see, we'll see. But all right, let's see. Alex, your webcam is stuck. Yeah, I believe that. Let me go over here. I'm using public wifi. Let me activate it. Oh, is it working now? Oh, what am I doing, maybe it's this. Give me a sec. I'm not at home because my internet went out at home and it was really unfortunate, really unfortunate. There we am. All right, I'm back. Thanks for telling me. Seems like rank should be used here. Well, you could use row number, rank or dense rank because there's no duplicates in the transaction ID. And let me go back. Actually, let me go to the data. Because there's gonna be no duplicates in the transaction ID, it doesn't actually matter. Because if you use rank or use dense rank, it's gonna look like one, two, three, four, five anyways because there's no duplicates. Rank and dense rank only are useful when you have duplicate, you have non-unique numbers in a specific column. That's the only time where they're needed. So yeah, you don't need to use rank or dense rank, although you could, you just don't have to. You just don't have to. Setting up my phone for when my wife gets here. Let's see. See, am I better now? Yeah, now I'm moving. I appreciate you telling me about those, that is by the way. Hey, Alex, is the lifetime purchase also part of that 20% discount? Yes, it is. It absolutely is. So you come over here, you can apply this discount to anything in here, any single thing you want, and it will work. So yes, it applies to the lifetime access as well. The SQL course on Analyst Builder is more in depth. Yes, it is. Oh, who was asking? I must have missed it. Do you plan to bring over? Oh, never mind. Let's see. Where you have, where purchase num is equal to three, could you put where purchase num is divisible by three, in case someone has multiple purchase, which are multiple three? That's not what the question says. It just says that it says, select the third transaction for each customer, because on each customer's third purchase. So it doesn't say third, sixth, ninth. That's actually a really good thought if it was every third purchase, but it says only the third purchase. So the wording is just a little bit different, but that's actually a really good thought. So if it's divisible by three, so if it was three, six, nine, 12, 15, 18, that's actually really, that's a good note. So yeah, really interesting. So all right guys, I just finished that question. It is time for another giveaway. I'm gonna be giving away two courses. Now, you can choose any course you want. You can choose this one, this one, this one, or this one, whichever one you'd like, and I will send you a code to get it for free. Now, how this is gonna work is I'm gonna tell you to put something in here, and I'll type it in in just a second. And someone who puts that in there, I will choose them. Now, I do this based on the Honor system, and if I choose you, just send me an email to alextheanalystyt at gmail.com, and I will give you that free course. It is not, the Analyst Builder is cool. Nice try, are you? I'm sorry, it is not that one. It is a new one. All right, I'm typing the code to do in here. I'm gonna wait just a second. The code is AB for life, AB for life. That's Analyst Builder for life because nothing's better than Analyst Builder. I was going somewhere else with that, but then I just stuck with it. But it is Analyst Builder for life. Type that in the chat. I will choose someone in just a little bit. I'll choose two people to get two courses. Are there any available positions in Analyst Builder? No, not right now, although I do consulting, and I've been really considering bringing someone on. Can I do it all myself? So I've really considered bringing it on for just to expand the business. All right, I'm gonna choose two people. Josh Kitchen, if you don't know what this means, that means he supports me on YouTube. He hit that join button. He just did it out of the kindness of his heart. There was no obligation to do it. So Josh Kitchen, I'm giving back. All right, Josh, shoot me an email. I will get you a course of your choice for free. Just tell me which one you want. I'll send you a code. Now I got one more person. Let's see who I see in here. Let's see, Alina Avalos. Avina Alina Avalos.  Now listen, in about when my wife gets here, that's what I'm gonna say. When my wife gets here, I will be giving away the bundle, okay? So stick around for that if you wanna win that. But both you guys shoot me an email and I will get you that course on her system, guys. Okay, it's all about kindness and love around here. Now in just a little bit, I'll be doing one more giveaway where I will be giving away this bundle right here, the Analyst Builder course bundle where you get all five of the courses on this page, which is SQL, Python, MySQL, Pandas, Advanced and a Crash Course. So one person will win that in a little bit. And I plan on doing more giveaways in the future. I love doing giveaways, especially because we're at 642,000 subscribers. When we get to 750, I'm probably gonna do a big giveaway then of some of the lifetime plans. So just be aware that I'm gonna be doing that in the future. I do plan on doing some big giveaways, milestones or milestones for Analyst Builder as well. Absolutely. Now let's go back real quick. Here's the incomplete. These are the free ones that we haven't completed yet. Now let's see what we have. Okay, we still have quite a few, but we did all the hard ones. Now I did those hard ones because they were free and then you can try them. But if we come over here to the hard ones, there's a ton of hard ones. So if you get a subscription or you pay for the lifetime or go to pricing and you look at that, you can get access to all these ones. And these are really neat ones, really, really cool one. I like this unfair taxation one. I think that one's really neat. And then Janine, this is one I was showing you earlier. This is one where it's like data cleaning, where the data's bad and this column, you have to clean it. I'd really tried my best to make these really fun and just like really interesting. I genuinely think that these are just like so fun to do. That's why I like doing them right now. So let's go back to the free ones. Excuse me, my nose is itching. And let's choose one in here. I want to choose another one. I'm gonna do some moderate ones. I really do, because I wanna get to that next rank. I don't know if I'm gonna have enough time. I talk too much. LinkedIn famous, who divides us? What's this one? Okay, okay. Yeah, maybe I'll do this one. Because we haven't done one with Group Buy yet that I've demonstrated to you guys, but there's lots of questions in here with Group Buy. Let me put this question in the chat. Yeah, congrats winners. Thank you one day. Just got to hear how much I lost on the giveaway. We just gave away four courses in the past. I've been doing this live stream for four hours. But I'm gonna be doing one more giveaway where I give away this Analyst Builder course bundle of five courses. So let's see. I'll do this question once I answer a few more questions. So is this like a better version of your data analyst bootcamp on YouTube? Yes. It goes more in, well, let me take a step back. The courses are kind of like the data analyst bootcamp, but these go a lot more in depth and there's questions built in. So like let's go to this. This is a pandas for data analysis. Let's go down to filtering and ordering. So there's questions built in. So you're gonna learn about string methods and you'll learn how that works, what they are. And then you'll have to apply it in a question and you cannot go, well, you can move on. You could skip it if you want, but you can't, to finish the course, you have to do these questions. And so it's built in, which is really neat, but then the projects themselves are like really, really, really good projects. They're more in depth, more kind of, I would say slightly more advanced projects. This one's the movie genre data analysis project. And then we have the food marketing data analysis project. This one is like, this one is my favorite project I may have ever built. I think it was just super, super, super unique and really cool. I think you should add it to your portfolio. I give you the CSV. I give you a PDF kind of describing what it is. And then a data dictionary for it. One of my favorite projects, how long is this, an hour and a half? That's a long project, but it was a good project. Those are my favorites. So that's what the courses are. But something that obviously my YouTube channel doesn't have is there's a coding section where you can practice for technical interviews. My itch is, my lip is really itchy right now. I apologize. So you can come in here and you can practice for your technical interviews. So when you start applying for jobs for everyone out there when you start applying for jobs you're going to get technical interviews. And a lot of them are going to be in SQL or Python the vast majority, most of them being SQL. And so this allows you to come in and practice some of the questions that you'll probably like the types of questions that you'll get asked. If you aren't interested in that this is still a great way to learn. So you can just come in here and practice MySQL, PostgreSQL, Microsoft SQL Server whichever flavor or Python and we'll be adding more flavors as it goes on. Like R and a few others that I don't, I'm not, we have to figure make sure we can integrate it into the system. So I'm not going to, you know start talking about other ones that we have planned but we'll integrate R and then hopefully some other ones as well. Let's see, on media addicts but this whole section is nothing that like what I have on YouTube. And so this is just like a really great resource and way to learn and practice for your technical interviews. Apart from this coming, you know next year we'll have a lot of new features and functionalities. We'll have a project section where there'll be full length projects. We'll have a resources section where we'll have all sorts of different resources like resume templates and communities and all sorts of different things. So, you know, this plot this is like the most the minimum viable products and MVP but now we're going to be building it into a huge, huge thing. It's just going to be amazing. It's going to be amazing. Now I'm going to answer this question and then I'll come back. Actually, let me see if anyone else was asking questions. The volume may be a bit soft and I'm really, I really do apologize for it. Hey, congratulations, Alina. You are most welcome. Thank you for being part of the live stream and thank you for checking out Analyst Builder. I'm really excited to hear your feedback. Just shoot me an email and I'll send you a code for it. Does Python and SQL enough to be a data scientist? Depends, you need to know certain things within them. It's like with Python, you'll need to know certain, you know, machine learning concepts and models and stuff like that. Let's see. It's a marathon stream. Yes, I've been going for over like almost four hours. Oh, four hours now. It's a long one. When do you subqueries? Subqueries, you could use subqueries. You can use a lot of different things. It's very dependent on the query. You can use a lot of different things in a lot of different places, but subqueries are good for, we need to look at like a small portion of a table. You don't want the whole table, you just want a portion of the table. There you go. Anyways, let's keep going. In just a little bit, my wife's such as bringing me food, which is extremely sweet of her. And when she does, I'm going to have to run downstairs, let her in, because I'm not at home, if you guys didn't notice. I'm not at home because my internet went out of my house. So I'm at my dad's school in a random room. That's exactly what happened, but I'm in a random room. And so I thanks dad for letting me in the building. So I'm gonna do this question. I might do one or two. I was trying to get, by the way, trying to get to the second rank. So as you learn these skills, you earn points and you can rank up. I've just been talking a lot during this. I've done several questions, but you earn less points for easy questions and medium questions. The hard and the very hard, you earn a lot of points, but you also learn a lot of points by taking a course. If you take a course, you earn 500 points. If you take a crash course, you earn 250 points. And so you can rank up in your skill. Now you can also earn certificates and put them here. This page is shareable. So this page you can share and you can write something in here. Let me do that real quick because I haven't done that. Go to settings. Here we go, wait, here we go. I'm a data analyst, YouTuber who loves analyst builder. I'm just saying things. I'm gonna save that. And then if I go back to my profile, it's right up here. And so you can earn badges in Python and my SQL. And then when we have courses and projects, you'll be able to learn Excel badges and Power BI and Tableau badges and all that stuff. This isn't shareable just yet. We're creating the custom badges for this that you can share to social media and other places. And then certificates you can. Certificates you can already share. So once you complete a course, like if I go to my dashboard, once I complete this course, it'll be in this completed section. It'll say generate certificate and you can go ahead and do that. Meet me at the entrance in five to 10 minutes. I'm gonna tell her one second. I am still in my live stream, period. When you are here, let me know and I'll run down and let you in. Hello, the super sweet of her. She just got me a sandwich and I really, really, really appreciate that. Where was I? I need to go back now, don't I? There we go. Food divides us. All right, I'm gonna do this question. I might do a few other questions and then we'll do the big giveaway at the very end.  This may be the perfect time that you join. You may be the lucky winner. This question says, and just so you know, you can share a lot of these things. Like the courses you can share with people. You can come in here and like share these with people.  A lot of this is like the social stuff is just to show that you're learning and advancing and learning new skills. Same with certificates and badges. Like it's just really cool to share and you know, share with people what you're learning. And so if you really like this question, you can share that online. Just copy that and or click on one of these things and it'll automatically populate it for you. Now, this question is food divides us. It says in the United States fast food is the cornerstone of its very society. I don't remember writing that but that's funny. Without it, it would cease to exist. What was I thinking when I wrote this? I think it's funny though. But which region spends the most money on fast food? Where I agreed to determine which region spends the most money on fast food. That was repetitive but which region? All right, so let's look at our data. So we have the state, we have the region and we have the fast food millions. So really all we need to do is work with this region and then do a sum of the fast food millions and then filter to see which one is the highest. I believe that should work. So let's come over here. We're gonna need to do the region and then just for now I'll take the fast food millions but I'll have to do a group by on that. So what I need to do is I need to come down here. I need to say group by and we need to group all of these regions. Wait, why is that in my output? Why is state in my output? Select region fast food millions. Let me refresh this. Maybe something weird is going on. Let me see. Select everything. Uh-oh. My SQL, my SQL just, it's probably post-gray SQL. Oh, post-gray SQL is working fine. Because soon if you're looking, if you're watching this, maybe the servers are a little overloaded. It's our launch day so maybe that's the issue but our server should be able to handle it. Yeah, I'm not sure what's going on with that. Let me try it in post-gray SQL real quick. I'm gonna try to test this while we're on it. Let's do region. Okay, so that one worked. Let's copy this. Let's go back over here. Let's do fast food millions. I'm just queueing this while we're here. Okay, this is an issue that I thought we had patched up. It's just a small issue where sometimes it doesn't recognize that it's my SQL. It's reading in the post-gray SQL code instead. And so, because soon if you're watching this, if you wanna take a look at that. CT over subqueries, I usually prefer CTs, if I'm being honest. And someone asked what order should we do the courses in? So not all of my courses are done. I'm already done recording the Excel for data analysis course. It's being edited by my editor right now. And I'm recording the Tableau course. Once that one's done, those are my core courses. Then I'm gonna do AWS Azure course and then an AI course.  If I were just starting out and I was watching this and I've never taken a course before, take the MySQL for data analytics course is phenomenal. And that's the one I would take. Next one I would take is the Python programming for beginners and then the pandas for data analysis. Those are the three that I would start with. If you really wanna dive even more into MySQL, I do the advanced MySQL for data analysis. And then if you have an interview coming up, you can do the MySQL interview crash course. So those are the three I would do though, in that order. Let's see. Yeah, sorry, we're not doing the giveaway just yet. We have one more, what am I looking at a calendar? It is 121 and about 30 minutes or maybe when my wife gets here, I'll do, unless she doesn't come up. If she doesn't come up, then I won't do that. Oops, but let's take a look. And yeah, the MySQL is just being weird. I think that might just be me. It might be localized to just me because I've been on here too long, I don't know. But I'll have my team look into that one. So we have the region and we need to group by the region. So we need to group by, and then we'll do group by region. We can run this, oh, there's a comma here. And we can run this. So we have Midwest, Southwest and Northeast. Now all we have to do is we need to figure out which spends the most amount of money on fast food. So we need to do the sum of the fast food millions. And there we go. Let's run this. There we go. Now we need to order by. So we'll do order by. And for simplicity purposes, I could do it like, I'll just do two, right? Order by two. Oops, descending. Now is this perfect the written SQL? No, it's not, but it's gonna get us the answer. Now I'm gonna limit it to the top one. Now this is a moderate question. If this was a more difficult question, I may have to do a subquery and then rank it. Cause what if this was tied? What if this person had 1,043 as well, or West had 1,043 as well. Then we would wanna select both of them cause they're tied. But since we can visually see it's not, I'm just gonna select the top one. And we don't actually need this region anymore. Let me see. Cause I need the output needs to be just the region. Let me think, how would I do that? Order by. Oh, I don't even think I need that. I think I need to do this in like this. Get rid of this comma. Now I'll explain this in just a little bit. There we go. There we go. That's how you answer in one in a simple query. So right here, I could see that the sum was the highest and we're limiting it to one, right? But in our output, we only wanted to select the region. So I can't have this in my output. So what did I do? All I did was I said, okay, I know that this works. Excuse me. So I put this in my order by. So now we're ordering on a column, but we're not gonna keep it in our output. And my wife just said here, so give me one sec. I gotta submit this is more important. Sorry, wife. I'm just kidding. You're more important. Anyways, I'm gonna run this and our solution is correct. All right. Let me add a note. I'm gonna say be right back getting food from wife and then we add a little heart. All right guys. So we'll be back in like 30 seconds. Give me just a second. She's right downstairs. Oh my goodness. Oh my goodness. I've never ran so fast in my life.  Give me a sec. You ran so fast, I got it. All right guys, I'm back. All right. My wife bought me a sandwich and a brownie. Best wife ever. Thanks, baby. I know you were watching this, so I appreciate it. Now listen, my wife didn't come up. She said, I know you're doing a live stream. She had places to be, better things. Sad, but, oh my goodness. I'm out of breath. It's running too, it's running lightning speed. Anyways, I am back and very soon, probably the next couple of minutes, I'm gonna be giving away one Analyst Builder course, but I know we can win all five courses. Let me catch my breath for a second because I was actually running pretty fast. Up and down stairs too. It's not pretty. It's not pretty. Now I got that solution correct. There we go. And I earned some points for it. I'm almost at 500. But hey, listen, I've almost reached, oh, I didn't post Gray's Seagull. So I earned 25 points for that moderate question. But listen, as you take courses, as you do questions, you earn these badges. Soon, we will have a thing where you can share your badge with people, which we're gonna have a really cool design stuff. It'll just be like, it's something cool to share. It's like, you got a lot of points there, it works really hard to learn this skill. Now give me a sec. I'm gonna take a breath, because I actually was running a lot. Ooh, oh my goodness. I'm just gonna rate these. Yes, it does. The Lifetime Access to Analyst Builder includes all future courses and questions. So you just get, as I roll them out, you get them. You're most welcome, you're most welcome. Thank you. I'm glad that you liked the livestream. Thank you. Thank you, Arya, I appreciate it. My wife texted me, sent hearts. She was listening. She got my message. Let's see. Yes, best wife ever. Yeah, ooh. I just lost, lost, I'm gonna gain it back with that brownie she bought me. She shouldn't have done that. Oh my goodness. Cardio for life. Oh boy. Um, so the courses that I have right now do not cover statistics, but the Excel for Data Analysis course has an entire statistics module.  I don't think I have enough that I think would be valuable to make an entire course with. But I do have an entire section or module. It's like six lessons on statistics in the Excel one. Now the Excel one's already done. It's just being edited. And then it'll be released. And that one, that one covers statistics. I think is all the statistics that you'll most likely use, especially as like beginner and intermediate. I'm in deep. Thank you for joining the live stream. I really appreciate it. Really, thank you, Wanda. I really appreciate it. No, they don't teach database administration. It's mostly data analysis. Yes, SJ, yep, I'm sorry. I just missed it. The beta prices are gone. And the beta prices were much lower price, not much lower. They were slightly lower price because when people were working through them, they were finding bugs, right? We were a new platform. We had just launched. So people were figuring out bugs and all these things. And it was really appreciated that there were so many people giving valuable, good feedback. It really was. And now we're doing the full launch. And we'll do more promotions like this where we'll do big discounts and stuff. And that'll be really fun. And I'll do giveaways because I love doing that. And so, yeah, lots of fun stuff coming. All right, let me do, here's what we're doing. I'm gonna do one more question. That's it. Then I'm gonna be doing a giveaway of this Analyst Builder course bundle. That'll include all five of these courses. To one lucky winner. I'll be doing more giveaways in the future, so don't worry. But I do want you guys to check out the platform. Like I really do. It's just, I'm super, super proud of it. So I'm just gonna share this in the chat. I'm gonna try out the questions here. There you go. Let's see. Just trying to go up here. So let's go back to the free questions because that's what I'm trying to do them with you so that anybody can do them. And let's go to the difficulty. We've already done the hard, I think. Yeah, we completed all the hard ones. So the temperature fluctuations, cake versus pie, Kelly's third purchase already did it. So let's get rid of that. Let's do moderate. And let's see. Let's also do where I haven't completed it. So let's choose one of these. Senior Citizen Discount, LinkedIn Famous Media Addicts. Let me see what this Media Addicts one is. This is an interesting one. I like this one. Let's try this one. We'll do this one and then we'll do the giveaway. All right, so this is Media Addicts. Let me share it with you guys if anyone wants to try it with me. Try this question with me. There we go. We'll keep on postcards. I don't think it's gonna be any different. Now, this says Media Addicts. Social media addiction can be a crippling disease affecting millions every year. We need to identify people who may fall into that category. Write a query to find the people who spent a higher than average amount of time on social media. Provide just their first names alphabetically so we can reach out to them individually. So we actually have two tables here. We have the user ID and the media time minutes. And then we have user ID and their first name. So we're gonna have to use both these tables because we use the minutes to determine if they're higher than average. And then we have to have their first name in the output. Just their first names alphabetically. So the first thing that we need to do is identify the average time spent. And that's under user time. So what we can do, let's run this. What we can do is we can do the average of media time minutes. So just like that. So this is the average, let's just round this just for visual purposes of nothing else. So the average is 282 minutes. I believe that's maybe per day or something, we'll see. But that's the average. So if they have higher than average, that means that they fall into the category of social media addiction. So what we can do is we can select, we can say, oops, we'll say where media time minutes is greater than the average. Now I'm just doing this for visual purposes because what we'll do is we'll say select everything or actually everything comma. Let's run this. What did I do? Oh, aggregate functions, let me do having. What am I talking about, what am I even doing? Here we go. Aggregate functions are not allowed in the where. Oh, what, I am the last question of the day and I'm losing it. It's because we need to use a subquery. So I can just do it like this. Where select that from user time. Last one of the day and I'm just losing it, losing my mind. I just need to wrap this in a parenthesis. Let's try this. Select from user time. Let's see. Okay, I'm about this needs to be where. Select everything from user time where the media time minutes is greater than the select, maybe it's the round, I don't think it is. Oh, oh, yeah, no, that was an issue. So if I go back, I didn't have enough parentheses. So if I actually add this parentheses right here, let me see, use an aggregate function. Let me read this. This user time user ID must appear in the group by clause or be used. Oh, it's because I had having. What, this keeps changing on me, that's confusing me. It was the issue earlier was I didn't have this, what's it called, parentheses closed. That's the only difference, that's the only thing. So the average was 282 and all of these people have higher than 282 media time minutes. Now what we need to do, because the names aren't in the same tables, now we have to join this to this table. So we have to join this to this user's table. So I need to come here and I need to say, join to the user's table and I'll say on, it's gonna be user ID is equal to user ID? Yeah, so we'll do user time dot user under square ID. Is equal to users dot user ID. Thank you, autocomplete. So let's run this. And where's the first name? That's being weird. Oh, it's because I selected everything. Oh, okay, okay. So let me come here, we'll do a first underscore name. There we go. So now we have Adam, Chris, Christine and Bella, but we needed to provide their names alphabetically. The very last thing that we have to do is we have to order by, and we'll order by their first name ascending order, which it looks like, no, it's not, it's ACCB. So it's not an ascending order. First name ascending, let's run this. And we have Adam, Bella, Chris and Christine. And let's just double check the expected output. That's perfect. Let's go ahead and run this. And there we go, our solution is correct. Perfect, nailed it. I didn't do great at first, but I nailed it in the end. All right, so let's come back over here. Awesome, let's see if there's any more questions. And then we're gonna wrap it up. I've been doing this for like four or five hours now. So it was the longest live stream of all time. And we're at the lowest streams, which means you have the highest percentage of winning now, then you have throughout this entire live stream. Cause at the first giveaway, there was like 300 people. The second giveaway, there was like 180. Now there's like 117. So you're doing great. Let's see. Analyst Builder is fantastic. So glad you quit your job for us. Thank you to you and your wife. Absolutely, thank you, that's very, very sweet of you. Which career language can I do with NodeJF? I'm not sure. Great design for a platform, thank you. First time working with pandas, forget about the heart attack, awesome, good work. Are you still here? Yes, I'm still here. Let me see if my thing, oh yeah, it's still working. It's still working. Nailed it, that's right. Yep. No, I don't plan on increasing the price. You know, maybe like two years or something with inflation rates and whatnot. Believe it or not, this website is actually not super cheap to maintain. We have a lot of AWS servers running. We have different clusters. We have different products and services running on the back end that cost quite a bit of money. And so, you know, unfortunately, this is not free, but I don't want to increase prices that much. It just, it doesn't feel right and I don't like doing it. I don't like what other people do. So I'm gonna try to keep the prices as low as I can, genuinely. I don't plan on like, as this gets more popular, raising the prices and raising the prices, raising the prices until like prices people out. I really wanna keep it very affordable for everybody. And so if this is something that you can afford and you're like, I can afford that because I know I'll be using it for the next six months, eight months a year and you're not gonna get all the new courses and the questions and the resources, then I'm really happy to hear that. This to me is, this is how much you pay for Coursera for one year. So if you buy Coursera for one year, you can get Analyst Builder for life, including all future courses, all future questions and everything. We talk more about the difference between lifetime courses and lifetime questions. Yes, if you just go to the questions, this is unlimited access to questions for life. That's just this questions page. That's all it is. The bundle, the lifetime access to Analyst Builder is gonna give you lifetime access to all questions and all courses on Analyst Builder forever. So that's all future questions, all future courses that we add, then you will have access to them, all of them forever. That is the difference. All right, we're doing the last giveaway now and then I'm gonna end the live stream soon afterwards. But the winner can email AlexAnalystYT at gmail.com, email this for a winner. All right, here is the last one. My beautiful wife brought me, oh, what is it, a sandwich and a brownie. So we're gonna say AB Brownie Love. That's all it is. That's our code. I'm gonna wait for just a second. AB Brownie Love. And if you type that in the chat, and thank you, Christine, for this, I really do appreciate. I'm gonna eat all this food after the live stream. I don't feel right, it doesn't feel right eating it when people are watching, so I'm not going to. But go ahead and put that in the chat and then I will choose someone in just a little bit. There is no rhyme or reason to it, but if you are chosen, just please shoot me an email. I go off the honor system. I've never had an issue with it in the past, so if you win, shoot me an email and I will get you a code for that and I really appreciate it. All right, I'm gonna choose one person. Again, I'm gonna be choosing someone for this Analyst Builder course bundle. There's gonna be all five courses that are on the platform right now, but again, there's more courses coming, already completely ready to go, or almost done editing. All right, I'm gonna choose in just a second. Whoa, there's a big uptick. Give me a second. I'm gonna, I'll scroll back up in just a second and then we'll see who I got. All right, let's take a gander. All right, we got Austin Glenn Dinning. I just thought that last name was cool. That's the only reason I chose it. Austin, go ahead and shoot me an email. Congratulations. I really hope you enjoy the courses, really hope you enjoy the platform. Thank you for joining the live stream. Thank you for everyone for joining the live stream. I want you guys to, I want you guys to know I really do appreciate you watching and joining and for all the support you guys have given because I feel incredibly, incredibly blessed and I hope you try out the platform. I really, really do. I'll be doing more live streams and more giveaways like this. And so I hope that you guys can join and try out the platform. I see this platform becoming one of the main platforms for data analysts to learn from, like paid. I already think my YouTube channel is one of the main places for that people go to learn for free content. I want this to be one of the main places that people go for paid content as well. It goes even more in depth and it is even more useful than my YouTube channel. And so I'm not trying to monopolize out here. I just really think I have a good perspective and a good way of understanding what people want and how to build it. And so I'm trying to build it and I'm trying to do things differently and I'm trying to make things fun again because a lot of learning platforms out there, they're just, I don't know, they're kind of boring. It's just not, it's not super fun, right? It's just like, it feels like you're grinding through it. I want it to make it fun again. And I feel like this platform is like the fun way to learn. And so I really hope, really hope you guys enjoy the platform.  You can join our Discord server. So you can talk about, you can talk about the courses if you have any questions, if you have any issues, you can talk to other people. It's just a really, there's like 1500 people in it already that were part of the beta program, but now we'll have more coming in, of course, now that we're doing the full lunch and as we launch more courses and more features and all these things. So join that and then get on here and try this out. See if you like the questions, try all the free ones. There's a lot of free ones. Like these are all the free ones.  You can see with the check marks but these are all the free questions. There's even I think one more on the other page. So go ahead, try these out, see if you like them. If there's a course that you are interested in, go ahead and get that. And if you have, if you want to really invest in it and kind of grow with the platform, then there are the Analyst Builder course bundles and the Lifetime course bundles, which will get you access for life to the platform for courses and questions. And I have a lot more stuff coming out. While I got you guys for just like even a second longer, kind of our plan for the future of the platform is to, I mean, I already feel like one thing is, is there's no other platform like this right now that has a question, a technical question section like this and courses on it. So that in and of itself is unique but the things we have planned for the future are just, it's just gonna be so amazing. We're gonna have a full project section where you can build projects and take projects and add to your portfolio. We'll have a resources section where you can get cover letters and resumes and all these different things. And we're looking into the ability to process it through one of those automated systems. So you can run your resume through an automated system to see if it performs well. We're gonna be incorporating AI into it. So like in this, in these technical questions, we plan on having some type of like AI feedback in here as well as in the courses. So when you watch a course, one of our plans is to, you're coming, you're learning about joins, you're learning about inner joins. And you wanna know more about it, you can click like, you can ask AI question about the video and then ask him more about it. So you don't have to leave over here to go to chat GPT or barred or anything, it'll be all in-house. And it'll just make for a much better learning experience. And so that's what we're trying to do. So those are just a few of the things. One of the things is we're gonna make roadmaps. So right now, how it is on the platform is all the courses are just kind of here. And if you know what to take, that's amazing. You know you wanna learn MySQL, come and take the MySQL. But if you're kind of new to it, you don't know exactly what to choose, we're gonna create a roadmap. So it says take this, then this, then this, do these questions, you know, use these resumes and it'll kind of be like, it's kind of like a really more advanced, interactive free day-nails bootcamp, except on the YouTube one is just videos, whereas on here, it's gonna be much more interactive and you know, I think it's just gonna be amazing. I'm hoping to get that out like middle of early 2024 to middle of 2024. That's like my goal for that. But we have so many, like if I showed you my spreadsheet, I have like 20 different things that are like really unique that we plan on implementing. And so this platform's just gonna grow and get better and better and better. And I genuinely think it's gonna be one of the best platforms out there on the market for data analysts to learn and learn really affordably. Because it kind of, it didn't hurt, but when I saw what people would buy like the Coursera for a year, I'm like, dang, they spent like $399 for one year. So if you wanted it next year, you gotta pay another $399. I'm trying to make it more affordable for people to get in-depth, really great resources that don't cost an arm and a leg every single year. So I hope you guys, I hope you guys see that. Like I really am trying to not, I'm really trying to make it affordable. And we plan on doing, I plan on doing a lot more giveaways and a lot more of these discounts that throughout the year you guys can pick stuff up as you need it. With that being said, I really, really, really appreciate you guys joining. We had several thousand people come through. Some stayed for the whole thing, which is way too long. Goodness gracious, this is a long livestream. It was like five hours. But really, really, really appreciate you guys. Check out the platform. Let me put the link, let me put the link in here. Oops, there we go. I'm gonna say try out Analyst Builder. Go ahead and try it out. See if you like it. If you do like it, I hope you try it out, join the Discord and see what other people think, but really, really, really appreciate it. And oh yeah, I'm gonna create leaderboards. I didn't know lead code had leaderboards. I haven't gotten a lead code in many years. But yeah, so one of the things that we have is if you didn't notice, under the profile you can earn points for different skills. And if I didn't do any Python today, I thought I was going to. But if you get ranked up, we're gonna have shareable badges. Right now it's just on here, but soon you'll be able to share them like a badge. But also in the question section have up here like a leaderboard, where it's an overall leaderboard for all points, as well as like a weekly leaderboard, where even if you haven't done it for months, if you come in and you start coding, you can get on that leaderboard. And it's just really cool, kind of like a fun competitive game. And that's gonna be coming fairly soon. That won't take a long time. We'll probably have that up in a couple weeks. But genuinely try it out. This is just a blast. Like I love doing this live stream. I gotta do a ton of questions, but I've talked to so many people who've tried it already in the beta. And now we're fully launching today, who just have given such, they're just like, it's so much fun. And that's what I was trying to create. And that's what's made me the most happy about it, is people are just having a lot of fun learning again. And they're like, it was so boring on this platform. And they're like, this is really fun. That's what I'm trying to create. So I hope you guys can see like it's, you know, I'm really, really, really trying to make a great platform for you guys. And I couldn't do without you guys. I really could not. I appreciate it.  Thank you, Christine. Shout out to my wife. I love you. Shout out to the Wave Sync team. And shout out to you guys. I love you all. I really do. I really appreciate it. All right, I am gonna get out of here, but I will see you very soon. I'll make a video tomorrow that I'm gonna release on the platform, talking about all the features and everything. So if you joined, you probably saw a lot of that, but all right guys, have a good one. I'm signing out.