g or maybe all right let us see okay so we're getting you know in 2015 16 17 how many employees you know uh so you are getting it now I only want those years where you know the number of employees hired were more than that see this was what I wanted you know and the number of employees hired in a year are greater than what are greater than two so what I had to write in this case also first of all let us do one more thing also suppose you realize this column you realize this column suppose uh uh you realize it it has a year so you can write it in you know year and group by say year okay here okay so I'm analyzing this column let us see if it is working or not I'm not sure if it will work but hopefully it should column year and year plus okay I think yeah this is a problem uh where extract year from uh hired it you know but this I this will this will always work you know I just remove it oh my god this we don't want group by year this will always work I think now if it will work let us paste it yeah it is working so now so what I've done you know what I've done you know I have realized this column which column I have realized this extract year from hired it I have realized it at it has was it have I have realized it as year so I can use you know the allies column in the group by clause and similarly for the hiring clause also I can use I can you know I can say something like this where num hired is greater than uh two okay where num hired is greater than two so what is num hired this is this column is your num hired column okay this is your num hired column so I have you know so I can write something like this and then you know I'll just copy it and now if I go and paste it it's gonna run I think it should come okay yeah so only the year 2017 the number of employees out of 2017 16 and 15 only the year 2017 is the only year in which the number of employees hired are greater than okay so if you have ever uh studied the relational databases uh if you have ever worked with any relational database then you must be well conversed with what are primary keys so primary key constraint is used to uniquely identify each row in a table so what is exactly a primary key how it is you know it is uniquely identified each row in table say for example that you have bank you have some account in certain bank and you want to you go to the bank to make some withdrawal then you won't say that this is my name and you give me such and such amount of money you will always say that this is my account number and on the basis of this account number you pay me this money or you pay me that money why because your account number is uniquely identifying you okay so in this case the account number is a primary key then a primary key cannot be unique and it cannot be not null why a primary key cannot be unique see suppose you go to the bank so it is not possible that two customers of the same bank have the same account number it is never possible they will always be unique that is why you know every customer will have a different account number so a primary key is always unique and primary key can never be null why a primary key can never be null because if you make primary key null then what is the purpose you know for example suppose you go suppose you have a bank account you have everything you registered in your bank account details for example your name your mail your mobile number your age your sex everything is registered the only thing is that your account number is set to null is it possible it is never possible so so in this case account number is a primary key and primary key can never be equal to null so that by you know account number can never be null that is why it is said that primary key constraint is equal to what it is equal to unique plus not null always remember that okay primary key constraint is equal to unique plus not null so how can we create primary key so one approach of creating primary key is that whenever you create a table you mention the column that is you that is a primary key column how will you do it let us try to understand this okay so i'm going to my database and i'm just going to so i have logged on to the database and suppose i create a table okay and i create a table suppose the name of the table is movie and suppose i suppose say the movie name and suppose a movie name back at 20 and then i say suppose director okay and director is also suppose it is also a string okay then i when i'm creating this table so one approach of creating primary key there are many approaches of you know there are two approaches of creating a primary key but one of the approach is that whenever you are creating a table inside the you know when you are when you are mentioning mentioning the column for example i'm saying over here that this column is denoting the movie name this is the data type of the movie name for example it is var cat 20 it is a string type and then i would say that this is also what this is also a primary key so now what will happen just try to see this i created this table the movie table has been created and when i say dsc movie then what will happen you see this m name is column is coming out to be what it is primary key okay and the you know null if you just observe this column see this column under null m name has said to be no why because movie name can never be equal to what it can never be equal to a null value all right so this way i have created a table movie and movie name is a primary key so let us try to insert some values in the you know this this table suppose i say insert into movie values suppose one movie was okay you can take any movies for example one of my favorite movie was there was a movie that was that was based on world war two i don't remember the exact name of the movie for example let us say matrix okay it was one of one of my favorite movies and matrix movie i don't know the exact director suppose i would say that james was the director of the matrix movie so this is interest is inserted you know then i would say that there was another movies suppose suppose ddl it's one of the favorite it's one of the very popular bollywood movies and suppose the director was current johar you know i'll say johar okay so two movies have been interested inserted and then will i say select star from which from the movie then you will get get these two movies that have been inserted now let us try to do one thing let us try to you know for example i would say that matrix and again i let let me go and insert this rule is it possible let me try to insert this rule will it will this be inserted suppose i insert i change the director to james not i change the director to canes it can be some arbitrary name but i have said the movie name again to what matrix and you can observe sorry all right all right what did i said canes but i've said you know the movie the movie name to be equal to what matrix and you can see that this movie name is already been inserted so once you try to do it it will never allow why because duplicate entry for matrix is never possible by because the movie name is what it is a primary key and duplicate values in a primary key column are never possible primary key is always unique and if you try to insert null value suppose you try to do something like this you make the movie name to be what null and then you try to do it column m name cannot be null by it cannot be null because it is a primary key so this way you add you create to you you know you create a primary key on a column and then there are also very special things suppose you want to drop a primary key see the last point if you want to drop a primary key use all the table table name drop primary key okay so what is my table my table is you know this is this this table okay if i say dsc movie this is my table now if i want to drop the primary key then what will i do i will say alter table then what is the name of the table movie and then what will i say drop primary if i say like this then the primary key will be dropped so i've dropped the primary and now again when i say dsc movie you know see this primary key constraint that was occurring over here is not now it is now it is not occurring over here now okay so now it is the primary key constraint has been removed and then once when i say select start from movie then you you are getting the same records but the table has no primary keys okay and then what you can of course do is that suppose now you try to insert the same you try to insert this value matrix comma k and c matrix has already been you know movie name has been once one movie name of type matrix has been already inserted you know one movie of name matrix has been inserted then if you try to insert another movie of the name matrix is it possible now yeah it is possible why it is possible because we have already removed the which kind of constraint we have already removed the primary key constraint so if you again say select start from movie you will get two movie of what type two of of type matrix okay i will say delete from i will delete all the rows from the movie table okay so now again if you say dsc movie you will get describe the details of the movie table now what i want to do is that i want to this you see the fourth point for example one's third fourth point and to add a primary key to an existing column so now you see this does the same name is a primary key no it is not a primary key one way we you know we created the primary key was like something like this you know when we created the table for example what we did you see we one way of creating the primary key was by using at the create table when you were creating the table then you were mentioning that such and such column is a primary key but now i don't want this for the table has already been created and now i want to add a primary key constraint to a specific column in a table so what will i do so i will use the fourth fourth point you just observe to add a primary key to an existing column use what all the table table name add constraint constraint name primary key column name okay so wherever i have you know these uh uh these uh between these two you know you have to you have to keep on substituting values so you have to substitute table name you have to substitute constraint name and you have to substitute substitute what the column name so how will i do it so i will like alter table okay and then i need to substitute the table name so what is the name of the table movie and then i have to say add constraint sorry add constraint i can give any name see now what i have to give i have to give the constraint name so i can give any name of the constraint for example this is also a valid constraint name but generally it is very advisable that you give a descriptive constraint name so how will you give the descriptive constraint name you can do it do it something like this what is the name of the column m name what is the name of the table and what is the type of the constraint pk so it is now describing that M name column of the movie table has been given the primary key constraint So, it is a descriptive name, constraint name. Then what I have to say it is a primary key and on what column the primary key constraint has been added, it has been added to the M name column and then once when I say now again you have see you see I have inserted the primary key constraint on the table. If I try to insert if I try to say DSC movie then again now previously you are not given under the key column you know you are not getting the primary key, but now you are getting what it is a primary key. Okay, clear so this is the working of primary keys. I think okay all right let us continue. So, so this is the way we work with primary key, but again there is one problem. What is the problem let us try to understand this for example if you are if you are if you watch Bollywood movies then there was a you know many times it happens that movie names are repeated. For example there was a movie that was called Agnipath and that was released in 1990 and that belonged to Amitabh Bachchan and there was also a movie that was there was a movie that was also called Agnipath and that was released in the year 2012 and that belonged to Ritik. So, you know just to give you I mean I can like you know kind of I would say IMDB Agnipath. So, you know two Agnipath movies are there one was released in the year 2012 and the other was released in which year it was released in the year 1990. You see this movie 1990 Agnipath it belonged to Mr. Amitabh Bachchan and then you say for example Agnipath 2012 that it was released in the year 2012 and it belonged to Ritik. So, I want to keep these two you know tables in my these two movies in my movie tables so what will I say insert into movie values okay and then I will give the movie name and suppose Agnipath and suppose you know the previous I am sorry IMDB Agnipath and you know the 1990 movie Agnipath it was you know directed by whom it was directed by Mukul Anand you see so I will give the name of the director Mukul okay he was the director of the movie. I have inserted this role now again I want to insert the one more role for Agnipath that was released in the year 2012 and the director was what director was Karan okay director was Karan you can just check it also you know for example if you go over here Agnipath 2012 movie director was Karan Malhotra okay so this way it goes I'll just I'll just close these tabs again if I go to my database will it be allowed see will it be allowed it will never be allowed because why you are making because why you are making duplicate entries for what you are making duplicate entries for the movie name and movie name has been said to what movie name in the movie table is a primary key so now this is a problem so how can I remove this problem I can say said that I will say that movie name is not a primary key the movie name so now I will introduce you with the concept of what the concept of the concept of composite primary keys so it is also possible that two or you know more than more than one columns in a table can be can be primary keys combined so primary key can also be combination of many columns so you know on what it is called it is called a composite primary key a composite primary key can have multiple columns whose combination must always be unique okay so what does it mean that in a composite primary key you can have multiple columns but there you know their combination will always be unique so I can say for example over here for example in my in my application the movie application that I will say that the movie name will not be a primary key the movie name plus the release year will be a primary key for example you know only unique movies per year are released so I would at least go on to say that movie name plus the year in which it was released will be the primary key so now what I need to do I need to create a composite primary key so before creating a composite primary key let me do one thing that you know because this movie table already has a primary key so I need to remove that primary key so how will I remove this primary key is how is it possible I will say you see this PowerPoint presentation you know if you want to remove you know I'll just minimize it if you want to drop a primary key alter table table name drop primary key so I will use this okay alter sorry right this stuff alter table and then what is the name of the table movie and then what I say drop primary okay and then once when you say the primary key will be dropped so now I why I drop this primary key because now I want to add a composite primary key to this table so before adding a composite primary key I am saying that movie name plus the release year is unique identification for all the movies so because you know I have not added the release year column to this table so let me do that also so what will I say alter table which table movie add what add a column and I will say it is a just a release year column and it is of type so I've added a release year column so if you say DSC DSC movie describe the movie table then you are getting what the movie name and the release year column so now I want to do what I want to add a composite primary key so how will I add a composite primary key composite primary key composing of what it is being composed of the movie name movie name also and the release year also so now if you want to do it then what will you do again you will add what you will say alter table okay which table the movie table add the see alter table table name add constraint constraint name primary key followed by the column names so what will I do add constraint and suppose I will say that M name are you are here release year and what is the name of the table the name of the table is movie and what is the type of constraint it is a primary key constraint so I have given this name constraint this name the primary key constraint I've given this name alter table table name add constraint constraint name what kind of constraint a primary key constraint and on what columns I'll just minimize it and on what columns you can just see there are two columns one column is a name column the other column is what it is a REF that is a release year column if you go on to it again a primary key constraint has been added but now if you go you know if you say suppose DSC what is the name of the table it is a movie so if you go on to do it see the movie name and the are here are you know they are primary key so so so always keep this in mind I'll I'll make this very important statement you know it is very important that is why always I'll take a note pad to write it down because it is very important I would go on to say that a table can have only one you know table can have only one primary key so here you see that M name and are here are they both you know different primary keys suppose this is this table movie having two primary key see M name and area no it is not their combination is one unique primary key see this is the difference M name and area are not to separate movie are not the separate primary keys for the movie table why because a table can have only one primary key but M name and area combination is what it is what it is a primary key so if you want to just see it for example I say now I can do it insert into what insert into movie table movie table and what what I want to suppose the name of the movie I will say Agnipath and I will say what is the name of the director suppose this is the director that has you know that suppose Mukul and it was 1990s Agnipath and it was released in the year 1990 then when I go and insert it okay all right suppose I will say insert into movie and values okay let us go and insert it so this is inserted again I would say there was one movie Agnipath that came in the year 2012 and that was directed by Karan Malhotra and it was released in year which year you know 2012 you know now it is possible see if I say select star from which table select star from the movie table if you if you do it then you see this movie name is movie name is getting what movie name is getting repeated but the movie combination of movie name you know sorry I know I'm just there was one low that was already inserted so I will you know I will say to lead from movie there are year equal to zero okay I'll just remove it all right now if you say select star from movie then you will get two movies you know their movie name are same but the combination of movie name and the release year is what it is different okay so movie name and release year are together they are forming a primary key so if I try to do something like this suppose I insert into suck suppose I change the name of the director you know suppose I change the name of the director to like this I give any name okay and then you know the combination of the movie name and the release year is remains the same for example Agnipath 1990 you know it will never allow see duplicate entry what what not Agnipath or not 1990 but a combination of what Agnipath 1990 so a primary key can constrain can span multiple columns also okay so in this way so again you know one more thing one more last thing about primary key constraint if you want to get some details about the primary key constraint then you can use this there is one metadata view that is the information underscore schema dot what I think it is key column usage yeah okay so if I you know if you can press the you know what will I say select suppose I will install okay I will say select then I will say enter column name comma suppose I will say constraint name all right and then I will say suppose table name okay I think table name and then I will say no table schema from from which table from this table from information where will I then I'll just add a where clause I will give the where for example sorry where table underscore name is equal to what is the name of the table it is equal to movie movie and what is the name of the schema then I will say table underscore schema equal to the name of my you know the current database that is the publisher database so if I go on to you know make a query okay so and I just all right and I just need to add a and so you'll get you know this move this table has you know it has a primary key constraint that is imposed on which column two columns and name and area suppose you do something like this okay there is one table that is a MP table suppose you do and then that that this table we have frequently dealt with what is the employees table and employees does it has a primary just check it out yeah it has a primary key constraint on which column it is a primary key constraint on the EID column so this way you can you know you can pitch the metadata information that is associated with primary key we'll be also using this metadata view for you when we will fetch information about the you know foreign keys so we will use this also so what is a not null constraint this constraint forces the values in a column to be not null so what does this mean that whatever value stored in a table if you mention that that the particular column is not null then you can never insert a null value in that column so let us try to understand this with a practical example so this is my database and I say select a database then you know you'll get the database that's a publisher database and then I will create a table and suppose the tape name of the table is say suppose the products table and I have two columns product ID int and product name okay that is suppose that care 20 and against product name I add a constraint that is the not null constraint so I created its product table and now let us try to do something suppose I say insert into products and then I may give the name of the column suppose a product ID and the product name and then I insert values suppose I say that first the product ID is one and the product name is suppose a soap then this will be inserted and if I say select star from which table from the products table then you will get this sorry select star from products you'll get it but now if you insert another row and you give the second value that is a name value to null so will it accept it let us try to see this suppose a product ID is true and then I try to insert it see it is not inserted why because product name cannot be null so why because we have inserted a null constraint inside the not null constraint inside the product name so product name column this column can never be null so this is what I've written over here the syntax of a not all constraint is something like this column name data type and then not null so this is what we have done over here see when we created the table how we created the table we created the table something like this suppose the product name column that was made not null so the column name and then what was the data type the data divers work back at 20 and then I gave the not null constraint so this column product name is a not null column okay clear so I can never insert a null values inside this so now if I say if I describe my table products then what will you get you will see that this product name and there is one you know in the describe there is one column that is a null so this product name you know the value for product name against null is no so that means product name can never be what it can never be null but product ID can always be null how it can be null just see for example I say insert into product suppose I just give the product name if I just give the product name then what will be the product ID it will be it will be null suppose and suppose the name of the product is shampoo and then if you say select star from this table product stable then you will get a value of ID ID is null value ID can be set to null by because here you have seen the PID can be null but can product name be null no it can never be null so this is what is null constraint in many cases it may be required that you have you need to create a null not null constraint on an existing column in an existing column sorry so how will you add it see to do this you will use a change alter table change so how will you do it to add a not null constraint to an existing column so let us try to see this also for example let me create another table create table suppose I will say products one suppose okay and there is one column PID and that is it and there is one more column product name and that is vatcat 20 so I have created this table that is the products one table and if you say dsc describe the products one table then you will you know both of these column that is a product ID and then the product name both of them can be what they can be null so I try to do something like this insert into sorry into which table products one table suppose values 1 comma so so we have created the products one table and then I insert a value suppose 2 comma shampoo and then I insert suppose third and you know for against the third ID I insert a null value so how will I insert a null value I will just write null over here so now you can see if I say select star from which table from the products one table then you will get the product name as null so now what I want to do is that I want to add a null constraint to the product name column of the products one table see what I want to do I want to add a null constraint to the product name column okay so what command will will I use I will use this command see to add a not null const sorry I want to add a not null constraint I don't want to add a null constraint I want to add a not null constraint the value is nullable but I want to add a not null constraint to the product name column so to add a not constant to an existing column what command will I use I will use this command alter table alter table table name change the old column name to the new column name and then the new column definition so how will I go for it I will say something like this alter table what what is the name of the table products one and then will what will I say see change sorry change what is the old column name P name what is the new column name I would say it is P name and then what is the new column definition so I have to give the whole column definition see what the data type and then followed by the you know the natural constraint so what was the data what is the data type that I want I want the data type to be also what it has to be a bar care but I will add a new constraint to it what is what is that constraint I will and I will add a natural constraint to the product name column if I try to do this let us see okay yeah it is done so now if I say select start from products one then what it has done see it has replaced all these null value the null value that was there in the product name column it has replaced it with a blind string okay so now I can never insert is a null value in the in the product name column of the products one table for if I try to do it for example here if I try to do this suppose I say the PID to be 4 and then if I again if I try to do this it will never happen by because product name column can now it can never be null and if you see products one table see this column product name it can never be set to what it can never be now set to null all right so yeah there is one more thing that I just want to tell that whenever you add the null constraint sorry a not null constraint I always you know confuse it with the null I would say a not null constraint to a column then you it is a it is it is a generally a good practice that you also give a default value how will you give a default value for example I just create a test table suppose I say create table test 11 suppose the name of the table is test 11 and there is just one column serial number of time in but I will add a not null constraint to this serial number column and I will also give what I will give a default value suppose default value is 0 okay so if now I say insert into okay what will I do I'll just add one more column I clear add one more column to this table all the table what was the name of the table test 11 I suppose add suppose name and add I will say column okay or add column name and then suppose the data type is of back at 20 then when you say DC test 11 what values will you get the serial number and the name see serial number I have added the not null constraints so serial number can never be null so let me try to do one thing I will say insert into test 11 and I will not give the serial number value I'll just give what I'll just give the name so I will say name sorry name and suppose values in the name I just give one field what Krishna okay then what will happen see select star from test 11 if you do this then the serial number will be set to its what it will be set to its default value and this is exactly what we did while creating the table we said that serial number default value for serial number has to be what it has to be 0 so if you don't give the value of serial number then it will be set to its default value of 0 and this is exactly what happened over here I just inserted the name into this test one table I didn't inserted the serial number the serial number was set to 0 and serial number can never be null see if you describe test one then what is happening serial number can never be set to null so it because we have added a normal constraint to the serial number column okay so what is a foreign key constraint so it's a kind of referential integrity constraint so what is exactly this referential integrity constraint see whenever I ask many students what is foreign key they just say that foreign key is a key that points to you know some other table so they just have don't have any clarity in mind so but foreign key is used impose you know a kind of parent child relationship between two tables so what is a parent child relationship a parent child relationship states that suppose can you create a child without a parent it is never possible first you have to create the parent and then you can create the child so this is what I've written a foreign key constraint denotes a parent child relationship a child cannot be inserted unless what exists a parent exist and suppose you delete a parent and the child for the parent exists so can you delete the parent you cannot delete the parent because why you cannot delete the parent because the child will become orphan so this kind of constraint is imposed by a foreign key relationship between two tables you will also see you know after sometime we will see that foreign key constraint can be imposed within the same table so you know so this is just a kind of extension to foreign key but right now just just consider foreign key is like it points to the primary key of another table and it maintains referential integrity between two tables so let us first of all understand the need for foreign key and see how you know between these two tables between two tables there is no referential integrity for example I have one table the EMP table and I have one table the dpt table you know these tables kind of tables we use frequently and I say select star from EMP and I will say select star from dpt so let me first of all state that these two tables belong to the same organization so for the organization there are two employees Nikhil and Nithin and working in the sales and marketing department so Nikhil is working in sales because his department ID is 10 and department ID 10 is sales department Nithin is working in the marketing department so both of these tables belong to the same organization and now let me do something I will insert a record into which table insert a recording EMP table and say values suppose there is employee third employee and name of the employee is Nihar and her department ID is 40 if I try to insert this record it will be inserted and I will say select star from EMP and select star from DMP can you see what is the flaw with this this kind of this these two tables what is the flaw with these two tables there is a serious flaw with these two tables for example just what is the problem with these two tables see if you because these tables you know they belong to the same organization here these two belong to the same organization here I've inserted a employee which implies he nikhil is working in the sales department that I know you know Nikhil is working in the sales department but here I've inserted a employee which is working in department ID 40 but is department ID 40 existing department ID 40 is not existing that is why this if you try to insert this if you insert this imply this employee should have never have got inserted see because department ID 40 is it is not existing then how can I imply work in department number 40 you know department ID 40 so ideally this record should have never got inserted okay so can you just make out which will be the child table and which will be the parent table this employees table will be what table it will be the child table and this departments table will be what this will be the parent table why because the child cannot exist unless the parent exist see here this Neha cannot exist until until a department with the ID 40 exist but because we have not inserted the foreign key constraint it is you know it is allowing us to do so for now suppose I try to do one more thing I try to delete depart the marketing department so what will I say I'll just delete from which table delete from DPT where the name equal to what it is equal to marketing if I try to delete the marketing department it will get deleted and I will say select star from EMP and then I will say select star select star from DPT but again now there is a serious problem I deleted the marketing department I deleted the marketing department but you see this employee Nitin has become orphan record because why because its parent you know its corresponding department in the department stable is not existing the DPT table it is not existing so this record has become an orphan record so ideally when we try to delete the marketing department it should not have allowed to delete the marketing department so if you want to impose these kind of relationship between these two tables so that what kind of relationship that a parent a child cannot exist up until unless a parent exist and a parent cannot be deleted until and unless it and it has some dependent records child records so this is the kind of relationship between two tables that is imposed by a foreign key so how will we add a foreign key I will just clear these two tables delete from EMP and I will say delete from DPT first of all I'll clear these two tables and you know these two tables are now empty if I say select star from DPT it is empty and then I say select star from EMPT is empty and now if you want to add a foreign key then you will use this command what command to add a foreign key constraint on existing column use alter table table name add constraint constraint name then foreign key then on the column on the child table that you are imposing the foreign key and which table it references so I'll just you know I'll just want to make a point


