What visual asset news that could top stories in crypto and bring it on bite-sized pieces today? Just the thumbnail suggests this is going to be the catalyst to push Bitcoin to its all-time high as accrued upon by JP Morgan, Twitter CEO Jack Dorsey, and Michael Saylor with Michael Strategy. And that thing is hyperinflation but really comes down to it's just good old fear. So we'll take a look at what's going on there. Also the El Salvador IMF deal, which is going to be pushed about by Bitcoin. There was also a second Bitcoin ETF launch on Friday. Totally missed that so we're going to explore those options. And then lastly we'll talk about the reason why Chainlink is pumping is because the Associated Press is running a node now on Chainlink. So we'll take a look at all those things plus more but let's take a look at what's going on the market shall we? So today's pretty good day. It's Saturday. We had a little bit of a pullback on Friday with the Bitcoin ETF by ProShares but still solid. Market cap is above $2.5 trillion. Bitcoin price is $61,000. We keep bouncing off that $60,000 mark. And also some of that money that was flowing into Bitcoin and reached all the way to $67,000, it found its way into alts. And over the last 24 hours, I mean we've seen some pretty good price action. Ethereum went down a little bit, $4,000 but Binance Coin over the last 24 hours up a little bit, Cardano not so much, Polkadot a little bit here and there. And then Uniswap up a little bit, Chainlink up with the news, Litecoin up, Shiba Inu for whatever reason and so on and so forth. So over the last 24 hours for alts, not too bad. And there were some real big winners but the thing that I was looking at was this was the Bito, BITO that's a ticker name for this ETF. And we can see just tracking how things have been going. It started off with a bang and it was one of the highest traded ETFs of all time, the first, the second one. And it exceeded expectations and it started pretty well around 40, jumped all the way up to 42, 43. And then this was on the 20th of October. And then we just had a little bit of a slide after the first day and we opened up a little bit, then a trade a little bit lower, one little bit sideways. And then we ended up again sideways, then we opened up again on Friday, went down again, a little bit more of a dip here. And now we're below the initial price of the $40. So that's what's going on with the ETF. Me personally, I didn't think it was that big of a deal, but people put a big emphasis on it. So I was like, okay, but in all honesty, I don't really care about paper Bitcoin. I just don't. I care about a spot ETF. I care about us holding Bitcoin, the real physical one, but I don't really care so much about this. The only thing this is good for is exposure. And it's good to get it out there so people can go, well, the SEC approved it and they wouldn't lie to us. So it must be good. So on top of that, I also want to take a look at some charts, just a chart, I should say. I'm not a chartist as everybody knows, but I like to see this one thing and James always talks about this at invest answers and he sees just how the Bitcoin price is gobbled up at certain points. And it seems to me like that point is actually the $60,000 mark. And we can see it right here. We've been just kind of bouncing on this channel as far as the Bollinger bands right around 60,000.  And we can see it just kind of went down to here and it was immediately got bought up and the bulls are like, no, it's not going to happen. And now we're, we're trading this very, it's very tight pattern. The RSI is right in the center. It's not overbought, oversold. And then the MACD, you can see there's a little bit changes here, but I just, I think we're going to trade in this channel for quite some time until this catalyst goes about. And what is that catalyst? Well, that brings me to our first story. Hyperinflation and good old fear. Look, I know people don't really talk about it, but fear is a, it's a great motivator. It works out pretty well and it gets people to do things that normally they wouldn't do. And this is what I'm talking about. So this was a pretty good article over a lot of things. So hyperinflation project Dorsey of Twitter CEO says this is going to change everything. Here's what's going on. Inflation is gradually kicking around the world. And some people say it's because of the lax monetary policy of the federal reserve and quantitative easing, which is just a bunch of, which a fancy word for money printing. And to, to make this point a little bit clearer, here's what we have as far as the purchasing power of the dollar. I know you've seen me trot this out every so often, but look, you can understand since the seventies, the purchasing power has just gone down and down and down. And the inverse is true as far as money printing. And down here as a little note to remind myself as of February 10th, 2021, there was 2.05 trillion worth of federal reserve notes circulation because they keep printing. And I know they, they're printing a lot more. So, and that was just in February. So if we can see the purchasing power goes down, well, why, well, why wouldn't it? We just keep throwing in money. So at some point, either they're going to have to raise the rates, taxes have to come in, or they're going to have to get these tricks or stop them, or they can just print to oblivion and we'll see what happens. I think it's either deflation or hyperinflation. One was two is going to be just awful. And then to prove my point just a little bit more, let's take it out to 1913. You can see that when your grandparents talked about how the dollar went far, they could buy like a car with a nickel.  And now of course today, this is in 2013 for Pete's Sakes. We've only got that. And then make this even more clear or simplify it. If you just take like a $20 bill in the 20s, you can buy a bunch of stuff for that, right? And then going forward, you can't buy too much.  It doesn't buy squat. And of course, Bitcoin is the inverse true. Over the last so many years, one Bitcoin in 2011 couldn't buy anything. And then in 2017, it could have bought you, well, a mid-sized car, we'd say. And in 2021, who knows what it's going to do. So the inversion is happening here as far as the dollar and Bitcoin. But to get back to the article itself, to beat inflation, many experts and investors have advised investing in assets such as gold, silver, and of course Bitcoin. I am also investing into real estate. And also, I've been investing into art through masterworks where they do fractionalized share of artwork. There's again, link in the description. You can check that out because it's an uncorrelated asset. I like that part. And this was the big thing. In January 2021, the United States inflation rate was about 1.4%. 1.4%. I don't think it's true, but okay. But currently staggering around 5.4%. I still don't believe that's true. And you can talk to a bunch of different experts. There's one thing that two experts can agree on. And that is that the third one doesn't know what they're talking about. But in all honesty, if you take a look, if you just listen to some people around there, they think it's around 8%, 9%. Some people say as high as 13% inflation rate. And this is Charlie Bielow, or Baleo, excuse me. And he talks about inflation expectations in the US to rise even higher. So I don't believe that we're at 5.4%. I think it's much higher than that. And then also some concerning news. Data from Trading Economics reveals that G20 countries are also seeing a spike in inflation. Argentina, Canada, Germany, Spain, and many others. And we're going to see that again. I don't know if these are totally accurate, but it does show us that everybody's going up. On the right side, you got 3.3 for Spain. Now it's 4, 3.9 for Germany, 4.1. The one that's doing pretty good is India. It was 5.3. Now it's 4.35. So good for India. And then Turkey, Argentina. Jesus, crime and Christmas. That's a lot. And then Jack Dorsey here says, look, hyperinflation is going to change everything. It's happening. And I think we can see those all around. Just go to the grocery store. Go try doing kind of renovations. Go try to buy goods and services. And you can see it right away. I just saw a report that they're going to raise Social Security. I think it was like $5,000 or $6,000. And people are like, they're so happy. I'm like, don't be happy. That doesn't buy anything. I mean, it helps, but just the dollar's just getting weaker. Anyhow, to finish this up, Peter Thiel, the founder of PayPal, says he wish he would have purchased more Bitcoin. I feel like I've been underinvested in it. Bitcoin is the canary in the coal mine. It's the most honest market we have in the country.  And if you believe some stories about Peter Thiel, he's been doing a lot of interesting things. One of those being that he led Silicon Valley's elite to buy doomsday bunkers in New Zealand. Just a story from Business Insider.  So why wouldn't he do things like that? And I think that when you have something like that, you can see what could potentially happen. These are the worst case scenarios. Do I think the world's going to crash and burn an end? Not personally, I don't know. I know some of you do. Leave me your notes in the comments section. But I mean, there is a pretty big crash coming up if we keep doing the same things we do. So that's why I've invested into a range of assets and crypto being one of the biggest ones. And then lastly, this is from JP Morgan. We believe the perception of Bitcoin as a better inflation hedge than gold is the main reason for the current upswing, triggering a shift away from gold ETFs in the Bitcoin fund since September. And this was the whole reasoning behind what they talked about as far as why Bitcoins price went up. They didn't think it was the ETF at all. It's just the fear of hyperinflation and what is going on with the Federal Reserve as they continue to print and print and print. And I have to tell you, it scares me as well. So that's what we have for that article. I think as time goes on and people start seeing the same things happening, I think people will start to see more about cryptocurrency, digital assets, mostly Bitcoin, probably even Ethereum, and get out of that as their flight to safety. Anyhow, let me know what you think about that in the comment section. Let's go on to our next piece of this El Salvador IMF deal. This one was interesting. And it's why I wasn't really excited about the ETF, but I kind of was excited. And this was one of the reasons. So El Salvador aligns 1.3 billion IMF loan by using Bitcoin adoption to even the odds. So the list Rodriguez El Salvador central bank head, a late fears of the country's decision to adopt Bitcoin as legal tender may hinder the approval of a 1.3 billion loan from the IMF. And that's what they're all trying to do. They're like, look, yeah, we won against your advice, but your advice kind of sucked. And it actually worked out pretty well for us. And he says, look, we don't see any risks, perhaps upside risks. We've explained openly the IMF for us, Chivo, which is their app, which all the El Salvadorians are using to transfer and pay for things in Bitcoin. And Bitcoin is simply a payment method. El Salvador is banking on the increased Bitcoin usage in the country with President Bukeli saying that more than a third of citizens have begun using the asset as currency. The deal with the IMF is of importance to the debt-ridden country. It opens a door to international markets in 2022. So here's the thing. When I see this, it's important that the ETF works. It's important that the price of cryptocurrency, mostly Bitcoin, goes up because then when the IMF kind of looks at it and goes, okay, and I know there's a whole host of a slew of information behind all this of why they would not approve it or why they would, I get that the IMF is the IMF. But if we can just kind of show them a little bit, like, look, we know you're not on board with Bitcoin. We know your reasons. We know you're pushing your CBDC agenda. But look, we're just using it as like use of payment because the old way sucks and it's awful. And with the remittance payments and actually the transaction fees are eating us alive and we can't get out of debt. So just let us use just this Bitcoin, just this thing here, and we can also move on. Also, I think it's a good thing that they do this and they relay the information that, hey, we use Bitcoin, we know you guys don't want to, but look what it did for us. And this was, just so you know, that El Salvador bought Bitcoin on September 6th, September 7th, and also on September 20th. And when you break it down to that, they've got, this is Bitcoin Treasuries, or by Bitcoin world, the Bitcoin Treasuries. And you can see right here that as far as the countries go, you've got El Salvador at 700 right here. So when we take a look at that and we just break it down as the, as the, what they did as far as how they're, how they're doing and how they're making out. So they bought on the 6th, the Bitcoin price was 51,000. They bought 400. So if you take, you know, 51,000 times 400, that was around almost 20 million, 20.4 million somewhere around there. They bought some on September 7th. And this was a pretty ballsy move, honestly, by Bokehle. He, they bought on the 6th, it was 51,000. And then it dipped like crazy. And he said, Hey, we're going to buy the dip. And they did it. They, they bought the dip 43,150 Bitcoin at six, almost 6.5 million. Then it dipped again, September 20th. Remember these sweet days? They bought it again at 45,150. So the Bitcoin price today is, let's just say, I like round numbers, not that smart, 61,000. So if we take that and look at the difference, that's, they just made $4 million and she's like a month, month, something like that. Yeah. And let's just extrapolate that all the way down for the other two time points. So yeah, so if we take this in a month, they went 45678, almost they made like $9 million just on their great investment, as opposed to putting into the US dollar, which doesn't appreciate, which is hyperinflating potentially, and it is not doing much good. And especially with those remittance fees that they are getting charged with. So in all honesty, if the IMF takes a look at it and says, well, and again, yes, you're, Rob, you're so naive to think the IMF, I get it, I get it. But if they really take a look at it and just go look, it's just for payments. This is what we're doing. And it's actually a good hedge against advance going on. Makes sense to me. So this could be, again, I hope this is a, I hope things don't go well. I hope the people who in El Salvador, they're holding on to Bitcoin a little bit. And of course they have to transfer it over and, you know, pay for the things they have to, but really rooting for this one. And hopefully it'll show the IMF and the SEC that, hey, well, we're here to stay. So just keep approving the things that will allow us to grow. Anyhow, let me know what you think about that in the comments section. Let's move on to our second to last. We'll finish up with two good stories. Second BT, second Bitcoin ETF launch on Friday. This was a Valkyrie. Probably missed it. No idea what this was, but apparently Valkyrie launches the second ever Bitcoin futures ETF. Would have been, of course they wanted to be first, but they weren't. But hey, they got in their second. The Valkyrie Bitcoin strategy, as known as BT, BTF. I think it's BTFD, which I think we all know what that stands for by the F and dip, which began training today, today on the NASDAQ and as the second Bitcoin futures ETF to launch this week. The launch marks the second time ever that the SEC has approved an ETF focused solely on crypto, even adjacently via the futures markets. Issues have been falling since 2013, which is why I didn't think it was going to get approved. But we've got this one, and then we've got Banak coming on, I think next week or November, something correct me in the comments, but I know Banak's got approved. They're just waiting for the date to go on. So if we take a look at this, the ticker is BTF, how did everything do? Well, not so good. They started off pretty well around 25 somewhere on there, then just kind of slid down, traded sideways, and then started off around 2430. So still down from its all-time high, but again, it's a futures ETF. It's paper Bitcoin. I don't really care about it. I want it to do well. But again, I just am more interested in the spot ETF like most people are and what we can buy and hold because it's hard to manipulate that.  Anyhow, that's what we got. And then lastly, we'll finish up with a little good news, Chainlink and Associated Press. I actually stole this from George with a CryptoZoras because I was watching his stream today and I was like, oh, I should talk about that. So if you listen to George, you already know this one, but I thought it was a big news. I'm glad for Chainlink, probably because I own it and I'm super biased on this channel. I usually just talk about all the things that I own. That's just the truth. But here's what we got. Associated Press plans to launch Chainlink Node to publish data. So Chainlink Tech is the ideal way. This was actually a quote from the director of blockchain and data licensing, Dwayne. I'm not going to try it. So Chainlink Technology is the ideal way to provide smart contract developers anywhere in the world with direct on-demand access to APs, trusted economic, sports, and race call data. And that's from the director of Associated Press. The Associated Press said its primary reason for the shift to blockchain was trust, and that the on-chain data provided would be a publicly accessible, safe, and secure record of verified information that DAPS and smart contract users can tap into. And that's the big story. And I think it's a great story for Chainlink because that, of course, will drive the price up. But the other thing is it's amazing. It's good to me to see this because we have a real big problem with news not being real. And some people will say it's fake news. Some people will say it's just inaccurate news. And so if in some way we can try to vet out some of these news stories, I'm like, that's not real. Or that is that. And they can do something like that with the Associated Press as it's on the blockchain. There is some way that developers could kind of use AI to say, this is not real information. This is not right compared to something else. This is a win-win. And of course, win, of course, that's Associated Press comes in. So look, that is it for today. There's a lot of stuff going on, but it's a big day in the market. My big interest is what's going to happen on Monday, but we'll see. Also, catch us over on the DCA show. It's me, George Krippers-Arras and James The Best Dancers. That'll be tomorrow, Sunday at, I think, 1130 Central, 1230 Eastern, so on and so forth. But that is it. So look, if you liked today's show, give it a thumbs up. That helps tremendously. Also consider subscribing. Everything we talk about are time sensitive and things are going to start moving rapidly. So if you want to subscribe, this would be a good time to do so. Anyhow, that's it for today. Thanks so much. I appreciate it. And I'll see you on the next one.


