Open your Chrome browser and go to dcucloud.uni.com. Log in with your DCU Google account details. Then choose Allow. Next you want to open your PowerPoint presentation on your device. Then you'll go back to Unicam and you will select Record Webcam or Screen. Next you want to share your screen. Here you have the option to share your entire screen, an application window, or a Chrome tab. In this instance I'm going to share an application window. I'm going to share my PowerPoint presentation, select the PowerPoint presentation and click Share. When you are ready to start recording go back to the Unicam screen. Now click Record. You can then go back to your presentation, turn on slide show mode, and work through your presentation as you would normally. Speaking through each slide, final slide, then you can stop sharing. Go back to Unicam and click Stop. Now I want to save my presentation to Google Drive so I will click Upload to Unicam. The video will start processing and once complete you can play it back to see if you are happy with it. If you want to edit your video click Edit Video here. And as you will see there are a number of options available to you including Trim Video. Once you have completed this click Save. If you have created the video as part of an assignment you can share a link to the video by clicking Make Public. Then copy the link and paste it into your loop assignment or your loop reflect portfolio or an email.


Hello, welcome to SSUnitedSocialListSide and this is the contribution of SQL Server interview questions and answers. So today we are going to discuss one more interview question that is total by multiple tables. So how we can get the totals if we have more than one table. So let me move to next slide to understand about the question. So as we can see over here, we are having three input tables. First is table A, then table B and table C. So all these tables are having two columns, first is id, second is the salary. In the output column, we are having only two columns that is id and salary. So we just want to combine all the salaries according to their id. So as we can see in table A, we are having id1, then table B, id1, table C, id1. So salaries for id1 is 100, 100 and 100 for each table. So here we can see in the output for id1 we are having 300. So we are going to combine all the salaries according to their id. But we can see here we are having id5 which is not available in table A and table B. That is only available in the table C. So we also want those id which is available in any of these three tables. So how we can get the output by using SQL queries. So here write any two methods to get the output. So let me move to SQL server management studio to write the query for getting this output. So here we need to write two methods for getting this output. So as I am using SQL 2017, you may have another version of SQL server but this query will work for all the versions. So first of all I would like to create these three tables. So let me execute the create statement for creating table A, table B and table C. So as we can see command completed successfully. So tables have been created successfully. Now let me execute the insert statement to insert the data on the tables. So we can execute these three insert statements. Table A is having 4 rows, table B is having 3 rows and table C is also having 4 rows. So we can write the select statement to check the data into the tables. So this is for table A. Now let me complete the select statement and paste two times for B and C. So this would be for B and then this would be for C. So now let me execute this select statement to check the data. So as we can see here for table A we are having ID, cell D then table B and table C. So we are having the same metadata as we seen in the slide. So for method 1 we just want to combine by using union all with all the values from these three tables. So how we can get that for method 1? So we can write for method 1 here we can use the CT. So let me use the CT then as inside that CT we just want to combine the data from these three tables. So let me complete these three tables and paste it here and let me put the union all between these three. So this is union all then again union all. If we will execute these three tables with the union all then we are getting all the IDs with the cell D. So next step we just want to combine all the cell D. So let me execute this select from CT and here we just want ID then sum of cell D. So this is the sum of cell D. So we can use the cell D and here we have to use the group by. So this is the group by and this group by should be on ID column. Now let me execute this query and here we can see we are having 1, 2, 3, 4 and 5, 300, 600, 900, 400 and 500. So let me compare with the slides data. So 300, 6, 900, 400 and 500. So we are getting the output as we were expected. So this is the method 1. So how we can write the second method to getting this output? So here we can write the second method. So second method is method 2. So here we just want to use the joints. So how we can use the joints? So we have to use the full joint. So let me use the first table that is part 39A and then we have to use the full joint with the B and C. So let me use the full joint with the part 39B this time and let me put an alias with the B. Now on A.ID then that ID should be equals to B.ID. Next we just want to use the full joint with the third table. So that is table C. Now we can put an alias with the C on A.ID that ID should be equals to C.ID. Now in the selected statement as of now if we just want to get all the columns from all the tables. So let me execute this. So here as we can see we are getting the ID, ID and ID. So we want to get the ID from the table A.If that id is null then look into the table B. If that is also null then we want to get the ID from table C. So for that we can use the colas function. So let me use the colas. So this is colas. So first of all I just want to get the ID from table A if that is null then look into the table B. If that is also null then from the table C. So here Golis is going to check the id from the table A. If that value is null then look into the table B. If that is also null then only look into table C. So it will be going to first not null value from the left side. Then we can put as id. Next we just want to combine the salaries. So as we can see salary from table A, salary from table B and salary from table C. So here again we have to use the is null function because we are having the null values and if we will combine the null with the value then output would be null. So is null A dot salary comma 0. If salary is null from the table A then that would be the 0. Then we need to check for table B as well. So B dot salary if that is null then put as 0. Then I need to check for third table that is table C. Then we have to use the is null then C dot salary and if that is null then we want to as 0. Then this will be the salary. Now let me execute this query and we just want to check the output. So as we can see we are getting the output as we were expected. So 300, 600, 900, 400 and 500. If we compare with the slides data then 36, 9, 400 and 500. So both are same. So these two methods by which we can get the output as we were expected. So thank you so much for watching this video. If you like this video please subscribe our channel to get many more videos. Don't forget to press the bell icon to get the notification of our newly uploaded videos. Thank you so much. In next video.