Hey there friends, how's it going? My name is Kevin and today we're gonna be playing some horribly horribly cursed terrible situations. And no, that's not real life. That's the game Dreams for PS4. It should definitely be called Nightmares though. If you missed my last videos on this, don't worry, you don't need to see them, but you're missing out on good stuff. Oh my god, look at Morty's face! Oh my god, I'm almost leveled up to the point where they're gonna assign me a persona.  I want to go on Waluigi's Bizarre Adventure, even though I really want to see what old man uses computer is too, but we'll visit this one first. Oh, it is labeled as a comedy, so it should be good. Alright, let's begin on this bizarre adventure. Oh god, there's the Ice Age, baby. Why is he always here? Hello Waluigi, my name is Uganda Knuckles and I am a Super Saiyan. I know the way to make you immortal. Defeat the two gods of this world. Okay, thank you Uganda Knuckles for showing me the way. Oh no, I can hear their brothers getting out of here.  I'm Thomas the Tank Piracy. Please proceed through my nether gate. Yeah, I'm out of here. That was so loud. Jesus, wait, hold on a second. Is that Sonic?  What do we got here? Ah, it's a Rambe, isn't it? Yeah. Ow. Jesus, what was that? Was that Waluigi dying? What is that sound?  Oh my sweet Jesus, I don't know if I can actually finish this one. It sounds just awful. I want to go to old man uses computers. He'd never scream at me. Oh, wait, I'm the old man. Oh my god. I always kind of knew. I know where this is going. Fantastic. Did you enjoy that? Will you give it a thumbs up? 100% yes. Oh Jesus, a Shrek Bash. You know we got to take part in a Shrek Bash. There's always going to be a Shrek level.   That is awful. OK, what is this? Skill tree menu. Hold on. This game is deep. Oh, I can't get into it. Wait, oh, I got to select my character. Of course I want to be Shrek. All right, come on, Farquaad's men, I've got you now. I think I'm just working at them. Hold on, can we get a shot of that, please? Yeah, that's good. I like that. Oh, powered up. Now go into the skill tree. Yes, body slam in the air. This is awful. I'm just going to keep spamming this. Shrek's doing the worm. Oh, what is happening now? Is it over? There was still loads of them to kill. Well, back to my home life, I guess. Jesus Christ, what's he doing? He's really trying to kill himself. Well, the Shrek starts coming and I don't stop slamming. Come on, everyone. Are we going to do the whole Fekin movie? Is that the plan? Oh, a boss fight.  Okay, all the guys were just jumping in the background delighted that the ogre was slain. I'll give that a thumbs up, even though I didn't get very fair. Are you worried about this? Jesus Christ! What? Just the hell? Oh my God.   Why do I have a shotgun? Okay, I guess we're done. I don't even understand.  That's pretty relatable. Oh my God! Yeah, that is footage of me. Wario gets hit by a train. Wario's bridge accident. Jesus Christ! There's a lot of Wario dying, isn't there? Wario has a war flashback. Come on, Wario. What have you got for us now? He lived quite the life by the looks of it. His whole day is a Fekin war. Oh God. What's he remembering? He's going to remember the carrot thing, isn't he? Oh no, Vietnam.  I knew he was a war hero. Poor Wario, dude. He can't get your break. Jesus Christ. What is going on? This is demonic.  I have to go back to these monsters. That's his son. This is amazing. This deserves an Oscar. Did you enjoy that?  A river has fallen into the man in Lego City. You have my interest. A river has fallen into the man in Lego City. He's got a new rescue helicopter. Man, build the helicopter.  Wario, except he's involved in the high-speed crash. No, stop torturing him. Why are you in a helicopter crash in Vietnam? Wario gets shot. These are all the most bummed up this month. Wario eats 37 burgers and dies. No, look, let me play Fortnite. I can finally be a Fortnite YouTuber. Oh, I'm coming for you, boys. Watch out.  You can't hit me. Okay, you can. Okay, you're shooting me through the walls.  He's hacking. Who was even shooting me? Oh, he's there. Okay.  I'm quitting and reporting that, dude. Poor player. Stream sniping. Oh my God, finally. Wario doesn't die. Yes, please show me this one for once. Oh my God. You fecking lied, didn't you? You fecking lied to me. Lois Griffin meets Mario. Yeah, I'm up for that. Mario, what brings you to co-hog? This is just terrible. I hate it. I hated everything about that. This looks cool. Escape the killer's basement. A text adventure. Finally, I can get it from their point of view. You've seen the news reports of frequent disappearances and bodies found in the river. Jesus Christ. I don't want to hear this. Just skip it all. Skip it all. Oh, okay. That wasn't good. Okay, what will you do? Look at the back wall. Oh my God, this is cool. I got some gasoline. So I saw chainsaw I could use there or maybe I could start the fire. What should I do?  Start the saw. I don't even know why.  I should have set up a trap first. That was my idea to set up a trap. I literally just alerted him that I've escaped. Well, now I'm dead. Great. I wanted to set up a trap on the door or something and then alert him to come down. Well, that's canon now. We're leaving it. So that's what it feels like to be on the other end. I don't like it. I'm referring to The Sims, by the way. If you've never watched any of my other videos. Massage therapy. Okay, what do I do? Oh my God, this is a lot of controls. It's fine, I'll manage. Okay, it's literally just making my controller vibrate. Just in case you don't believe me, I'm just gonna give you a little bit of ASMR vibration there. I hope that's nice. I hope that's relaxing for you. It's a way of getting a bit of a massage, I suppose. Let's massage near your drums. I debated doing an ASMR. I'm gonna be dropping all my money on the table at once. Sorry, I'm not a very wealthy man. I'm gonna get one of those microphones with the two ears to feel like someone's actually listening to me for a change. Anyway, that's your massage session over. The matrix reloaded. I'm in. Oh wait, I'm the bad guy. You have it now, Neo. It's time for you to die. Wait, maybe I can get him out of this situation. Come on, Neo, let's go. Neo, Jesus, he's so uncoordinated. Neo, please, social distancing. Like I mean, well, let's do a bit of an Irish jig and all those friends have gathered around to watch. And they're all speechless. Okay, I should restart because I've picked the wrong person here. All right, here we go. Do they? Okay. Yeah, there he goes. That's Neo for you. They're not even looking at me. What are you doing now, Neo? Okay, you fell off the flat earth. I think that's a good time to end. All right, Kermit down. Yes, I wanna play this. It ain't easy being green. Oh wait, hold on. This might be different from what I was expecting. Okay, yeah.  Kermit down, did you enjoy that? It's like, did you enjoy that? Sick twisted. No, I don't wanna play it again. Fine. Okay, maybe I did kind of wanna play it again subconsciously. Handsome Squidward escapes prison. Yeah, let's go. I like how it has to be handsome Squidward. It can't be normal Squidward. All right, handsome Squidward. How do we get out of this one? Oh, what the? Am I gonna flush myself? Is that it?  This is fantastic. I love the thuds as you hit the ground. He's so thick. Oh God, they're shooting at me. The prison has been alerted.  He is shaking the earth, not only the sewers, but the earth when he jumps. Here's my ship. Come on, the flying Dutchman. Did we get away? Yes, we made it. Oh, we may have crashed the boat though. Is this the road to Bikini bottom? It does not look familiar. Oh Christ, they're after me. They can run. Oh God, they got me. Wait, now I'm behind the car. What, am I in the car? What is going on? I think they've locked me in the trunk. I don't know how to get out. Yes, I got out. I may have gone a little bit too high though. Oh Jesus, the whole ground's gonna explode. Like if a normal jump causes a shudder, that's gonna cause an earthquake. Yes, he reached the end. I don't know if we did really. I think we got apprehended there. Oh, he's pulling a little pose. I think they just gave up on him.  Oh, he's sad. Why is he sad? Is it cause even the police don't want you? Oh no, they still want you. He's like, oh, here we go again. Where's Scoop 2? I never heard of Where's Scoop 1, but I'm in. Two years after the disappearance of your faithful dog, Shaggy finally gets a new lead, but it comes at a cost this summer. You gotta go fast to catch that purple weirdo who kills Shrek. I don't know why I care. I'm just looking for my dog, man. Do, do, do, do, do. Is this an alternate reality where Shaggy's the protagonist of every Marvel movie? Just when a song picks up, he kills himself. What a protagonist. Okay, get me out of here. I can only do so much of this song before I'm demonetized. You see that guy up there? He works for Thanos. I bet he can give you information how to find him. I think that's Waluigi up there. What is this? Is it all purple people who worked for him? Is this a racist game? Is it canceled now? Oh wait, hold on. Okay. Sorry, I thought you were someone else. You were clearly not Waluigi. I just realized if you press square, he's his joints and what appears to be an impression, but I don't think he even tried. The hell is going on now? Oh my God, it's the Shrek train. Oh, I'd ride that train to work any day, which would be a bit weird because I work from home. Why is it always ending in the swamp? And I thought you were dead.  Okay, no, I'm actually okay with being in this swamp. Thank you, and hell, what is that? Okay, the sprint button does nothing. It just makes the sound of sprinting and Scooby-Doo. Oh no, if you're looking for handsome Squidward, he was in another level. Leave me alone.  Jesus Christ. Get me out. Get me out.  I hope it's worth it to you.  Okay, is this the final level? Is this Thanos? See, there he is. Okay, great. What is that? Do I have to get to the helicopter? Is that what I have to do? What did that do? Okay, that raises another wall over there. Okay, look, honestly, at this point, just get another dog. This isn't worth it. I know the other one could talk, but that's gotta be grating at some stage. Just get a normal dog. I don't know what I'm actually gonna do when I get there, other than a bad zoinks, to be honest.  How was I supposed to see the whole screen when black? Okay, did, okay, I just exploded him somehow. How did I do that? What are you gonna do now, Shaggy? Of course, of course. Why didn't the Avengers just do that? There he goes. He is defeated. Did you enjoy that? Will you give it a thumbs up? I'm not sure, but I'm gonna give it a thumbs up anyway. All right, I think that is a perfect one to go out on. That's how I wish Avengers ended. It should have, that was more fitting. It made sense. There was a lot of foreshadowing in the movies to lead up to something like that, but the actual ending made no sense to me. But I hope you enjoyed the dreams. I hope you have no dreams like this, like actual dreams because Jesus Christ, you'd wanna have a crazy mind to be thinking of this stuff. I don't know who makes these, but my sympathies go out to you. But I hope you enjoyed the video. I appreciate you watching as always, folks, and I do hope to see you next time. Bye for now.