Being able to find the direction of the magnetic field is important. It will determine how things will behave inside this field. So let's run through a few examples, finding the direction of the magnetic field around a current. Let's say this is a current carrying wire, and in it, there is a current going up. Now, how do you find the magnetic field towards the left of the wire? Well, we'll use the right-hand ball. Point your thumb in the direction of the current, and then curl your fingers around the wire. Now, to the left of the wire, my finger should point towards you, which means that the magnetic field towards the left of the wire points out of the screen and towards you. This time, I have a current going towards you, and I want to find the magnetic field below the wire. So I point my thumb in the direction of the current, curl my fingers around, and below the wire, my fingers are pointing towards the right, which means that the magnetic field below the wire points towards the right. So what if I was told there is a clockwise magnetic field around this current? Well, I'll curl my fingers around clockwise, and my thumb should indicate the direction of the current. So in this case, my thumb points towards me, which tells me that the current generating a clockwise magnetic field points into the screen towards me. Now, knowing how to find the magnetic field is good and all, but we need to be able to read and express magnetic fields on paper. You can't meet and talk to everyone face to face after all, and this is what you'll be examined on. So let's look at a few examples on paper. So in this case, we have a current going towards the right, and we want to find the direction of the magnetic field at the dot. So applying the right hand rule and putting our thumb in the direction of the current, our fingers curl around and they point out of the screen towards us. To indicate a magnetic field coming out of the screen, we use a dot. In the second example, we have a current going down, again looking at the direction of the magnetic field at the point, and using the right hand rule, we have the magnetic field going into the screen at that point. We use across the show the magnetic field going into the screen. In this case, we have a current going into the screen. So point our thumb into the screen and then curl our fingers around. Where the dot is, your finger should point down, and so the direction of the magnetic field at this point is down. And in the last example, we have a current coming out of the screen. So I'm pointing a thumb out of the screen and curling our fingers around. Where the point is, your finger should point down and towards the right. So the direction of the magnetic field at this point is down and to the right. And if we wanted to show the entire magnetic field, we just draw the field lines. For a current going towards the right, it would have a circular magnetic field. On top of the wire, the magnetic field would point out of the screen towards us, and below the wire, the magnetic field would point into the screen, away from us. And because the magnetic field looks like this across the entire length of the wire, we would draw this across the entire wire. The magnetic field is stronger closer to the current, and so the field lines closer to the current are also denser. So further away from the current, you would have sparser field lines. In this case, we have the current going down. The magnetic field would go into the screen on the left-hand side of the current, and would come out of the screen on the right-hand side of the current. So we'd do the same thing as before, using dots to represent out of the screen and crosses to represent into the screen, and density of field lines is same as before as well. If we have a current going into the screen, then we would have a circular magnetic field around that current, and it would point in the direction that our fingers curl. So in this case, it's clockwise. And the magnetic field doesn't just exist on one ring around the current. It exists all around the current, so we have multiple field lines. The last example is very similar to the previous one, except this time we have the current pointing out of the screen instead of into the screen. And so the magnetic field would point anti-clockwise.