The Adventures of Sam Spade Detective brought to you by Wildroot Cream Oil Heratonic the non-alcoholic heratonic that contains lanolin. Wildroot Cream Oil. Again and again, the choice of men who put good grooming first. Uh, phone down to the drug store and tell them to send up free gallons of black coffee. Who is this? Are you sure you have the right number? I'm sure I've got the right number, but I'm not so sure who I am. Oh, Sam, it's you. You must have had a frog in your throat. Did you oversleep? Effie, don't say things like that. Oh, I'm sorry, Sam.  You're tired, that's it. Tired? I've only just brought Lazarus back from the dead. Well, then you better get some rest, Sam. You can dictate your report tomorrow. That's what you think. Now, stay where you are. If I'm asleep when I get there, wake me up. I'll be right down to dictate my report on the Lazarus Caber. Dashel Hammett, America's leading detective fiction writer and creator of Sam Spade, the hard-boiled private eye, and William Speer, radio's outstanding producer, director of mystery and crime drama, join their talents to make your hair stand on end with the adventures of Sam Spade, presented by the makers of Wild Root Cream Oil for the Hair. Next time you buy Hairtonic, be sure you buy Wild Root Cream Oil, for you see, Wild Root Cream Oil gives you these advantages.  Wild Root Cream Oil is non-alcoholic and contains soothing lanolin, so much like the natural oil of your skin. Yes, friends, next time you buy Hairtonic, look for that famous name Wild Root. Get Wild Root Cream Oil Hairtonic, again and again, the choice of men who put good grooming first. And now with Howard Duff starring as Spade, Wild Root brings to the air the greatest private detective of them all in the adventures of Sam Spade. But she says I'd like to know what's private about it. What's this? Overtime to relax. I don't want to relax, I don't dare.  How long do you think you can keep it up? With your help, I'll be in a coma inside three minutes. Thank you, Sam. Now you just lie down here on the couch and I'll take your shoes off. Now I can take dictation while you relax. Nuts, where's that black coffee? Sam, you're angry with me.  Please don't glare at me like that, Sam. I can't bear it when you just... I am not glaring. I'm trying to keep them open. Now sit down. I got to keep moving around.  Please, Effie, please. Date, fill it in. It's your life. Go on. Burn yourself at both ends. Yes, see it. Two A.J. Tatspaw Claims Manager, all risk insurance company, Tide Building San Francisco from Samuel Spade, license number 137-596. Dear sir. The following is an accounting of my services to your company in connection with a claim of M.R. Lazarus on the life of the assured Timothy R. Lazarus. The latter called at my office yesterday at approximately 11.30 a.m. He was tall, bald, handsome, tall, bald, gray-faced, and dusty. He looked as if he'd been buried and dug up several times. This may sound like a poor sort of jest, Mr. Spade, but my name is Lazarus, and I want you to bring me back from the dead. Wow, sounds interesting. Why did you die? When did you die? And how did you die? I was declared dead by the Appellate Court of the State of California August 28th last year by reason of seven years' absence. Who took it to court? My wife, Emma. Insurance? Yes. My wife and I agreed between ourselves to ensure my life in the amount of $100,000 that she would collect on legal presumption of death after my disappearance and continued absence for seven years. That's the law, Mr. Spade. Yeah, it's been tried a lot of times. What went wrong in your case? Wife double-cross you? If that's your attitude, I'm afraid I've come to the wrong man. Uh-huh.  Well, that makes it tough.  That's why I didn't go to the police. Even though we'd planned the deception together, she had reason to believe that I was actually dead. Suppose you cover the whole thing from the beginning, Mr. Lazarus? Yes. I married her back in 1940. And for a while we were happy. And then she became restless. You mean you were not able to support her in the manner to which she was accustomed? She was young and lovely. You wanted her to have nice things, but on your mega salary it was impossible. I know it's an old story, but life is like that. Well, you said it. Well, there you are. I was assistant cashier at the Golden Gate Bank. Oh, no, not that. I started taking small sums at first, meaning to repay them later on. Look, let's not go through the whole script. How much did you embezzle? $20,000. Yeah, so you decided to take it on the land before the auditors came in, and? I was going to give myself up, but Emma wouldn't let me. We made our plans that night. And I left for Mexico the following day. In Mexico City, I had plastic surgery done on my face, and then I settled down to wait the seven long years until I would be declared legally dead. I suppose you might call it poetic justice, but just before the end of the seventh year, I contracted malaria. It was confined to a hospital for more than 11 months. You have had it. The doctors gave me up for dead, and asked me to notify my next of kin. I gave them Emma's address. I never notified her, to the contrary, because it seemed to fit in so well with our plan. Too well, huh? Yes. I'd been to see her. And she refuses to believe that I am her husband. Of course, my appearance is very much altered, but there must be some way to prove my identity. You worked in a bank. They must have taken your fingerprints. I removed them from the files and destroyed them. How are your teeth? My teeth? Teeth. Who was your dentist here in town? Oh, Dr. Smith, the great professional building. You'll still have your dental x-rays on file. They're as good as fingerprints. You go there this afternoon. Don't give your name. Tell them you're Mark Humboldt. Have a new set of x-rays taken, and I'll do the rest. What's your wife doing these days? I, uh... Emma... Emma's married again. Who's the sucker? Pardon me? The man. Oh, he's a doctor. Dr. Ernst Wilhelm. Wilhelm? He's quite well known, I believe. Yeah, and the cops would like to know more. Now about my fee... Oh, Mr. Spade, I have no money. Oh, that's great. You have no money, and all you want is to hire a man to bring you back from the dead. And the more I succeed, the less chance I'll have of collecting. If I might make a suggestion, Mr. Spade, I don't know the ethics, but perhaps the insurance company? You would be doing them a great service. I think you're gonna live, Mr. Lazarus. They can't keep a good man down. I'll collect from them. I knew there wasn't a chance in 100,000 of shaking a fee out of your company. After all, you have your own investigators in the payroll and contract work isn't deductible under the new tax law, but something about Lazarus had gotten to me. Something else about him got to me at the Blue Bottle Bar and Grill where I stopped the lunch. Yes, indeedy. I'm Emma Wilhelm, Mr. Spade. Emma Lazarus, Wilhelm? I see you do know who I am. May I sit down? Slide down, Mrs. Wilhelm. Thank you. I'm glad to know you have a sense of humor, Mr. Spade. It's about that man, of course. Surely you didn't believe a word of his story. Which word? Oh, I'll admit there are slight traces of the truth in his raving. My first husband, Timothy Lazarus, was an embezzler. He did disappear, and it's quite true that I have collected the insurance on his life. I might even believe that Tim is still alive, but that man is not he. Then what are you so upset about? Oh, it's perfectly obvious what he wants. He's an extortionist. You're wrong. He doesn't want money, Mrs. Wilhelm. He wants you. Oh, Mr. Spade, how much do you know about my husband? Which one? Don't be flippant. Dr. Ernest Wilhelm? He made his first million, lead nuggets out of gang war casualties and lost it on a stock market. He cut his second million out of Nob Hill and called it surgery. He lost that on horses, blinds, and malpractice suits. The last time he was mentioned in the paper, there was a big picture of him pumping sleeping pills out of the stomach of an aging blessed queen. It may or may not have been coincidence that she did not recover and that she was the ex-girlfriend of one of our better-known racetrack habit-dashes. And if he got 100 bucks for the job, he was paid off and booed. Please don't say anymore. That poor girl. And he'll do the same thing to me. Wow. If you persist in helping that imposter, you'll be responsible for whatever happens to me or anyone else you involve. Mm-hmm. Anything else I should know? Yes. Both you and your client are being watched and followed. You can't escape him. He's not quite the has-been you'd like to think he is. After she had gone, I scraped her tears off my butter, finished my lunch, washed my hands with a nationally advertised soap and mushed over to the Drake Professional Building. I found my client's dentist in his lab polishing up a set of gold inlays. Humboldt? Oh, yes, yes. His x-rays have come through. Only set today. They're on the plant there. Don't touch them. They're not dry yet. Oh, I'm sorry. What's your interest, uh, police identification? How about digging in your files for the x-rays on a patient named Lazarus? Oh, yes, be glad to, of course. Well, let's see now. Larabie, LaVelle, Lawrence, Lawson, Glaskin. That's a G. What's that doing here? Ah, Lazarus. Timothy R. Is that your man? That's the name. Jimmy, April 1940. Should have been in for dental hygiene. After the mine, Miss Baker. That's my nurse. These pictures, how do they compare with this new set? Well, let's have a look. Switch on the light there, will you, please? And let's see. Malecruzion, well, the cuspids impacted third and motor. Ah, erosion in the land. Yes, it's very interesting. You mean they're the same in both sets of pictures? Oh, dear, no, no, no. Uh, man's mouth could change a lot in seven years. Oh, yes, especially with dental neglect, but that would never cause a man to grow new teeth. Oh, well. You see here, Humboldt has one more lower incisor and two more molars than Lazarus. And the whole character of the mouth is different. These two men would not look even faintly like. Oh, dear, no, Miss Baker's been with me for 10 years. Never made a mistake yet. Mm-hmm. Could I talk to her? Not in today, but out since Tuesday, cold.  How's this for a mystery? She phoned me this morning and thanked me for sending a doctor around to examine her. Now, this is the peculiar part. I have no recollection of having done so and I am not acquainted with the doctor she said I sent her. That wouldn't be a doctor Ernst Wilhelm. Well, why, yes, Wilhelm. That was the name. Do her another favor, will you? Call a doctor you do know and tell him to get over there as fast as he can.  Come on, kiddo. Which is Miss Baker's room? She's sick. Ain't having no callers. I'm her doctor.   If I had one, it would be around your neck. Now, March, show me the way. You can't force me. I know my rights. Oh, you do, do you?  I'm thrusting. I'm neat as a pin. You're as neat as a mud pine. I'll get going before I have the Board of Health down on you. All right, but you can't make me climb them stairs. Come on, come on. The triadica I have. Here's the keys. Okay. First door to the right. Thank you, Elsa Maxwell. She was stretched out on a bed, her left arm twisted under her and her right dangling over the edge. On the floor beneath it was an empty pill bottle. A few red capsules were scattered near it and some more were spilled out among the bedclothes. I ended sleeping pill suicide scene, but I didn't believe it. The body was still warm but no pulse. I didn't waste time giving her the mirror test. Instead, I looked around for a phone. It was on a table near a window. I meant to dial the police number, Sutter 12020, but SU was as far as I got. It felt like a bee sting or a quick jab with a needle. I spun around and swung out blindly. The face that I missed was suntanned under a shock of iron gray hair. I was wearing the same white toothed grin that Dr. Ernst Wilhelm always wore in his service. I started towards him and he backed away, still grinning. Come ahead, Speed. Come and get me. But hurry, you have only 20 seconds more. Shall I count them off? So far you have three, four, three, six, seven. The floor kept dropping a foot at a time as I walked toward him. But every time I got to the bottom of the incline it tilted up the other way and I slipped back. He kept dropping out of sight and every time I got him back into my line of vision he was farther away. The room opened out and disappeared into some clouds. The ceiling spun around faster and faster until it whirled away like one of those flying discs. Then the floor turned into gelatin and I sank into it. The makers of Wild Root Cream Oil are presenting the weekly Sunday adventure of Dashel Hammett's famous private detective, Sam Spade. Here's important news on good grooming. If you want the well-groomed look that helps you get ahead socially and on the job, listen. Recently, thousands of people from coast to coast who bought Wild Root Cream Oil for the first time were asked, how does Wild Root Cream Oil compare with the hair tonic you previously used? The results were amazing. Better than four out of five who replied said they preferred Wild Root Cream Oil. Remember, non-alcoholic Wild Root Cream Oil contains lanolin.  So if you want your hair to be more attractive than ever before, get the generous new $0.35 size of Wild Root Cream Oil, America's leading hair tonic, on sale at all drug and toilet goods counters. It's also available in larger economy bottles and the handy new tube. Get Wild Root Cream Oil again and again the choice of men who put good grooming first. By the way, smart girls use Wild Root Cream Oil too, and mothers say it's grand for training children's hair. And now, back to the Lazarus Caper, tonight's adventure with Sam Spade. The dream lasted about 300 years. Around Christmas time in a year 2247, another bee stung me. I opened my eyes, but the lights on the tree were too bright, and Santa Claus was bending over me with a brandy breath. Come on, man. Come on. Come on. Little willpower. You're conscious. That's it. That's it. Sensation returning. Here. Try and sit up. How about her? Too late. Did everything I could. Suicide packed? One of your brothers in Apollo was a little too handy with a needle. Here's the mark in my arm, and you'll find one on that stiff. Those sleeping capsules were a plant to make it look like suicide. You'll be feeling better soon. Now, come along. Up on your feet. Must keep moving. Restore circulation. Hip. Hip. Thanks. Thanks. You're the man Dr. Smith called? Yes.  How do you feel now? Still dopey. You give me something to pick me up? I've given you as much stimulant as it's safe to administer. For the rest, you'll have to sleep it off. And you will. I advise you to hurry home.  How long have I got? A couple of hours. If you keep moving, maybe three. Yeah. But if I were you, I wouldn't stay out. You don't want to fall asleep in the middle of Marcus Street.  Worst things can happen to you in your own bed. Look at her. Murder. I don't know. I couldn't. I don't know. And I've been an autopsy surgeon for 20 years. Well, cheer up, doctor. If you miss on her, you may get a second chance. Huh? Yeah. Me. Those eyes are looking better. I think you'll live. I wasn't so sure. Unless I could nail Wilhelm before my three hours as up was the safe bet he'd nail me again with that needle. He had done me one favor. He'd convinced me that my client was really the man he claimed to be and that Wilhelm and Emma knew it. My best hope of smoking him out was to dig out some solid proof. I spent 10 minutes of my three hours getting to the Hall of Records and 10 more finding out there was nothing there on Lazarus, but his death certificate. I had a gander at the wanted file at police headquarters. They'd checked him out in August of 47 when the court had pronounced him dead. I looked at my watch. With two hours and 17 minutes of wakefulness left, I just didn't have time. I stopped by Lazarus' hotel, got a set of his fingerprints and several samples of his signature, took them to a penman I know down on the mission and between us we forged the most amazing set of documents ever assembled on one man. All dated, notarized, certified, witnessed, registered, one even bore the great seal of the state of California and the signature of the governor. I squeezed them all into a large briefcase, propped my eyes open with toothpicks while I drank half a gallon of black coffee, then phoned Dr. Wilhelm's night number. I told him I was one of Russian Leo's boys and a cop had just winged me when I am from the jewelry store job. He agreed to meet me at his office. Is that all you gotta say to the guy you knocked off an hour ago? Look, I know that you know and you know that I know. They even wrote a song about it. So let's get off the dime and don't reach for a needle. This gun is bigger and it shoots farther. I can see you mean business. What do you want? First, I want to show you a few things here. Take a look. This is very impressive. You, uh... need any more proof that Lazarus is Lazarus? What's the matter, Spade? Getting sleepy?  I can squeeze this trigger in my sleep. Are these papers for sale? Why do you think I brought them to you? What's the price? Half the take on Lazarus' insurance. That's very high. I haven't finished.   I can't do that. Why not? Emma, she'll make trouble. She said she won't. She's still in love with him? Why do you say that? I just wondered what reason did she give you for not wanting him knocked off? Cops work harder at identifying a dead man than they do a live derelict that looks and talks like a crank. I had the same idea myself.  With him dead she can tell any story she wants to with him alive and all his proof of identity. He's in a position to nail both of you for fraud, conspiracy, perjury. Shall I go on? One thing. Does Emma know about these papers? Sure. You're lying. Sure I'm lying and those documents are forgeries that that's the way you want it. I haven't got time to argue.  I'll have Lazarus at my apartment in 30 minutes. All right, Spade. I'll be there. I made two phone calls on my way to pick up Lazarus, one to Emma and one to Lieutenant Erlinger of Homicide. Dundee was asleep. Lieutenant and Sergeant Pohlhaus were approached on the fire escape outside my window and Emma was waiting in the living room when we got there.  Emma, you recognize me.  I know. Mr. Spade's told me. Now listen to me, you two. You're sure you can go through with us. Oh, are you sure there's no danger? That's him now. Come on, Lazarus, get in the bedroom there. I'll do what I told you. Don't worry, Emma. I'm so frightened. Quiet. Got here, Justice. Emma, what are you doing here? Mr. Spade phoned me. I agreed. It's the only thing to do. I wanted you to know that. I can't believe that you've come to your senses for a while there. You see, you were wrong, Spade. Did you bring this stuff? Here's your money. I have the hypodermic in the case here. It's already loaded. We won't need a sterile needle. Where is he? In there on the bed. He was asleep a minute ago. The grogginess that had kept coming back over me in waves for the last two hours swirled over me again as Wilhelm leaned over the bed with his eyes closed. For a split second, I blanked out and I was afraid that it had already happened. Then I saw Wilhelm's hand coming down in the bleak angle toward Lazarus' forearm. Then my vision blurred again and my arms felt too heavy to lift. It was Emma's scream that jolted me back. I clawed out blank. Let go of it. You get it in your own arm. Let go. Swine, double-crossing. Here's a little sleeping medicine for you. Okay, boys. Yeah, a likely story. I get that broken glass, Paul House. Put it in the Dixie Cup. I handle it carefully. One analyze that medicine. You okay? Who are these people, Sam? Accomplices? Yeah, but not for homicide. What about Ernst? They won't let him go free, will they? Don't worry. He's out of circulation for good. Mr. Spade. Yeah, Lazarus. I don't know how to thank you. Yes, you don't know what this means to us. Yes, I do. It probably means another long separation. The state prisons aren't co-ed. But if you insist on being alive, you have to take life as it comes. Period. End of bedtime story. Oh, Sam, it's so sad. That poor couple so much in love.  Mm-hmm. They had to pay their debt to society, of course. That's why you had to be so hard and unreliable. Mm-hmm.  That's why you had to be so hard and unrelenting and not give in to your better nature. That's right. That's right. Never give in to the ship. Don't tread on me. It was, uh, Hobson's... Hobson's, um... What was it that Hobson... You may fire one ready. You know best, Sam. I'll just go type this up. And now, listen to this. A good friend of the family. Wild root cream oil hair tonic, folks. Wild root cream oil grooms the hair neatly and naturally, relieves dryness and removes loose dandruff. Now, get wild root cream oil at your drug or toilet goods counter in a new 25 cent get acquainted bottle. Also, ask your barber for a professional application of wild root cream oil hair tonic. Again and again, the choice of men who put good grooming first. Oh, I hear apron study. Sam, I'm not wearing an apron. Why don't you let me sleep? Sam, you've got to wake up. Your coffee's here. Tell them I'm in conference. No, Sam, no. The black coffee. You said to order three gallons. What? I couldn't carry it all. I'll make another trip. 24 cardboard containers. You'll have to drink it up fast now. They're leaking already. Abandon ship. Oh, Sam, what am I going to do with it? Oh, open a restaurant. Good night. Oh. Good night, Sam. Number three, turrets, open fire. The Adventures of Sam Spade. Dashel Hammett's famous private detective are produced and directed by William Spear. Sam Spade is played by Howard Dove. Lerene Tuttle is Effie. The Adventures of Sam Spade are written for radio by Bob Tolman and Gildow. Musical direction by Lud Gluckin with score composed by Rene Garriking. Join us again next Sunday when author Dashel Hammett and producer William Spear join forces for another adventure with Sam Spade. Brought to you by Wild Root Cream Oil. Again and again, the choice of men who put good grooming first. This is Dick Joy reminding you to... Get Wild Root Cream Oil Charlie. It keeps your hair in trim. You see, it's non-alcoholic Charlie. It's made with sooth and linolein. You better get Wild Root Cream Oil. You better get Wild Root Cream Oil. Charlie. Start using it to have a tough time. Charlie. Keep it all up. This is CBS, the Columbia Broadcasting System.


The study found that influenza vaccine coverage among Shanghai residents from 2015 to 2019 was low at 1.4%, but more than two-thirds of participants were willing to receive influenza vaccines following the Covid-19 epidemic and if the vaccine was made available for free, even more would be willing to be vaccinated. This article was authored by Yeongju, JingTang, Junji Chong, and others.


So in this video I'm going to be taking you through a tour of Stevens and giving you a glimpse of the life here. We are also going to be talking to a lot of students so that you get a real and authentic account of how actually it is to study in this university and I hope this helps you in making the right choice in choosing your university in the US. Hold this on the main entrance. So this is the main entrance of Stevens which I think most people will miss. Yeah because the first time when you come to Stevens it's like the cab drivers and everyone they'll take you from this entrance which is the main entrance and then you can see the entire view of Stevens. This is the Stevens and that's New York City. You can you know come here at the park you can sit have a coffee. Initially actually just Stevens was this much and then they started expanding more. So it's expanding and it's expanding so you'll see the pattern of buildings as well. These are like coordinated and then slowly slowly you have like glass buildings and everything. So as you know as per time they've modified it now. So tell me one unique thing about Stevens. So one unique thing about Stevens is you can see the entire skyline of New York City. That's the best part of Stevens you know. So if you want to study if you want to if you have an assignment somewhere there you can go for coffee.  You can do an assignment you know some good music and you can go from there. That's the best part of Stevens. The most unique part of Stevens. Do you guys actually buy textbooks? No. It's very expensive. Actually textbooks here are so expensive. I'd rather not. You don't really need textbooks as well. Like if you reach out to your professors they'll send you materials. PDFs. I think they are sufficient like their teaching and the notes that they give you. You have this app called Canvas. So everything like on the recorded lecture. Canvas is a student portal basically. That's an internal. See what Canvas looks like. Okay. The subjects and all. Then you can see your grades and everything. That's Canvas. So textbooks not required. Just Canvas isn't required. Canvas is enough. And you know if you really want to study then you can go on Google. Google books. You can find a lot of ebooks, a bunch of ebooks. So step number one once you come here is ID cards. Submit your documents first. You need to check in with IEEE.  So the thing is in Stevens we are known as the Ducks. So the Ducks are mascot. Antilia the Duck. Antilia the Duck. Antilia the Duck. So that's the thing. So the ID card are called Duck Cards. Do you have the ID? I do yeah. So you are the Ducks. So clearly you are new here. I have but I have to like take it like take it. I'm just kidding. JRE. Since Stevens didn't require JRE but still if you're giving JRE make a good score. So personally I had a good score of 324 JRE that was my JRE score. And due to that I got a good scholarship of 12,000. Like he said your friend got 12,000 for the certification. So you can do certain courses to get scholarship. You can get a good JRE score, maybe good 12,000 score. That's how you can get a scholarship as well. Many people are not aware about JRE. Okay and what about on campus jobs? JRE. But one thing is do not stick to work in the hotel. Like just come down here personally talk to them. That's the best way to go about this. I again kept up playing and never heard back. But all we had to do was come here and talk. JRE. But what type of jobs are you talking about? JRE. These are like recreational jobs are like dining and you can just campus management and all of that. But again like mostly graduate students go for TAs and RAs and all of that. That's again in your second semester. JRE. Okay and yeah you know about TRE. How is it here? JRE. So I was like approaching a lot of professors because a lot of my seniors told me that you know don't. So workday is a portal you might heard of at workday. There are a lot of companies they use workday you know for tourist job openings. So students also has its own workday portal. There are a lot of jobs on workday but you cannot rely on workday as one of the sides. So my seniors told me go and actually talk to the professors you know tell them about your course drop them thousands of emails. So you know I was doing that but then I was getting no response. So I quit in my first semester then I was focusing on internship then after my internship a lot of my friends who are just came like in spring they all got on campus jobs they all got you know TAs, RAs. JRE. Yeah and students yeah. And I was like I was like very shocked you know how are the new students were coming who came after me getting on campus jobs. Like I was so sad so you know I again started applying. I again I went on work day I started applying. I approached a lot of professors you know and then I was constantly emailing all of them. I was going to their office hours to their cabin. I was meeting them and then finally after you know so what you have to do is you need to send them your resume a small height of that this is your work experience these are all courses and then if you are lucky enough they'll reach out to you after a while like after one or two months and they'll tell you that I have these openings you'll be a teaching assistant you have to teach students as well that's what I do. So I have this course called where Bandita is one of the students. So basically in Steven's easy to get a scholarship than getting RAA or jobs. And the recreational jobs on campus are also mostly for like undergraduate students. Yes. Mainly they are preferred and for graduates it's again TAA and undergraduate. It's just time consuming. I would say as a newcomer as a upcoming student that you can get on campus jobs but you'll have to reach out to them. Yes. Yeah and you need to be very shabby so you need to keep nagging them. Directly email them. Don't just stick to the portal or any work they put away you can apply for a job just mail them directly before coming here. That's how you get an on-campus job as soon as you're like nine years. Bye. Thank you so much.