Hello friends, welcome to SSUnitech. My name is Susheel Singh and this is continuation of SQL Server interview questions and answers. So today I gonna discuss one more question which is related to interviews. So this question is totally depend on values based query. So what it mean? So let's move to another slide where we will discuss about the question. So this is our slide as you can see we have input table and it contains two columns. First is ID and second is name. In ID column we can see we have repeated IDs and in name column we have null values available. So we wanna skip those records where ID is same and one record in name column is null and another record is not null. So null record should be eliminated in our output. As you can see in ID one we have four rows and we can see we have name column and it contains 10, 11 and then two null values. In our output we don't have null values we have only not null values like we have 10 and 11 in our output. If we have only null values in name column with reference to that ID so we want to get that record in our output but record should be unique and we can see ID is three and name value is null so we want to get in our output but the ID is four we have repeated values. ID is four we have two rows and both are null so we want to get in our output only once as you can see over here. So how we can achieve this output by using SQL Server query. So let's move to SQL Server Management Studio to write the query and get the output. As I am using SQL 2014 you may have another version of SQL Server but query would be same for all the versions. I have already typed the query so we can execute and we can create the table and insert record on it. So nine rows affected table has been created successfully as well and we can execute and we can see this is our input table. So we need to write the query. So first of all we need to select only those records where value column doesn't contain any null values so we have to use where clause and then value is not null. So we have to use is not null and then we have to use union all and then we need to select those records where value column contains null values. So we can copy and we can paste it here and we can remove this not given. So it will return only those records where value column contains null values and then one more thing we need to check those IDs where value column doesn't contain null values and we have to eliminate in our second query. So we can use and keyword ID not in and then we have to use a subquery by which we can select only those records where value column doesn't contain any null value. So we can copy this query because this query going to return only those records where value column doesn't contain any null values and we can select only ID from here and now we can execute and we can compare before going forward I would like to use order by keyword and then we can execute this query and we can see here it's going to return seven rows and we can see four is coming two times and value column contains null values but in our output it's coming only once. So we have to use distinct keyword in our second query. So we have to use distinct and now we can execute and we can compare our output. So we can see it's going to return six rows and in our slide we can see we have six rows. So both are same. So I hope you have understand how we can get the output by using SQL Server query. If you like this video please subscribe our channel for many more videos and press bell icon to get all the notifications for new videos. If you need this script it will be available on my Facebook page you can copy from there. Thank you so much for watching.