the first game back from the World Cup break, have you had a point up to it? Yeah, probably the last bit you said because we haven't come from behind to get any points that far this season and so the mentality was great and that's a big positive and I'll take a lot of positives from that. I thought we played some really good football, the pitch wasn't great but both teams really tried to play and that was important as well and they're never easy to play against and at 1-0 down after whatever it was the 60th minute you kind of, you challenge them and make sure that, and it's funny because I was going to make two subs before that happened anyway and then you go one down and we're able to get ourselves back in the game not just that, we continued and I thought there was only going to be the one team that looked like it in the winner and that was us as far as I was concerned and the stats back that up as well. He's not that bad, it's obviously precautionary. He would be doing a lot of training during this break and playing games and he felt a bit of a twinge a weeks ago and he wasn't fit to start but he was certainly fit enough to be in the squad and participate and contribute. So he felt it and I'm not taking any risks, not with him and any other players so I'll find out more in detail obviously later on tonight and tomorrow but I don't think it's not serious. They're fair and wise yes but don't forget the Wellington, this is like their home they've played two consecutive seasons here so they know every blade of grass they know how the wind goes, they know what the nets look like, what the corner posts do, they know everything so forgetting that for a second and yeah you're right, I've been in that position and it's not the best for Ulfi and for his players having to do that because it's such a different proposition when Wellington play in Wellington and yet we hadn't played here before we didn't get an opportunity to play here either because of the two concerts on both nights prior to today's game but like I said we need to change our mentality and we are, we're going to embrace everything that comes our way particularly any challenge. The side didn't hear that, sorry. There's a truck outside. Oh right, sorry Phil. Is that it Phil or is it not a question? Thank you mate, good to see you. Mark, you had lots of the possession in that game you were definitely the better side with the possession and really pushed it and gave it to them in both halves I thought but disappointing not to get the three points. Agree, yeah I agree with everything you said. The period away from the league allowed us to work on what I believe we needed to get better at and that's with the ball and my team has always developed into the season they continue to grow and I thought we did some really good football with the ball and had a lot of the ball but Wellington when they play against teams like that you don't underestimate them because they try to get you into a trap and get you on the counter and that's what they've done with other teams that try to play out so a very smart team and like I said they're well coached and well drilled and we just had to make sure that we didn't get caught into that playing out and getting caught on the break and that was really pleasing and like I said the chance is that in the game we certainly had the better of them and at 1-1 we really went for it and I was really pleased with that we came up short in the end but certainly the mentality was the right one What were the words said when you scored that goal? To keep going, to keep pushing there was a lot of belief as well amongst the playing group and they knew that we had to continue to win the second ball it was a real tough physical encounter at times and we did that and the young boys that came on we played that game and made a difference and that's what we asked from our substitutes as well Did you find it tough chasing the game? Well like I said you never want to go down in a game but it happens right? You're going to concede at times but we fought back from that and that's brilliant the players now have the belief that they can come back and not just draw like we did tonight but push on and go for the absolute win Physically we're in great shape we've worked in really hard in pre-season very smart with the way we do and work with them as well and like I said as last 20 minutes I thought there was just one team that was really putting a lot of pressure on the goal mouth and looking to get that winner Thank you Thank you very much See you Phil


Hello everybody, my name is Evan from jaspyscasebreaks.com today We are doing a 2013 Panini certified one box break to give away a spot in the NFL draft Mixer here on jaspyscasebreaks.com Everybody got two teams here for the filler. We're gonna roll two dice here to start We got a one and a four for five times. We have all of the names here The gonna copy them for a second team for everybody Craig right there has the last spot mojo little asterisk So trust me as Oliver says last spot mojo is a thing So we have Michael down to Craig gonna do this again four and one five times Good luck everybody one two three Four and one more for five times So we got Michael all the way down to Barry Now it's holding the five again on the bottom of that screen again. We got five times right here Five times again, that was Michael down to Barry Put this into the spreadsheet now for the teams again We're going to still use the same dice roll that is a one and a four for five times We got the Cardinals down to the Washington Commanders. Good luck everyone got one two three four and One last time for five. Good luck everyone Five times and we got the Cleveland Browns down to the Las Vegas or radas Put those into column B Alright now you do a or B you Do the No, no, don't do that yet. So read it off first. I would First of all let them be able to see it So go to 150 right here click the blank spot right there wait for the two arrow the double arrows to come up Double click that that'll resize to those now for fillers. I usually don't read off everybody's name I just highlight one through sixteen and say here's the first half of the list and all right So as Joe said here is the first half of the list one more thing here Grab the bottom of the window and Slide that until there's the two arrows and slide that up actually until on that screen Nope until it says until it's right below sheet one So look at that right there and spring that down a little bit Just a little bit more tiny little bit a little bit more Right about there. Okay. So anyway, I'm gonna show them one through 16 16 here first half and Then we have a 17 through 32. Yeah, the Washington commanders. I know right death taxes and last spot mojo Love it Gabriel. So there are the teams for this and then you print out now. I alphabetize by team right click That works to short sheet Print her out and let's get interesting just to get into the habit of this. Yeah Highlight eighth down to a one down to B32 got it Just get used to it and then put it put those boxes Grid all those up gridded and gorgeous and print rip print and rip You do a pay a workbook title and cheat name, right? For the number lock we need cheat name, but just Cool All right, so we're gonna get that fresh off the presses Washington commanders is Kenner again, this is for the 2013 certified one box break here So here is the list one last time for everybody And then we will get into the break. Thank you to everybody filling this out Again at the end of this video We will do a separate dice roll and a separate randomizer for the spot for the giveaway in to the draft wax party Good luck everybody. Here is 2013 certified football G.J. Flunker Autograph here 200 out of 299 for the Los Angeles Chargers That'll be going to Brian there out of 299 Big Ben and Robert Meacham Thank you. I would open up all the packs all at once. All right. Just stack them all up It'll be a lot faster that way. Sounds good Unlike Instagram We have to record all of these right and upload them so the less You don't need to read off all the cards You don't have to you can kind of go slightly faster than you would Make sure everyone sees every single card, but You know, yeah, you don't have to read off all the names you can just we just focus on the kids and Because if they someone wants to see what they can watch it as many times as they want Man, this was the prime of my fantasy football years all these names are coming back Right and I can't believe it Yeah, seriously Does right We got a rookie here of Aaron Millset rookie for the Ravens that is 36 out of 999 there going to Baltimore. Oh, okay Is that what we have the shipping team for? Because we want to give away the mixer spot. Oh, yeah spot. No one really cares about the break We have Jermaine Gresham here autograph four out of five five four out of five. We got a train whistle Four out of five Jermaine Gresham That is going to Steven and the Cincinnati Bengals there. There you go. Nice four out of five got another filler Followed by Eric Decker You see how you're cutting off the bottom. Yeah, all right there Pull your hands back a little bit right there We have Kenny Britt here 56 out of 250 Kenny Britt going to the Titans one of the biggest physical Freaks of all time just couldn't quite get it together in his head We got another rookie here. It is Ezekiel Anza for the Detroit Lions. That is 618 out of 999 going to Detroit Andy Dalton Number one out of a hundred beautiful there on the blue that goes to the Cincinnati Bengals and Steven as well Nice Tom Brady Brandon Whedon the oldest rookie of all time We do have a Doug Flutie here Doug Flutie is 117 out of 999 going to the Buffalo Bills and to Steven as well Speaking of the devil Brandon Whedon here in the gold that is 38 out of 49 Oh, no, he would just had gone in a bunch of Mormon missions. So he was like 26 28 like late Yeah, it's Troy Pogmalo Smokin J Tavon Austin 34 out of 250 new generation going to the Rams and Carl Would have been a huge car a few years. I've got a Terence Williams here. That is 567 out of 999 and Jamal Charles That is a Kansas City chief's uniform there 42 out of 299 for Casey and Steven by Dwayne Allen and good old Jordy Nelson All right, let's give away a Couple spots here in the or let's give away a spot. I should say into the draft wax party So we have to do a new dice roll here gonna do it twice For a two and a one for three times again, we're gonna add everybody's name to the list Well, but then So even if so it counts as two spots like we don't have to take it back down to the 16 No, because my mind is the same. Okay, just make sure so we got Craig down to Kenner good luck here again. We are gonna go two and one for three times one two And for three good luck everybody. I think he was 27. Yeah ridiculous We got Barry congratulations there Three times there congratulations also in the future Barry David can also click and to bring it down here If you if you want to add a little more suspense to the process, but all right All right, that's very gang. Congratulations there Barry. You got in to the draft party Not the draft party the the I should say NFL draft draft mixer. It's gonna be a party though We could win a wax party spot, right?  I'll tell you that much Anyways again, my name is Evan from Jaspies case breaks calm Thank you all so much for doing this one box of 2013 Panini certified. We'll see you again soon