You can obtain a basic BCEID online. BCEIDs are free and quick to create. If you already have a basic BCEID, you can use this ID provided you can remember or recover the password. If you have a personal or business BCEID, these IDs cannot be used. Using your internet browser, navigate to the BCEID website at www.bceid.ca. Begin creating your basic BCEID account by clicking the register button. From the list of types of BCEID accounts, select a basic BCEID by clicking on the register for a basic BCEID button. Choose the option to register without specifying an online service by clicking on the register without specifying an online service link at the top of the page. Complete the fields on the screen. Select a user ID that is easy for you to remember. Enter a password to best protect your profile. Create a password that measures strong on a scale. Confirm the password by re-entering the password again. Complete the known as, contact email, and contact phone number fields with your information. Your contact email is very important. Without a valid email address, when you submit your information, the information could be lost. Entering valid contact information also ensures you can reset your BCEID password if you forget it. If you cannot reset your password, you will need to obtain a new replacement BCEID. The Ministry can update your profile to use the new BCEID, but an office visit to re-link your profile will be required before you can see your personal information with the new BCEID. Complete the password hint questions and answers. They could be used to reset your password online if needed. Enter the text displayed in the security control image. It is important to read and understand the terms of use agreement and how they apply to you. Once you have read the agreement, click the yes I have read and I accept the terms of use agreement. Continue my registration.  You may want to save or print this page for your records. You can now close the www. BCEID.ca webpage browser window and return to the page your BCEID is required. You are now ready to log in. Important, always keep your BCEID username and password safe. This information allows you to access your personal and confidential information online and should never be shared. The Ministry will never ask you to provide your password.