Welcome again to ThinkTac. Welcome to the Art of Thinking Smart. I'm a guest host. My name is James McKay. I'm stepping in for Michael North today. Unfortunately, Michael North's daughter has some health issues in Vancouver, so he's unfortunately not able to join and we wish him and his family the best for the operation. So the show today is called Investment in Innovation Pacific Style and today we're talking with Shenoa Farnsworth of Blue Startups and they're working hard to build a whole innovation series of companies in Hawaii. So we have a short video we'll show, but if you want to tweet us, you can tweet us at ThinkTac-H-I or call us at<PHONE_NUMBER>. So again, Shenoa's work managing partner at Blue Startups. We'll have a quick look at the video for an introduction and then we'll have a chat and talk story. This is a rather dated video, so she'll be discussing a bit more where they've gone from when this was filmed. Yeah, BlueStartups.com. So it looks like a lot of fun anyway. That's what innovation's about. It's not about hard work and just not having fun but also enjoying what you do I think is probably one of the key things of the successful innovators. Okay, so sorry about the sound issues with that video, but you definitely check it out on the website, BlueStartups.com. And so welcome, Shenoa, to the studio today. Thanks for making the time. I know we all have busy schedules, so would you like to tell us a bit more since the video didn't have a lot of information about what is Blue Startups and how do you guys feel? Blue Startups is a venture accelerator was launched here in Honolulu in 2013 with funding from the state of Hawaii and in partnership with the Tetris company, which is run by Hank Rogers and his family. So Hank and Maya were heavily involved from the beginning in that, you know, birthing of Blue Startups. We've now done nine cohorts. We're in our ninth cohort right now, which means that 70 startup companies have come through our program. The program is a combination of investment and mentorship, so we provide a small amount of seed funding up to a hundred thousand dollars in stages and a heavy dose of mentorships. It's a 14-week program, 13 weeks here in Honolulu and one week in the Bay Area, with over a hundred mentors interacting with our companies and giving them advice and helping them grow and all that good stuff. And is there it's more of a technology-based? It is technology focused. Primarily we're focused on companies that have global ambition, so companies that want to scale globally. So we don't serve small businesses, but high growth businesses. Right, right, right. And I'm familiar with what's called now the elemental accelerator, which used to be the energy accelerator. Obviously their birth span a lot more than energy, so it makes sense that they rebranded to the elemental accelerator. So that in my mind would be the two foremost incubator hubs for businesses in Hawaii starting and expanding. Their goal too is also like global change of sustainability initiatives generally. So how do you guys sort of play together in the incubator spaces? Yeah, I mean we're good colleagues and friends. In fact the elemental accelerator, when they were energy accelerator, ran their first program out of our space. And we've been partners ever since. You know, when we get a good application in their space, we send it over, we try not to duplicate effort. So we're really again more pure play tech and they're in, you know, the spaces of energy and water and security and stuff. So there really isn't much overlap in terms of the type of company that we're working on. Which is good then obviously if there's a clear focus. Yeah, we've had like one, I think, company in common, which is Smart Yields. Okay, yeah. So that's the AgTech company. Right. Yeah, so we both had that company come through our program. Yeah, and so they can do both. They can. There's no reason why if you've got the time in the interest. And many people do both. We've had companies do both elemental and ours. And we've had companies do Accelerate UH and ours. So yeah. Interesting. If you're a startup in Hawaii, I think you need all the help you can get. So you might as well take advantage of all the resources we have. Right. So good segue for this show. Yeah, I think you're smart. So obviously Hawaii is not the easiest place to start a business and to keep it running. And we consistently get pretty low grades of if you're going to start a business in the US unless you really love surfing and sitting on the beach don't come here. Yeah. But what do you think then sort of some of the key attributes of the individuals that make up these companies that do succeed here? Like a list of things that you've sort of identified over your years of doing this stuff where you can be like, aha, there's a secret sauce, a recipe or? I don't think there's a secret sauce. It's just a lot of hard work. And those that are willing to work really, really hard are the ones that are succeeding. It's a pretty actually straightforward equation. You know, if I see an entrepreneur who is going home at five o'clock every day, I already know they're not going to succeed. It's just a guarantee. But your video had them all like stand up, paddleboarding on the beach and hanging out. Yeah, we totally believe in having fun and taking advantage of the beautiful environment here. But that has to be balanced with a heavy dose of working really hard, you know, because it's a competitive environment in, you know, the world. Right? So what I tell my companies is there's somebody right now in China, in India, in, you know, Yugoslavia, whatever. Vietnam actually is now.   Oh, well, disappointing lessons of today. So and on that side, like, if, like maybe talk about you personally, if you don't mind, like the history of how, like, where did you come from? How did you end up where you are today? And maybe is that for you? You've just kind of worked where you wanted to be. Did you set a strategic goal? Because obviously goal planning and achieving those goals are crucial to any business.  And these are the ways I'm going to do it. Yeah, my career has been much more material than that and opportunistic, right? So things I gravitated towards things that I found to be stimulating and exciting and interesting. And I've just tried to basically stay in that mix of things that are interesting, exciting, and stimulating to my mind for the bulk of my career. You know, once I'm bored, I'm going to go do something else. And so the startup world is, you know, a good match for that, right? It's constantly evolving. It's, it's ever changing. It's, it's, you know, every day is a new challenge, a new day. So there's definitely no room for getting bored or, you know, feeling like what you're doing is rote or not impactful. So those are the things that I think matter to me most. So I just tried to, like, stay in it. Yeah. And you're in an interesting role, obviously, because you kind of oversee all these companies, because it's kind of like you're, you have all these little crazy kids doing all these really interesting things. So you just sit at the dinner table. What did you do? What did you do? Oh, that's interesting. Definitely, there's, there's definitely the mommy analogy happens a lot. I'm called mom bear. I'm called mother hen. I'm called. I thought I just made an upset. It's definitely the case I am in real life a mom and in work life a mom. And people always ask me, you know, which of my companies are my favorites? And they're all my children. I love them all, you know, which of course is not true. I do have favorites. But, you know, there is definitely that kind of role that you play. And it's a tough love kind of mom, you know, obviously you can't be soft. It's not coddling. It's not, it's not nice, you know, necessarily, but it's strict and demanding and but supportive. And most of the companies that you are mentoring, or is that the right word for it? Yeah. Incubating. Are they like mostly from the Hawaii community? Or you do get a lot of? Yeah. So actually the way the program is designed, we is 50 50. So 50% of our class is always from Hawaii, because we are state funded. And also that's part of our mission to serve the local entrepreneurship environment here. And 50% of the class is from outside of Hawaii. Those that are coming from outside of Hawaii come from all over the place. But we have in recent years been targeting more and more Asian entrepreneurs. You know, we think Hawaii is a great place for doing business with Asia, you know, where East meets West. And we have a big event called East meets West every year where we bring in entrepreneurs and investors from both sides of the Pacific. So that's a big focus for us. So recently, we've, you know, recruited teams from Korea, Hong Kong, Singapore. So, you know, we're, we're looking more and more in that direction for deal flow and specifically looking at companies that are interested in getting into the US market. That's kind of the niche for us. And vice versa as well, we look for companies from the US that want to get into Asia. We think again, something unique that Hawaii can offer in the world of startups and accelerators that nobody else can. Yeah, geographically, obviously, we're very well positioned for that. And culturally. Culturally too. Yeah, exactly. There's a lot of reasons for that. It's a great model. And obviously, that's, it's a very global economy as you know today. So you can't be kind of looking at one state Midwest now. Yeah, so we like the mix of, you know, offshore in house kind of mix of a culture and mix of, you know, work styles and, you know, it's good for our local entrepreneurs, I think, to see the pace at which the rest of the world is working. Often, you know, breaks them out of there. Yeah, like, Oh, okay, I see that guy never goes home. You know, we have a team right now from Portugal. And I don't think they go home. And I haven't been there when they're not there yet. So and that's that's what it is. Yeah. So that's an interesting model. And I think it's great because one of the sad things and I've only lived here about six years now. I moved from Arizona, where you know, it's built on cheap real estate and just building new suburbs every month, it seems. And so obviously housing there is very affordable. I'd say cheap compared to Hawaii. So it's sad. I find when I hear about say graduates from UH, they can't find work here. So they go to the mainlanders because their cost of living is lower thinking they'll come back and most of them don't. So that seems to be an unfortunate side effect of the increased cost of living here. So we kind of, in my opinion, need these companies to be putting down roots locally just so the graduates have have somewhere to go. So on that note, is there a sort of a program or sort of an emphasis on your companies when they're recruiting to say partner with UH, because you've already mentioned UH, Accelerate UH, which should be another incubator. But obviously you want good talent that's smart, passionate, capable, which a lot of these graduates seem to be. But they're also another word pretty cheap, like they cost effective, right? If you can get someone that's a brilliant student, that's very capable, they're willing to work for a lot less than well me, say for example. Yeah, I mean, I think it's recruitment is a huge issue for our companies. Great. It's a huge issue for the industry, right? In tech industry, there's a huge war on you know, talent right now and trying to secure talent, trying to keep talent. I mean, it's it's everywhere, right? So we talk about the problems of not enough talent in Hawaii, but really that problem is universal to this industry in San Francisco. It's 10 times worse just because of the competitive environment there.  And many do feel like they have to go to the mainland to succeed. So you know, what I would say in terms of like, where we're at, we have this very kind of robust, early stage, startup scene, you know, past a certain level of maturity, it gets pretty tough. And then some of that's real, some of its perception. And you know, there are things like cost of living they that are hard to get around. It is expensive to live here. It's more expensive to live in San Francisco right now. That's one benefit we have. We can no longer say that it's more expensive than San Francisco, you know, so I can tell you that that's at least we're on par in terms of cost, but there are a lot of advantages obviously to being there. So it's a constant battle that we're fighting, I think, to keep our companies here and to also retain talent. One of the things we've wanted to do for a long time is kind of a, you know, more of a come Aina, come home program, or we're putting out the call to come Aina, like, hey, there's programs here, you can if you're going to start a company, come started at home, you know, or bring your company here, or what, you know, come and join a company that is here, that sort of thing. So it's hard to organize that effort, right?  Yeah, but I think, you know, the reputation of why and started paradise is growing. I don't go anywhere now where they haven't already heard about something happening in Hawaii, like, not sure what's happening there, but there's something happening there is kind of the, you know, the reputation right now that we have out there in the startup world globally. So I think that's our opportunity to take advantage of. And so say on the topic of innovation, and as you think is there more that the state could do to help foster this environment, say, in regards to sort of tax credits, or even say, like, UH State Institute, sounds like you're tapped for good resources. So maybe that that sort of network of what they're pushing towards needs to ramp up their IT side, maybe on that graduate soil. Yeah, I mean, I think it's really hard, you know, for government support to be done in the right way and to be done consistently. I mean, we got started with government support. And so we're really grateful for that. And I think there are other programs that we could do in addition to the programs that are supporting the accelerators.  But if there were a way to, you know, kind of ameliorate the cost of living issue for startups, I think that would be huge. So even housing or, you know, I mean, I don't think it has, it could be something out of the box. I don't think it has to be tax policy necessarily. I mean, that's the first thing that people think of when they think of incentives for businesses. But I think, you know, very simple things like just make it easy for people to move here, live here. It's very hard for our companies that come in for our program. Housing is the number one issue. Interesting. So you can have like a, yeah, a Welcome to Hawaii pack where there's one package where they can move into even an incubator space where it could be co-housing or something. That's right. I think I would love that. And, you know, people want to come to Hawaii. Any excuse they could think of to come to Hawaii, they're gonna, they're gonna do it, right? Well, you're just saying, you know, and then if you're providing them a welcome packet, I think that could go a long way. And I don't think it would actually cost the state that much. You know, it really, I think, could be a very cost-effective way of attracting accounts. So it sounds like a good bill, maybe, to propose you some legislatures that really understand the issue. Well, you gotta start somewhere. But, yeah, no, I like everything you've got too much to do. Never enough time to do it. Hard to lobby. Yes, it's a lot of work. Well, that could be maybe another topic would be time management and priorities of tasks and how we schedule that out. So, I think we do for a break soon, are we? Because we'll be back and we'll have a break and we'll be back in a couple minutes to chat about time and task management, I think, is a good one. Uh-oh. Steven Phillip Katz, I'm a licensed marriage and family therapist, and I'm the host of Shrink Rap Hawaii, where I talk to other shrinks. Did you ever want to get your head shrunk? Well, this is the best place to come to pick one. I've been doing this. We must have 60 shows with a whole bunch of shrinks that you can look at. I'm here on Tuesdays at three o'clock every other Tuesday. I hope you are too. Aloha. Aloha and welcome back. James McKay, guest host for Michael North on the art of thinking smart. And today we are joining Shenoa Farnsworth with Blue Startups Hawaii. And we're chatting about what makes companies' startups specifically work in Hawaii under her program and leadership in these programs. So we left on the break of talking about how we could create legislation to help more of these companies do better here, put down more routes, create local employment, and doing so might entail some additional legislation, which would foster sort of the if we don't everyone hates tax credits, right? That doesn't pass. It's like how do you create jobs and affordable housing is the issue. And I think every startup is probably challenged with that, like there's endless things they could focus on. So you know I'm in the space of energy, like I could be writing energy legislation the entire day and I don't understand. So that's not a good use of my time. So in these programs your applicants sort of pre-qualified, they experience people or do you have to provide a lot of them with say time management skills, email management skills? I mean I'm sure everybody could use time management and email management skills and sometimes we do have workshops on that kind of personal more personal growth and how to manage and how to grow a team, how to manage a team, how to lead, things like that. We don't spend a lot of time on that, we do spend more time on the nuts and bolts of running a business. So you know how to do financial projections, how to go to market with the product, how to acquire customers, what that's going to cost you. What does your customer even want, right? That's how we start the program, customer discovery. Make sure that you're building something people want to buy. Some really simple things that often are skipped in the entrepreneurial process. Because the entrepreneurs generally are so passionate about their product, they just think it's going to be the next Vegemite maybe? Absolutely, they 100%. You realize that was a terrible analogy. Well Vegemite is very popular. Well it depends. If we had the next Vegemite I think they probably make a lot of money in Australia. Yeah yeah, nowhere else. You're not global right? It's going to be peanut butter or something Peanut butter would be good. Yeah so I think you know they come with different skill sets and we try to compliment those and we're also we do some coaching you know. We notice that you're coming across this way because so much of success in this realm is is personal, it's relationships. Right definitely. Especially in Hawaii right? Everywhere. I mean are you instilling competence when you go and meet with an investor? Right? That's about a whole host of things.  I mean it's a whole series of things but if you go in looking sloppy, you know talking, you know, in a disrespectful manner, things like that, it's very easy to turn people off and they simply don't care how good your company is. Right? They have any reason to distrust you as a person and really that's the main issue is trust then they're not going to write a check. Right exactly. Or I want to have anything to do with your business. Yeah. I mean so the people are the most important part of the equation for us right? Is this the person that's going to take this idea or company from point A to point B? You know and if it's you know if it's not the person but the idea is brilliant, it's really easy to get lured in by that and we've done it many times. Trust me I've been a sucker for it so many times but it really doesn't matter at the end of the day how brilliant the idea is if you can't execute on it and if you're not the right person to carry that ball, it's going to fail. So in that situation do you sort of tactfully or diplomatically suggest they add someone to their team? We try. We try. We definitely do. I mean there's a certain point in the program it's our halfway point where we kind of switch modes from being supportive to being tough love. Like okay this is now most of my relationships. Yeah you know we're seven weeks in and here's what we've observed right and these are the things that you're going to have to address in order for this company to succeed and many of them are personal you know you are not going to be the CEO of this company if it's going to succeed you're going to have to replace yourself or you're going to have to build your team in a complementary fashion you need a person that knows this or you know whatever the the issue is So can you talk to about say the ideal company say if you've got one or two that you think are just the because this is you know the what people want to take away from this program is how can they be that company I guess yeah how can they emulate success is there a couple of companies that just are stellar on every level that stand out? I mean there's probably no company that's stellar on every level right but there are certainly companies that had uh I'll take uh bolted technologies for example that's one of our companies right they had a great idea so that's a building block they had a great founding team of the next building block and it has to be a team that's the other thing we see a lot are solo founders we can't invest in solar solo founders and we won't put them through the program we've again learned our lesson there you cannot execute as a solo founder in a way that needs needed in the fast enough pace and is that because simply there's just really too much to manage there's just too much to do it's just physically impossible yeah it's just too much to do and it also is generally a signal that you know maybe you're a control freak or you know then those things will come back to haunt you in other ways you know you you're not able to let go enough you're not able to bring other people into the company and all of that so so team is really really important for us and then you know within that team definitely it you have to have a leader you know and it is not an egalitarian process you know when people come in and say we're 50-50 partners and da da da I'm like oh boy you know like who is the CEO tell me right now because you're gonna need to know that and there is no such thing as 50-50 partnership right somebody has to lead this thing and they have all humans respond better to that kind of scenario than they do to the multiple head kind of organization yeah because I guess if you have any you know any decision point you don't want to be stuck in it's that it's everything it's just the it's you know having vision it's leading the team it's all of those things okay so it's it's a whole combination of you know of that that that makes it important for that person to be leading all right so hard work no eye and team perseverance I think that's probably my three and stop surfing so much pretty good I'm not gonna listen to so you keep surfing you just have to work hard to make up for it I never surf with a watch so all right so now well thank you for coming in I really appreciate it I hope you guys have learned a lot out there and thanks again to David Chang from Wealthbridge for hosting this show original founder and again best to Michael North and his family and quick recovery to his daughter up in Vancouver so I hope it goes well and we'll chat to you again soon from Think Take Away again I'm James McKay with Amoresco and have a great day Allah