Wel sy'n gweldlaf yma yma ernydd o sydd Siad C keysbynodaeth CRAF Cabinet. Gweithio coincidence ganhefn ac rydych yn y Cosiad Cresedig. R Jeju Puyddwn Seabed,ach tragen synth, ac yo Llymitraeth Prifysgwyl i'r senedl gyfan. 이렇게 mae'r unigamp ar hangar, ac mae'n cyflwymon, ...o atwetio yma yma ac mae'n ceisiau, iubachog. Diolch yn cy мнig rideitiad gan Y Cadababbanet is to take votes by affirmation and will continue with this tradition when we move to a vote on an item. I'll ask if members agree with the proposal. Apologies, that's the weekly fire alarm drill. Only members who are attending the meeting in person will be able to vote on any items. Members of the cabinet are entitled to speak before non-cabinet members. We'll start with those in attendance and then move to anyone online who would like to speak. Moving on. Are there any apologies for absence here, please? Thank you very much indeed. Item 3, declarations of interest. Are there any declarations of interest pertaining to items on today's agenda? No declarations of interest. Minutes of previous meeting. Members are asked to approve the minutes of the meeting held on Monday 6 February 2023. I move the approval of those minutes as a correct record. I think Councillor Brian Milne is going to second it. Thank you. Are there any issues arising from the minutes? No. Does anyone wish to vote? Do members agree to approve the minutes? Anyone wish to vote against? Anyone wish to abstain? Council therefore agrees with the approval of the minutes as a correct record by affirmation. Public questions. To my knowledge, we've received no public questions. Is that correct? Correct. Item 6 is issues arising from the scrutiny of an overview committee. Welcome to Councillor Anna Bradman, who is representing that committee. Councillor Bradman, would you like to speak now within the body of the meeting? Our main concerns in scrutiny and overview was that the data behind the decisions that were being made was clarified in a number of different places. That has been done in the reports that come to you today. We've got some very full notes at item 6, which explain our thinking. The only one thing that I just wanted to check was under the item, which is on page 19 of the agenda under the heading Shared Waste and Environment. It's sort of somewhere between point 15 and point 16. We were talking about reporting on recycling. It was pointed out under the KPIs that currently dry recycling and composting are reported as one KPI under ES418. But it would be helpful if it was possible that those, in order to keep a track of them, would be helpful if those for dry recycling and composting could be recorded separately. I think that was raised in the meeting, and I'm not sure it's here in the final report, but it's just a record that we wanted to see that. But otherwise, we've got a very full report from Mr Senior. Thank you. Thank you very much indeed, Councillor Bradman. Councillor Henry Bachelord, have you got any comments on that item that's been raised? Not immediately, but I can certainly raise that point with officers to see if we can help scrutiny and overview with that data. Thank you very much indeed. Moving on to item seven is the quarter three performance report, and Councillor Brian Milnes is going to present this, and I believe it's being seconded by Councillor Peter MacDonald. Thank you, Councillor Milnes. I've got the technology. Thank you. So yes, I'd like to present the performance report, and thank the officer Kevin Ledger, who has done a very good job again with the report between you. I think in summary, it's a continued good performance report. There's very little that have given us concern. We've been through this number of times, so I'm quite happy to recommend the report to Cabinet for approval. Thank you. Thank you, Councillor Milnes. Councillor McDonald. I'd like to second it, Leader, and I don't wish to add any comments. Thank you. Thank you very much. Are there any Members of Cabinet who would like to comment? No. Are there any Members online who would like to speak to this item? I'm not seeing anybody, so we'll move to the recommendation. So the recommendation is set out at paragraph 4 of the report, and that's to note the KPI results and comments that appendix A, recommending where appropriate any actions required to address issues identified. So do Members agree with the proposal? Anyone wish to vote against? Anyone wish to abstain? Cabinet therefore agrees the proposals by affirmation. Thank you very much indeed. Item 8, cost of living and options for continued support, and we've had some press releases out about this in the last few days. So Councillor Bill Handley is going to speak to this, and then I think Councillor John Batchelor is seconding it. So Councillor Handley. Thank you, Leader. Cabinet will recall that we agreed a package of support for the cost of living crisis back in March 2020, back in last year, and that support is due to end at the end of this month, March 2023. Of course, we're all very well aware that the cost of living crisis continues to have a major impact on all of us, and this report summarises very well the considerable support already put in place and presents recommendations as to how the council might continue to support residents through the next two financial years. It's an excellent paper, it's very clear. I'm not going to go through it in detail except to recommend to Cabinet that we approve the priorities set out in paragraphs 29 to 36 and the £206,000 funding which is set out in paragraph 38. Just before I finish, I would like to thank, as I said, this is a very well written report, very well researched, and I'd like to thank the officers in the community's team for it, especially to Chris Richards, who spent a great deal of time on the cost of living project and has been very effective in delivering the council's support. Thank you very much. Thank you, Councillor Handley. Councillor Batchelor. Thank you, Chair. Yes, happy to second this recommendation. We're doing all that we possibly can to help in the circumstances, even where we don't perhaps have a legal responsibility, so I think it's an excellent proposal, and happy to support it. Thank you very much indeed. Can I just make sure that we are miniting the Cabinet's thanks to the whole of community's team and also to Mr Chris Richards in particular. That team have stepped up again and again during COVID crisis dealing with Ukraine and now we've cost a living. One thing after another has been thrown at them, and it's not ever as if one of those issues has gone away before something else lands on their plate as well, and I'm immensely proud of the way that they've reacted to everything that's landed on their plate, so thank you very much indeed. Are there any questions from Members of Cabinet? Any questions from anybody else online? No, thank you very much indeed. Sorry, Councillor Bradman, did you want to add anything on behalf of Scrutiny's paper? Thank you. We had asked for more evidence of the need, which has been put into the paper. We utterly support the need to do this, but we were glad to see the additional evidence behind it in the paper. Thank you. Thank you very much. It's one of those things where we all know there's a need, but sometimes you just need a little bit of this extra clarity, so thank you very much for the contribution of Scrutiny and overview on that. So it's recommended that Cabinet approve the priorities set out in Paragraph 29 to 36 and the £206,000 funding set out in Paragraph 38 to continue to support South Cambridgeshire communities during the ongoing cost of living crisis. Do Members agree with the proposal? Anyone wish to vote against? Anyone wish to abstain? Cabinet therefore agrees with the proposals by affirmation and thank you again to Councillor Handley and to all of his team. So moving on swiftly to the new compliance policy and we've got to get used to using this word compliance rather than enforcement because it actually has a very different meaning. So Councillor Toomey Hawkins is going to present this and I think Councillor Henry Bachelet is going to second it. So over to you, Councillor Hawkins. Thank you very much Sharon. Good morning everyone. As part of the Greater Cambridge Shed Planning Service Transformation Project we have been undertaking a review of all the activities of the compliance processes which is formally enforcement. We review the ICT system, as you know, we've now migrated all our reports into the enforcement module of Uniform which allows us to improve the reporting of riches and helpers managed. We've also, as I said before, in previous meeting created a compliance webpage which has a lot of information on that including a video that explains what a bridge is and what it is and to help people when they think there is a problem. This is available of course 24-7 and enables them to give us documents and photographs which helps the planning team. And this policy document is the last stage of that process and I just want to thank officers for all the work that they've done in getting us to this stage. Now up until now the two partner councils that's Cambridge City and us had our compliance policies. What we've now done is actually combined. So now we have one so that the team works as one which is the whole point of the joint service. We're still keeping the register of enforcement actions and that's available through the public access system. I just want to say there's a lot in that document which I would encourage everyone to actually have a look at. It sets out what we will do in different cases and what can be done, what notices are used and when. Well at the end of the day enforcement is a discretionary action and each case will be looked at and dealt with on its own merit. So without further ado really I just want to ask Cabinet to support the recommendation that's set out in paragraph 3 so we adopt one unified compliance policy. Thank you. Thank you Councillor Hawkins, Councillor Batchelor. Thank you leader. Happy to have your second recommendations as in the papers as Councillor Hawkins has mentioned. We now have a shared planning service between ourselves and Cambridge City Council. We're working on a shared local plan currently so it makes sense to me anyway to have a shared compliance policy. Also this policy we see in front of us has been through both committees at South Cams and City. There have been some changes made to the original draft so I think it's safe to say it's very robust and I hope broadly supportive. So yeah I'm perfectly happy to second and would also recommend to Cabinet the recommendations on the paper. Thank you very much indeed and can we please minute a bigger pardon so Councillor Bradman. Thank you. I just wanted to ask has it been brought to the attention of the joint development control committee as well? That I don't know. Heather are you able to answer that? It went to both planning committee in South Cams and the city. It didn't go to the joint development control committee. I can confirm it didn't go to that. However everybody had the opportunity to feed into it and when we did the consultation we also sent out the consultation to every member including those on JDCC. Thank you very much. Thank you very much Heather I think that covers it perfectly well. So thank you very much to Heather and her team. I actually think this is incredibly useful document which I'm going to be keeping in hard copy actually because it's a manual for me as a member and I think will act as such for parish councils as well and part of the problem is that people often don't fully understand what our role is and what compliance means and this sets out in really plain English what we can do and what we can't do and what things we might need to intervene with so I think it's an extremely useful practical day to day manual for compliance. So thank you very much for that indeed. So if there's no other questions from Cabinet or from anyone else online. No okay which will move to the recommendation set out in paragraph three of the report to adopt the unified Greater Cambridge Shed Planning Compliance Policy. Do you members agree with proposal? Anyone wish to vote against? Anyone wish to abstain? Cabinet therefore agrees the proposal by affirmation. Councillor Bradlin. Will it be circulated to parish councils? Will the fact that it is now in place be advised to parish councils because they are the people who are most concerned about compliance? So Councillor Hawkins has said yes. Yes it is. Okay nods all round. Thank you very much indeed. So item 10 confirming arrangements for the four day week trial and next steps. So this is obviously quite a high profile item for us. Councillor John Williams is going to propose this and I'm happy to second it. Councillor Williams. Thank you leader. I'm very pleased to ask Cabinet to confirm the arrangements going forward for continuing the four day week trial and the way in which this council will decide in May whether or not to continue with the trial. So I'm just formally moving these recommendations. Thank you Councillor Williams. So this is just saying what the next make it very clear in two sides of A4 what the next steps and process are. Any questions from members of cabinet? Any questions from anybody else? Councillor Bradlam. The question is are we monitoring adequately the response from members of the public who might be trying to get through to officers? I'll ask the chief executive to respond to that. Thank you chair. Yes we monitor that through our usual KPIs on the performance of the contact centre. So that's how many calls have been received and dealt with and how long the calls have taken. We've already taken two reports to implement the staff and committee and strategy and resources in the city. And there's a third report going next week to strategy and resources in the city which includes that data. Councillor Bradlam. Thank you. And are the response to emails being monitored as well? So we have performance targets for responding to emails but that's a little bit more difficult to monitor. And we never have monitored that in the past in the same way that we've monitored the contact centre. What I can tell you is that during the four day week trial people have been required to include alternative contacts on the day that they're off. And I've had anecdotal feedback including from yourself Councillor that that has actually made it easier to contact people because there's always an alternative contact. Occasionally we've slipped up in terms of the alternative being an annual loop but we have tried to tighten that up when I've had that reported to me. So we don't monitor responses to emails in any sort of using IT so I don't have data on that. What we tend to see is if there were significant issues there it would come through the complaints process. As you know from our recent complaints performance actually that's not been an issue. Thank you. Thank you. And actually people are unhappy if things aren't dealt with actually landing my inbox and I'm not seeing an increase thus far. Thank goodness. So any questions in the room or online? No, thank you. Recommendations set out in Paragraph 5 but the report is to confirm the arrangements for the next steps of the four day week trial. So do members agree with proposal? Anyone wish to vote against? Anyone wish to abstain? So cabinet therefore agrees the proposals by affirmation. And now item 11 is the 2022-23 revenue and capital budget monitoring for quarter three. I think Councillor John Williams is going to present this and I think Councillor Brian Milne's is seconding. Thank you. Councillor Williams. Thank you leader. I'm very pleased to bring this to cabinet. If you look at Appendix B variance for both General Fund and the HRA you will see that despite a very difficult year and very turbulent year our officers have done an excellent job of keeping in line with budget. And we expect the outcome to be pretty much in line with the forecast that we made at the beginning of the financial year. So congratulations to everyone. Thank you. Councillor Mills. Thank you. Certainly comparatively with other local authorities who are having great financial difficulties it's reassuring to see that we're getting pretty good scores on the doors for this. So thanks to Peter Maddock and his team particularly for maintaining that. And John who spends an audience of that time on these issues. So thanks to them all. Thank you. Any questions from cabinet members? Any questions from scrutiny? Anybody else online? No. And thank you very much for the clarity of this report and the really helpful explanatory narrative which certainly helps people like me to deal with all this. So thank you very much indeed to all of the team who worked so hard on this. So the recommendation is set out in paragraph 3. I'll find my way back to it. It's quite long so I'm not going to read it out. So in paragraph 3 do members agree with the proposal? Anyone wish to vote against it? Anyone wish to abstain? So cabinet therefore agrees the proposals by affirmation. And more on money. Item 12 is the investment strategy. And Councillor John Williams is going to present this and Councillor Peter McDonald is due to second it. So Councillor Williams. Thank you, leader. The reason that we've had to make these changes because we've had some changing guidance with SIPFA. There's been some changes in government guidance. Of course we have the public works loan board change which has meant that we basically are no longer able to invest purely for yield. And as a result of that we have looked at how to restructure our investment strategy to allow us to continue to invest in social capital projects. And also those projects which are economically important to ensure the continued economic development of the district. And that we've done and you'll see that in the new investment strategy which is in the appendix A. This has gone through scrutiny and very grateful for the comments that scrutiny made. And I think this revised strategy, this revised investment strategy will continue to deliver us not only growth in the district. But it will ensure that the council continues to receive income to support its essential frontline services. I think it's worth mentioning that we, something like this year, over £5 million will be receiving an income from our investments which will help our general fund. Also I would mention that a lot has been said recently about our debts and how much we are paying in interest on some of the loans that we have made. Bit mischievous because most of that is to do with the HRA and the loan that we took out many many years ago. If you take that aside then actually our loan, the cost of borrowing is very very reasonable. We are something in the region of half a million pounds a year we are paying on what we have borrowed so far for the investments that we have so far made that are not connected with the HRA. So you know again I think this shows that this council has acted in a very prudent way, cautious way and has made some actually very canny investments over the past few years. This which has enabled us to receive a very good income from for example Irmond Street which is now part of our housing strategy and from our commercial investments. But as I say we have had to review this strategy to ensure that we keep within the new guidance set for us by the government. Thank you very much and thank you for clarifying the misinformation that has been out there recently about the amount that we spend servicing loans so that is very welcome. Thank you Councillor Milne's. Sorry Councillor McDonald I beg your pardon sorry. I would like to second the strategy just make a very quick comment because many local authorities and well residents can send many local authorities taking risky investments. If we look at our loan to value ratio it's still very good very healthy and so again that sort of mischief that's going out being circulated in some parts of the community residents can be assured that when they look at that loan to value it's very responsible. Thank you very much for the clarification. Any comments from scrutiny? Councillor Bradman. Thank you leader. At scrutiny we talked around the figures and came to our attention that there was an element in the table at 8.4.1 on page 132 which looked odd. This was row C in that table net service expenditure and in discussion Mr Maddock undertook to strip out an element of capital expenditure which he felt was inappropriately allocated there. He's corrected that in this table here but unfortunately I've just alerted him to that strange anomaly is still present in the table on 8.4.2 net service expenditure and I think he is happy to sort that out. That was one thing. It made the net service expenditure appear strangely high in 2023-24 and then lower in the subsequent years without apparent explanation so I think Mr Maddock can perhaps explain that. The other thing was that and indeed yourself leader you've alluded to the fact that it's sometimes quite hard to look at these data and so one of the things that we asked for in scrutiny and overview was training for all members so that we can all look at these data. This data with a level of having been informed about what it means. So that was one of the things that came forward. We had had very good training actually in earlier years and perhaps it's only COVID that's gotten away so we'd like to see more training in our investments. Thank you. Thank you. Thank you for your attention to detail. Mr Maddock do you want to comment on that? Yeah so the table at 8.4.2 we see the figure net service expenditure that should be 22865 as it does in the table at 8.4.1 which would then make the ratio 24.8. Thank you very much for pointing that out and that'll be corrected and on the subject of training absolutely the better trained members are, the better members they are. So we will always respond positively to requests for training. Are there any other questions from cabinet members? Anybody else? Anyone else online? So my thanks to Peter Maddock and Ann Ainsworth our chief operating officer for again considerable efforts into this which will just will continue to see us on a safe footing here. And as Councillor Williams has said you know delivering significant amounts of money to subsidise the services that we provide for our residents so thank you very much. So moving to the recommendation set out in paragraph 2 of the report to consider the report and if satisfied recommend to council the updated investment strategy attached at Appendix A. Do members agree with the proposal? Anyone wish to vote against? Anyone wish to abstain? So cabinet therefore agrees the proposal by affirmation and moving on to the last item. So this is the South Cams Limited Urban Street Housing Business Plan update. Now members please note Appendix A of this report is restricted because it's commercially sensitive. I don't anticipate that we need to discuss the detail of this but can you let me know now if you want to so that we can move into closed session. If during the discussion things change then we can do that at will. So this item will be presented by Councillor John Batchelor and seconded by Councillor John Williams. Thank you Councillor Batchelor. Thank you very much. I'd just like to make a few comments particularly on the social value that Urban Street actually adds to our organisation. They work as a close partner in our housing department. They provide accommodation for vulnerable groups, refugees and asylum seekers. For example we have two houses in Camborn which are used as houses in multiple accommodation and let by shire homes. They're used as temporary accommodation reducing the need for bed and breakfasts. There are a range of other added values. It's a solid business run ethically and with additional social value when opportunities arise. Rehousing another Afghan refugee family making for now that we're supporting. Working with partners and care providers in Peterborough to provide specialist housing for those with additional needs. Providing accommodation for asylum seekers and refugees via the Government Agency Circle. The company has been subject to a full range of audits specifically health and safety indicating good governance and full protection for tenants. The company has undertaken a green energy audit to improve the portfolio by way of energy efficiency measures. The 500 target that was set for the company was achieved back in 2022 having spent 94.6 million pounds within the budget of 100 million. The section 151 officer and portfolio holders for housing and finance agreed that the company could continue to acquire as opportunities were presented. The current total is 503 properties taking the total to 99.8 million. This provides an additional 30 letable properties. Any further expansion in the form of additional housing beyond the 503 properties will be subject to further agreement from the council within the agreement about future loan terms and rates. The company's activities will benefit the council by about 3.43 million in interest payments in this year. The council proposed an interest rise from April this year until March 2025 that would be at 4.25% which was accepted by the company and would increase the return to the council of more than 4 million pounds per annum. This is a really good news story from all sorts of aspects and I'm sure Cabinet would like to join with me in thanking Duncan Bessie and his team who have actually created this company from scratch and proved to be a huge success which is bringing benefits of all types, not least financially to our organisation. So my thanks to him and I'm very happy to move the recommendation. Thank you very much Councillor Batchelor. Councillor Williams? Thank you leader. I too are very grateful to Duncan and his team. This is not the same company that was in place when we took over this council. The company in the past was purely there to make money for this council. What we've done in the past five years is we've certainly a whole hearted support of the company and that is to ensure that it becomes part of the housing strategy delivering housing for everybody and within our travel to work area. So that's been helping us with housing and multiple occupation. As Councillor Batchelor said it's been helping us to find housing for refugees. So this is a company which is now yes delivering an income for this council and a very good income for this council but it's also providing housing for this council that this council wouldn't otherwise be able to do. I'm very pleased that it is helping to find homes for Ukrainians which will eventually become council houses. So all in all as I say this is not the same company that we took over. We have considerably developed it with the help of Duncan and his team and we look forward to it continuing to be a part of this council's housing strategy. Thank you very much Councillor Williams. Are there any comments from Cabinet? Any comments from anybody else? No, so thank you very much. Indeed the company has come a long way and all credit to Duncan and his team for their ability to move with the times actually and turn this into something which we are immensely proud of and the fact that it's now delivering social and environmental value as well as absolutely critical housing for those in greatest need is a source of pride to all of us and thank you very much to Councillor Batchelor for his very strong leadership on this, much appreciated. So if there's no other questions, the recommendation set out in paragraph 5 to note in their capacity as shareholder the urban street business plan for the period 22 to 23 to 31 to 32. Do you members agree with the proposal? Anyone wish to vote against? Anyone wish to abstain? So Cabinet therefore approves the proposal by affirmation. And that brings this meeting to a close. Members of the public were watching the webcast. This means the video stream will now end. Thank you ever so much for joining us for today's Cabinet meeting which has been quite quick, which was always nice. The next meeting of Cabinet scheduled to take place on Monday 15th May at 10 o'clock. So thank you very much everyone. Thank you very much officers for your participation.


We shall fight on the beaches, we shall fight on the landing grounds, we shall never surrender. We shall never surrender, we shall never surrender. You know Christopher Nolan is getting better and better and better with these IMAX cameras. He's a beast behind the camera with those things. And now he's telling the true story of Dunkirk of how 400,000 men were trapped on a beach trying to survive. My name is Brenny Keith-Avery and this is just my opinion. Alright, what's up guys? So here is my review for Dunkirk. I've been looking forward to this movie for quite some time. It's being written and directed by Christopher Nolan. He's one of my favorite directors. He's probably one of the best directors out there in the game, arguably. He's been doing it, doing this for quite some time. I've always been holding it down. I have nearly every film in my collection that he's been a part of. I got Memento that came out in 2010. He also had a film called Insomnia which came out in 2002, which I don't have. Of course I have Batman Begins, one of my favorite comic book movies. They came out in 2005 on Blu-ray. Then I got The Prestige on DVD that came out in 2006. This is probably one of my favorite Christopher Nolan films. I can't find anything wrong with here. 2008's The Dark Knight. And then we've got 2010's Inception, great movie right here. Probably the worst movie in his filmography is The Dark Knight Rises. And that's saying a lot, because this was still good. It wasn't as good as Batman Begins or The Dark Knight. But this is his worst movie. The Dark Knight Rises is your worst movie. That just goes to show how talented of a director you really are. And then I have 2014's Interstellar. And this was much better on the second, third, and fourth viewing. And when Dunkirk comes out, I will be getting that in my collection as well. But if you don't know already, Dunkirk is about the true story of in May of 1940, during World War II, where the British, Belgium, Dutch, and the French armies were fighting the Germans and they got trapped on the beach at Dunkirk. And they're just waiting to die basically, or just trying to get rescued. And they have no hope. And Christopher Nolan decided to tackle that. I'm really glad he did, because he puts a lot of passion in his work. And he did here as well, especially with it being a true story. You know, I'm pretty sure that this movie is going to be pulling on a lot of heart strings and, you know, from a lot of people around the world. Another great thing that I'm glad that he did this movie is because, like I said in my intro, he's really good with the IMAX cameras. I mean, 80 to 85% of this whole movie has been shot with IMAX cameras. I could have saw this on Tuesday, but I did want to wait till Thursday night because the screening that they had, they said it was a fake IMAX screen. It wasn't a real one. And I'm not cool with the IMAX. I like the real IMAX, the real 70 millimeter display. The screen is just so large and tall. And so I really wanted to see how great he did with the IMAX cameras and he did a great job. You know, probably one of the best things in the whole movie is anytime you're trying to portray war, you want to show how serious it is and just how daunting it can be and how it can mess you up physically and mentally and what better way to do that with IMAX cameras with the great resolution. So during the movie, I really like seeing all the dog fights in the air with the fighter planes, and I was about to say jets, but with the fighter planes flying around. That was pretty intense there. I do have a gripe about that, but I'll talk about that later. But about the movie itself, continuing on, what I liked about, and I kind of have a pro and a con with how it started off because it just starts and you're just right there in the midst of it, just in the middle of battle. There is no build up.  And then that's great.  So he did a really good job there. Something else that I really liked about the movie was the score by Hans Zimmer. Hans Zimmer always does the scores for Christopher Nolan and it's like the perfect marriage between the two. I mean, Hans Zimmer is, you know, probably the top three best composers out there in the game right now. So he did a great job with the score. He also did a great job with the IMAX cameras. I really do. I really did appreciate that. And with this being a true story, the most important thing that Christopher Nolan should have been able to do and he did a great job with is just kind of just show you the emotions and the pain and the fear that all these soldiers were going through. I mean, this really just sucked.      And that is, I can't even become remotely close to, you know, putting myself in that situation and imagine that.  I mean, some soldiers did that.   I really could feel the pain and the intensity in each of the scenes, especially with the score from Hans Zimmer. And Chris Fanola always does with all these films. He's really good with his montage, especially at the very end of every movie that he has. He always have three to four to five scenes bouncing back and forth with this riveting score just to ramp up everything. He didn't do that at the end of this movie. He did it a number of times throughout the movie.  But for some reason that was intense or whatever. And Chris Fanola and Hans Zimmer, they're able to do that, which does make the movie a lot better. Something that I, you know, a gripe that I do have about the movie is that during the dialogue, sometimes it was kind of difficult to understand what everyone was saying. You know, I had to struggle sometimes to make out the words. And there was a lot of quiet moments, you know, which is fine, but there were too many quiet moments to where I wish someone would explain to me exactly what's going on because they did later on, like towards the middle of the film and kind of towards the beginning of, I guess, the third act. But there was a large portion of the film towards the beginning and kind of the middle to where I was kind of lost as far as the whole geography of where everything was, how large the beach was.  So, I mean, of course, you're not going to hire 400,000 extras. But at the same time, you know, sometime when this party was over here and this party was over here and over here and over here, it was just kind of scattered and I did not really know the objective other than, you know, people are trying to get rescued off the beach. I mean, where are the allies coming from the rescuers and where are they trying to take them? That really wasn't clear early on to me and that was a little bit frustrating. Also, with the dogfights, some of them, you know, I believe Tom Hardy was one of the characters, but you know, some of them, when they're in the plane, they have a mask on, so early on it was kind of hard to kind of make out each one and decipher who is who because all you can see are the eyes, but you know, that wasn't a problem, you know, later on in the film. Any other gripes that I have besides the G, I mean, other than the, you know, not having the, well, and I said it because at one part in the film towards the beginning they had some subtitles and they would show like a boat and they would say like one day and they would show like a plane that would show like one hour. So I was assuming that that is the ETA of those vehicles and how long it will be before they can get to Dunkirk, but they didn't line up with the timeline. So sometimes the passage of time was a little sloppy as well, but you know, overall, I really did enjoy the movie. It was intense. The IMAX scenes were great. I really, which was pretty much the whole movie. It looked great. Even scenes where they're just sitting on the beast look great. IMAX look great. The dog fights look great. Seeing the soldiers just trying to survive and make it and get home, that was great.  You know, I liked all that and some of them just made some horrible decisions, but you can't blame them given their situation. And yes, this is a true story, but I do like the way that Christopher Nolan wrote and directed the actors to convey that point. So great IMAX, great characters, great intensity, great score. It was a little sloppy with the geography at times and the dialogue was a little bit hard to make out of time. But overall, I really did enjoy the film. If I had to rate this out of a one out of 10, I would give it an 8.5 out of 10. Yes, an 8.5 out of 10. But guys, that is just my opinion. What did you think of the new Dunkirk movie? Have you seen it? Do you want to see it? Have I turned you on? Have I turned you off? Do you groove with me or do you disagree with me? Let me know in the comment section below. Let's get this conversation going and keep it flowing. And if you liked this video, go ahead and give me a thumbs up. And if you don't like the video, that's perfectly fine. Just leave me a comment below why and still give me a thumbs up. Since you're watching this on YouTube, go ahead and subscribe to my YouTube channel so you can get all the content that I have to provide. You can just click that subscribe button and also click the bell so you can get notified when I do uploads. You can go to my website, check me out there all my written reviews and book market and also look me up on social media. Right now, guys, we're in the middle of the start of Comic Con 2017, San Diego. And I just cannot wait, especially for Saturday when we have the DC Warner Brothers and Marvel Disney panel. The most thing I'm looking forward to is Black Panther. I can't wait for that movie to come out next year. And I would love to be on the red carpet. And you can help me get in there by sharing this video 1,000 times. It's a long shot, yeah, but I'm going for it. So, because I love Black Panther. I love Marvel. I love comics. I'm a black guy. And that movie comes out in Black History Month. So, I mean, it would just be an epic dream come true for me if I can be on the red carpet or on the side with the fans, either or I would be a happy camper. But guys, I just want to thank you again for tuning in for my opinion slash review for Dunkirk by Written and Directed by Christopher Nolan. And before you go, don't forget that my name is Branky Davery. And that's just my opinion. Peace.


Well hello my friends! Today I am back with my December 2016 budget. This is the last budget of the year and I'm really excited about it. However I'm actually really nervous too because I'm gonna talk about something for 2017 while I'm doing the budget. So let's get into this. This week I might be using or not this week. Wow I'm so used to like doing a plan with me. I actually just filmed a plan with me before this. But anyway so I'm actually using a washi sample that a good friend of mine gave me. This is from Jody. She's also a YouTuber. I will put her channel below if you'd like to subscribe to her which you totally should. She does plan with me and other really fun other videos that are kind of stationary related. Also like organizing tips things like that. So definitely she is if you like me you'll probably like her. Okay so we actually went out to dinner not that long ago and she gave me this washi which I thought was super cute and like perfect for December. So I wanted to use some of it on the top here.  You know what I like literally this just sits open like this during the month and I just make sure that I'm on track. So the cool thing is is that I want to look at it and I want it to be pretty. You know I don't know about you guys but I really like it when things are pretty. Maybe I'm crazy I don't really know. But I like the way it looks and you know if this is what gets me organized and like on the ball about things then like woohoo go me. So yeah but I'm just gonna write in on here December and oh by the way this is the Aaron Kondren always a reason and season to celebrate this is the monthly collection designer sticker books. I will be putting a link below to the Aaron Kondren site. I have a unique clickable link where if it's your first time purchasing anything through Aaron Kondren well that's not straight. What happens is you sign up under that link they will send you a unique coupon code to your email and then you use that coupon code and then when you get ten dollars off and then I'll get ten dollars towards my next purchase too which is really cool and this is a notebook. This is the take note college ruled notebook I'll put a description of what this is below as well. So yeah it's got like this page on this side this page on the other that makes sense. Okay all right got that out of the way. I'll be leaving links below that's all you need to know. All right so moving on let's get into the paydays. So let me actually grab my planner because I'm not sure how many Fridays there are in December. I've got a look because you know I got a look. There's actually five Fridays in December. Okay cool. I get paid every single Friday so it's with the new job I get paid every Friday which is great. I will be taking some holiday time in December however I am going to be working the entire time I will be with my family because the new company that I'm working for is very very small kind of more like a startup kind of a thing. They do not offer vacation time yet but I will be taking the company laptop and I will be working on a massive project while I'm gone so I will be putting in my 40 hours for the week that I'm gone. I'm actually gonna be gone a little longer than a week but I'm gonna be gone what five five business days and then like I think two other business days the week after but I'll be able to make up I'll be able to just you know work those you know eight hours per day on average. I mean I'm gonna work on the weekends and stuff too and just just get my time in if that makes sense. So I'm still gonna be getting paid so that's good because I just really don't want to go without a paycheck because I kind of bust my budget and my savings goals and all of that so I want to make sure that everything is going okay. So with that being said I'm gonna get a little bit more real on how much I make and this is the scary thing for me but next year like in a month my next budget plan with me is going to possibly be I haven't 100% decided yet but since I'm doing a whole new thing where this is kind of just a general budget I'm gonna be putting in like exact amounts of every single thing throughout the month and it makes me really nervous to actually write down like how much I get paid per week or per month or whatever but you know what you guys have been so supportive and I think it's not gonna be a problem because the thing is I'm gonna be using that notebook my next notebook for actual numbers and goals so I want to make sure that I don't want to do one for YouTube and one for my personal does that make sense like that it just seems so cumbersome and I don't want to do that and I feel like you know we've all kind of built this little community here where everyone's very supportive I don't really get that much negative feedback I do once in a while but then I just like block them and whatever it's usually like spammers like people trying to like sell whatever they've got or just if you have constructive criticism like I'm totally down like totally down for that but when someone just says like I don't like your videos well then why did you even watch it that's just like silliness I don't understand why did you waste your time but those are just internet trolls and whatever but the core my core audience of people that actually click on these videos or are interested in budgeting are pretty open to whether you make a hundred dollars a week or whether you make a hundred thousand a week it doesn't matter it's all about just budgeting so you know everyone's pretty open so far if that sometimes changes I may not do these videos or do some of it I don't know we'll figure that out in 2017 but I'm going to use exact numbers in 2017 is my plan however it makes me really nervous so that being said let's get into like my pay stuff whatever alright I'm still gonna use round numbers for this video just a disclaimer but I'm gonna get a little bit more real on how much I do make my last plan with me video I was not sure how much I was gonna make because of taxes the taxes in North Dakota and Minnesota are completely different and I forgot that when I actually filmed my last video so that being said with all the health insurance and deductions and stuff it's way less than what I had stated in my last video because I wasn't sure I just I wasn't 100% sure so let's get on with it I'm I'm so over me like just talking about stuff and let's just put some stuff down okay so paycheck number one we've got five paychecks this month which is actually kind of cool especially since it's December you know oh my gosh did you see what I just did paycheck number five this is what happens when I like want to talk but then I need to write some things like I can't write and talk at the same time like forming full sentences doesn't work for my brain okay so let me see here so with deductions and taxes what was it around I think it was around like the 700 mark so we're just gonna write 700 bucks and I am hourly I'm not salaried yet I probably will be salaried in the future it's just not right now so and even if I am just salaried it it'll be fine because it's gonna be the same amount anyway so interestingly enough last week I was supposed to be not last week I keep saying last week and I'm sorry last month I was supposed to be seeing an insurance refund well that never happened and also they billed me for this month too and I'm filming in the month of November right now so they owe me some moneys let me actually figure out how much they owe me because they're supposed to be sending me a check all right so they owe me $219.36 so I'm gonna put that in there $219.36 what happened was I think I explained this in my last video I can't remember but I moved and I notified my old insurance company that I would be moving but I didn't want to cancel my insurance yet because I wanted to get covered in the state of Minnesota got covered in the state of Minnesota they sent over the paperwork to cancel my old insurance they obviously didn't get the message even though I had called them and I said hey I have new insurance now they were like great we'll get it cancelled we'll refund you the 109.68 that they had already charged me and then I never saw anything and then on the 15th which it comes out on the 15th I got charged again another 109.68 so I was like okay this is not working out and then the next day I got charged my new insurance so I've been like doubly insured for two months and it's been like okay you guys are messing my budget up stop it don't you watch my videos um so yeah so I don't really have anything else that I am planning on moneys coming in maybe some YouTube money I don't know I don't want to put it in there because I don't think I'm gonna make the threshold for not December but November like it's always like a month behind if that makes sense so I'm just gonna leave it like this and if I get more money that's great so all right so let's do my total so this is my projected incoming money for the month all right I'm gonna get more excited about this too because I'm gonna put one of these little guys in here cuz it's kind of cute and why the heck not and let's just put in some more of these because I think they're freaking cute okay so that is done-ish I guess all right so down here I am gonna put all of my bills I think Netflix changed to like $10 or something so I'm just gonna put that one in first because I'm talking about it I'm gonna say that was like 10 41 or something a month um something like that anyway give or take a couple of cents and then my cell phone has changed I got a new phone and I got a new plan as well so my cost actually went up which I know you guys have had a lot of comments about how much I pay on a cell phone but I was paying before 6255 per month and now oh you know what this month I actually don't owe anything on my cell phone because I traded in my old phone and I got like a credit of like $175 or something like that so actually for my cell phone I don't owe anything so that's kind of cool all right I won't even talk about the cell phone then yay but yeah anyway it's more than $62 now it's fine I'm fine with it yeah all right but I don't owe anything because I traded in the phone for a credit and that's showing up on the bill my Wi-Fi my insurance is 104 17 my actual insurance not my other insurance that I wasn't supposed to be paying but whatever all right so let's actually I need to look up how much my Wi-Fi is because I always forget how much it is every month and yeah all right let's look it up $45 and 29 cents okay got it $45 and 29 cents is the Wi-Fi all right cool that is all I have for my like fixed expenses I don't have a credit card payment or anything like that this month I also did all of my gifting this past month in November so I have all the gifts that I wanted to buy I've already purchased so there were some good deals and I actually got the list of a couple of people that I needed to buy for mostly kids so with that being said I don't really have much else that I need to put in the like you know kind of standard deductions so let me put in like my cash of what I'm planning on spending and we'll go from there all right I'm gonna use this little guy right here to kind of show my cash category and we're gonna do grocery dining clothes and then planning and if you guys haven't seen my new updated cash clip system I will leave that video down below you guys have seemed to really really like it because it has gotten a lot of views and a lot of comments so that's great I'm glad that I'm inspiring some of you to do something a little bit different with your cash so groceries is gonna be a little bit different this month the reason why is because I'm gonna be gone for I believe it's 11 total days so that is like grocery money that I don't need to put into here I'm gonna be staying with my parents so they will be you know providing the groceries if you will I mean I might pay for some stuff while I'm there but I'm gonna make my grocery budget a little bit smaller I usually do about $200 per month for groceries and that's just all food stuff with groceries I don't actually put in like laundry soap paper towels shampoo like those kinds of things because I don't tend to overspend in that category but I do overspend on food food if I am not you know budgeting for it so I need to kind of like restrict myself a little bit but it also gives me permission to spend whatever money I have in the clip for that month for my grocery budget I think I'm gonna just do like 140 that just seems like a good number just because I'm gonna be gone so many days and then for dining I'm gonna maybe bump that up a little bit I might do like let's do like 70 no let's do like $80 because I'm gonna have some airport things so you know as for clothing let's go with like another nice even round number of like 60 bucks for planning let's do like 20 all right that looks good so let me calculate the cash that should be like a hashtag like calculate the cash it sounds very fancy but it's like it's not fancy it's just math all right so cash total 300 bucks and also in the month of December actually end of November I budgeted for this as well but I'm gonna be starting to invest in November it's still November right now I know it's confusing as I'm talking about this because I'm doing December's budget but in December I'm also gonna be doing some investing too as well as paying my investment advisor I don't know how much he charges because we haven't really talked about it yet but that's gonna be part of the excess I would normally put it right here but I don't know how much I'm going to be investing in the month of December we've talked about some things and I'm pretty sure that we're gonna be doing around like the 200 mark per month in a mutual fund but I'm not a hundred percent sure yet because we're having another meeting this upcoming Monday so when you see this video the next Monday we're gonna have another meeting and we're gonna talk about it and anyway way too much information and I apologize this video is gonna be really long and really blabby so I I'm sorry oh my goodness I'm sorry all right so I feel like I should have like way more stuff in here but I don't oh also my Cobra is not gone anymore but I am covered for the month of December my new employer is gonna be ensuring as of January 1 so I have to have my payment in before the month happens if that makes sense so in the month of December I don't have a technical insurance payment because I already prepaid it last month does that make sense I hope it does so that's the biggest bill that I actually have in my budget at all so yeah but that that's going away and that's gonna be a part of the deduction that's taken out of this in the month of January starting the first so I won't actually know what my pay is going to be until January 1 when we start getting that you know deducted per paycheck let's get this totaled up and let's close out this video because I am in a really blabby mood and I am sorry oh you know what I didn't put in wow I am such an idiot I didn't put in like gas like fuel for my vehicle which is like extremely stupid of me how about let's put in gas because I'm like wait a minute it does not cost just that much to live that's insane all right so I am generally filling up about every third day three or four days and because I live so far away from where I work but it's totally worth it because I like as you can see I don't have like a traditional rent payment so that being said let's do like an average I think it's around like 20 bucks to fill up and if we do it times well my car is gonna be here for a little while so I have to factor that in a little bit let's do like 20 times 7 because that will give me like seven fill up and I think that I'm calculating right I think that'll do it maybe maybe not let's do like eight fill ups that makes sense okay so we'll do like a hundred and sixty dollars the only reason I'm going a little bit shy on this is just because I'm gonna be gone for a full week and the beginning of another week so I won't be using any gasoline at all so my car is just gonna be sitting here which will actually be kind of nice all right let's get back into the party here all right so 45 29 okay no I don't want that wow it's still like so inexpensive budget looks so weird you guys I know some of you are looking at this and going oh my god she makes so much money in her life costs so little and I totally get it I totally get it you should watch some of my old videos where my life costs a whole lot more but I am in a mode for saving right now and I'm saving for a house so yeah that's happening so I am living at my parents summer home temporarily because they're not here and you know it's fine I do live a little farther away so I pay more in gas and like maintenance on my vehicle but I think that it's a really good thing because I've been on my own before and it's fine and I'm technically on my own right now but I'm not paying any of the incoming bills besides the Wi-Fi that's probably gonna change when I see my parents in December when I'm gonna go to Florida and I currently live in Minnesota I'm gonna talk to them about that and say hey can I just pay for some of the other bills that come in here but this place is bought and paid for so there's no like traditional mortgage I don't I don't know what they want to do so anyway I want to talk to them about that they might just say no we don't want you pay anything we just want you to save for your house and that's good or they might say yeah we want to charge you for everything I don't know we haven't really had that conversation so talk to my mom a little bit about it but I want to include my dad in the conversation too because he might have his own opinions and I really like to get their feedback so anyway so now I'm gonna take this number minus these numbers and then we will get a total that's my total of excess for the month so alright so anything above and beyond that if I do get YouTube money which would be fantastic but I'm not really you know banking on it anything above and beyond that is gonna go all into my savings anyways because like I said I am saving for a house so that is kind of like consumed my life honestly and also with some of my investing that I want to be doing that is gonna be incorporated into this budget at some point probably in January because that's gonna be more on a set schedule once I get that figured out then I'll be able to like kind of work that in so yeah but anyway I'm gonna close out the video now I hope you guys enjoyed a look in a peek into my finances January 1 everything is kind of changing and we're getting a little bit more real on to how much money I actually do make so anyway that being said if you like these videos and make sure to give it a thumbs up let's me know that you want to see more budget videos from me I also have lots of other plans for 2017 I really hope that you guys stick around so make sure to subscribe so you don't miss out on any of my content I do post every Monday Wednesday and Friday for you guys so I'm gonna let you guys go for now thank you so much for hanging out with me for a part of your day I hope you're all having a wonderful day and I will talk to you all in my next video bye guys


For this example, we're going to be building a function that takes an array, and we'll just walk down the array and square every element in it. I've got a test suite here that will help check to make sure I've built my code correctly, and now I just need to add in the function. So in this case, the first element in my array is always going to be the length of the array. So I'm just going to go get that and stick that in a register. As my parameter will always come in in $A0, I'm just going to go get the first element out of the data structure. Now I want to go through and iterate over every element in this array. We have t0 number of elements, and I want to apply a squaring function to each of those elements individually. So I'm going to be building a for loop for this. So I will initialize a counter, and my loop is going to run until my counter is at least as large as the length of my array. So I've got some loop that says for i equals zero, i less than n.  Once the loop is done, I need to make sure that my results are in register v0, and then I can just go back to the calling function. So now all I need to do is go through and fill in all of the information about how I'm actually going to go find pieces of data in this array, pull them out of memory, manipulate them, and then put them back into memory. So I have a base address, which is in a0, and I have a counter in t1. Now since all of the elements in my array are word-sized, or integers, that means they're all four bytes large. So since MIPS is a byte-addressed architecture, I'm going to need to convert that number of integers into bytes instead. So if I multiply my index by four, I will get the number of bytes that this element is from the beginning of the array. Since the first element in my data structure is actually the length of the array, I'm going to want to skip over that and get to the actual data. So I'm just going to skip over one integer. So now t2 will have the offset from the actual beginning of my array data structure. So this will tell me exactly where my piece of data is relative to the beginning of my array. Now if I add that offset to the address of my array, that will tell me where this piece of data is in all of memory. So I'm adding my offset t2 to my base address a0, and that will give me the address of my piece of data. Now that I know where my data is, I can go fetch it out of memory. I can square it, and then I can store it back into memory at the same place. So this should be all I need to do to get my program to actually square every element in this array. So if I go over to QTSPim and I run this, it shows me that all four of my tests pass. They walked over all the elements in my array and squared each one. So I started with an array that had say four, one, three, five, seven. It uses the four as the length of the array, reads one, stores back square of one, which is one, reads three, stores back nine, reads five, stores back 27, reads seven, stores back 49. And the majority of the interesting code is happening inside this loop. I'm taking my counter, I'm multiplying it by four, I'm skipping over four bytes so that I don't grab the length field, and then I add my offset to my base address. Then I can go load that data, square it, and store it back. I can make this a little simpler by using some alternative instructions. So instead of doing the multiplication, I could have used a shift left logical instruction. I can skip the instruction to actually add four, skipping the length field, because I can stick that constant four into my load word instruction in a moment. So there's my four byte offset to skip over the length field, and I'll use it again in the store word. So I've replaced the seven lines that I had before with just five. If I run this, it still works. I've used the shift left logical instruction to replace all of the instructions involved with actual multiplication. I just used a constant four in my load word and store word instructions instead of having to actually add four to my offset. So that meant that I ended up with some code that was slightly shorter, but did the same thing.


Everybody forced here ripping 2022 triple threads baseball hobby nine box case number 19 pick your team style Let's read off the names and teams here Adam H. Royals Alex F D-backs reds twins and Giants Andrew P. Brewer's Brad D Brad W. Padres Brad D. Guardians Brian B. Phillies Chris D. Mariners Kristen s a's David L. Blue Jays D&E Tigers Eric S. Metz James G. Red Sox Johan with the Rays Joshua J. Orioles and Marlins Kurt W. Cubs Kyle T. White Sox Pirates Mike a Braves Mike B. Rockies Peter M Yankees Ryan B. Nationals Ryan G. Astros Steve H. Cardinals Big swick Dodgers Thomas J. Angels and Virgil with the Rangers. Good luck All right guys gonna skip the recap on this because we are behind so we got to catch up Bobby Whit rookie base Got to 50 Corbin Burns Brewers and to 259 Salvador Perez Royals Yankees triple or Dodgers triple relics. Sorry trade Turner game used four of nine scoring from first and Orioles are the first auto here Jersey auto Cedric Mullins numbered 45 out of 99. Oh, sorry. I was doing something. I saw the question a favorite product to rip Triple threads is really up there For baseball this year was definitive and the war basketball. I like a lot To 299 Jose Ramirez Guardians to 150 Tom see for Mets Anything tops chrome I like Wow, what is that? Cardinals Triple threads Deca autographed relic combo book card redemption Yachty Molina Nolan Aronato Lou Brock Orlando Sepeta Paul Goldschmidt mark mark McGuire Albert Pujols Scott Roland Ozzie Smith and Bruce Sutter Monster card for the cardinals and Jersey card Giants Joey Bart four of nine player worn Jersey card That will be awesome to get that everybody's hate on that card Well, you know what Steve H of the Cardinals that card's gonna be freaking awesome So 50 Reggie Jackson A's and a 259. Jose Ramirez Guardians. What a toke rookie triple Jersey auto Cardinals large new bar 26 of 75 Carlos having a pretty solid break. I'd say What's up slim Jim and And a player warned Jersey for do go to 48 Red Sox.  We've got Eloy to 299 white socks and a 125 rookie wonder You go raise a number there Trade Turner again game use triple relic seven of 27 27 and 26 streaks And a Phillies rookie auto Bryson Stott 48 of 199 there you go fills Yeah, Matt would love that card. I think Sam pulled one of those on our release day, right? Like a gold one I'm and bangles are bangles. I don't think the Bengals are losing this game The Bucks have zero momentum to 299 Mani Ramirez Red Sox and a 125 Salvador Perez Royals Buster Posey Southpaw or super versus Southpaw's 4 of 36 triple relic giants and pirates rookie auto here Rwanzi Contreras number 19 of 25 Let's get it started. Oh my god. Let's let's not do this right now I mean, I'd be down with our mix in touchdown, but the idiot bangles like to give it a some IJP right a bunch 259 Greg Maddox Braves and a 299 honest Wagner pirates Blue jays with a really nice Beshet blast triple relic Dicot auto numbered 6 of 18 nice card blue jays and a crone zone jersey for the Padres 18 of 36 player worn Yeah, so today was legit It's becoming one of my favorite sports for sure to 299 Elohim and as White Sox the 125 carbkins jr. Orioles God rookie triple relic auto Aaron Ashby 24 25 Brewers Nice patch card there on the nice pass in the bottom and Jersey Elohim and as White Sox player worn 14 out of 36 Abrams rookie to 99 Louise Robert White Sox and wandered at 290 259 here for the raise 307 average triple relic Hosea al-Tube a 10 of 36 like how this is like a darker piece of lots of dirty Jersey actually That was bad for a second. That's a dirty Jersey It's even cooler Stroze on that one and jumbo Jersey auto Kirolof for the twins 49 of 75 Tyler Boyd touchdown The bucks are gone Jake Keep scoring yeah at a 75 Joey Vado Reds and a 259 Xander Bogart's Red Sox Triple Jersey auto Ian Anderson numbered 64 of 99 braves and jumbo Jersey Brewers Christian Yelich 1 of 27 to 299 a Robin you out for the Brewers and a 150 Machado Padres Phillies triple relic Ryan Howard Chase Utley and Bryce Harper nice game use trio there 7 of 36 Phillies. I Like to have a cash for Chase Utley and a Jersey auto Phillies JT realm Utah with 75 a 75 nice mini box for the Phillies They're done six Getting the forest done stamp of approval right there Well done burnt to a crisp. They're getting cooked I'm obviously just the game isn't literally not over It's the third quarter. I'm on the internet. So I got to talk like I'm on the internet Make everything about absolutes I had a 199 Devers Red Sox and a 259 McGuire a's Mookie Run in 15 triple relic 14 of 27 Dodgers game used Full kit a 54 yarder. Let's go Pat's offense. We got raise redemption rookie auto amethyst parallel Wanda Franco Congrats to the raise Good stuff there Two big redemptions in the break so far see what else we got here Abrams the 150 rookie for the Nats and a 199 Ozzy Smith Cardinals There he is Rafi Devers triple relic auto 14 of 27 Red Sox 200 hits by 23 and Jumbo Jersey Dodgers Clayton Kershaw for 48 He would think that Harrison but could be a good fantasy kicker. He really is not though like it's pretty frustrating That's a nice color comment It's a red one-of-one Mike Piazza base parallel for the Mets He's a Ninja Turtles We will get that mag for your Mets one-of-one a red Jacketed 259 Dodgers Triple Jersey auto Red Sox Bobby Dahlbeck number 21 out of 50 and Jumbo Batrell like twins Gary Sanchez 27 to 36 isn't Sanchez still available. Who's gonna sign Gary Sanchez? It's gonna be a ray. No I think the rays value defense too much Happy at all. I think the rays value defense. So I don't think it's gonna happen who your Rodriguez He's basically just a DH, right? Pretty much that hits like 220 It's a 1.99 show. Hey, Ohtani angels into 25 Johnny Bench Reds Triple relic your don Alvarez 300 games 84 homers 11 to 27 For the Stroze pizza one-one, baby And jumbo Jersey auto blue jays to yosca Hernandez 74 of 99 He's a red star. I agree with that illegal I'm gonna have to look elsewhere if I win my fantasy matchup this week. I can't I can't deal with these like Four-point performances from from my kicker in fantasy and the playoffs. I gotta I gotta you know I gotta get like seven or eight at least But but that's the thing about fantasy games as soon as I drop Harrison but for as soon as I do that He's he's kicking five field goals next game making them all It'll be like in a Caddy shack where it's like to get the guy plays like always the greatest game ever played It's like storming out and the wind just like blows the ball into the hole. That's what's gonna happen with butker Jacketed two 99 Dodgers and a 150 Ricky Henderson a's Another turnover Jake just do not look at the bro Tim Reigns that's pretty cool white socks triple relic auto 12 out of eight out of 18 lead-off lumber You go white socks nice Tim Reigns day 18, I don't think I don't think I'm on a delay here, too I think I just didn't I hadn't seen it yet Jersey judge to 48 Yankees. It's not watching the TV necessarily Yeah, the Denver Stewards kicker. I want Nick folk is a good one. Jake can tell you that Yes, sir Best fantasy kicker out there. They don't always get to the end of the field when they do They sure as hell ain't squaring a touchdown To 299 Max Jersey Mets in a 150 on a swagger pirates That's a nice Bryce Grand in the clutch triple relic seven of nine for the Phillies and that is pretty damn sure he was huge for them in the playoffs. Oh Murphy bunting just he should have had that pic. Oh man Wow, and that relic auto a Henio Suarez is a Mariner 10 to 50 Yeah, Dak pick six and OT Let's go Pat's let's get this dub Seven and six can't tank it out. You've got to keep trying to win Can't tank now You think Bill's just trying to win so we can finish the better record than Tom and like rubber in space That's probably the only reason they're trying to win So 99 Bregman for the ash shows in the 259 Ernie Banks Cubs Triple Jersey Cody Bellinger 12 out of 36 Dodgers and jumbo Jersey auto a Sean Murphy 70 of 75 Yeah, Jamar Chase is good at football. I Can confirm and I don't even play football It's 150 Bo Jackson Royals to 199 Giancarlo Stan Yankees white whale Printing plate triple relic auto Cubs Ryan Sandberg Two-spot pioneer There we go cubbies that's a nice one to that pass in the left isn't really sick White whale Cubs Ryan Sandberg Game used men we'll get that magged and jumbo Jersey de Jola Mayhew Yankees to 48 And that will do it. Thanks again everybody again not gonna recap because we were short on time because uh Behind thanks again everybody we've got another PYT coming up


Hi everyone, Joe for Jaspie's recap video for a Tops Chrome Baseball Mixer. Two boxes of 2023 Jumbo, two boxes of 2022 Tops Chrome Sapphire, and a box of Ben Baller to make four. On a Sunday on Fanatics Live, the six, thanks everybody for getting in and making this happen. Streaming live on Fanatics Live seven nights a week, so check us out. This was the break, we got a nice die cut, Julio Rodriguez die cut, Bobby Wood Jr. rookie cards, nice Corbin Carroll, the Vulpie prism, or Carroll base, some good color, nice rookie Josiah Gray, the Adley Rushman, Yoshida, and a Michael Harris right there as well. Nice quick little four box mixer. I'm Joe, I'll see you for the next one on Fanatics Live.


What's going on everybody? Welcome back to another SQL tutorial. Today we are going to be talking about sub queries. Now sub queries are often called inner queries or nested queries and they're basically a query within a query. A sub query is used to return data that will be used in the main query or the outer query as a condition to specify the data that we want retrieved. You can use sub queries almost anywhere. You can use it in the select part of a query, the from the where. You can also use it in insert update and delete statements. But in today's tutorial we're only going to be looking at the select the from and the where statements and you should get a pretty good idea of how to use it in those other statements. All right now I'm going to paste on screen basically what we're going to be walking through today but really quick let's just take a look at the table that we're actually going to be working in and that is going to be from the employee salary table and I just want to show you the data that we're going to be working with before we actually get into it. So we have an employee ID, we have a job title and then we have a salary. So really quick I'm going to show you what it looks like to have a subquery in the select statement. So let's go down here really quick and what we're going to try to do is kind of do something like a windows function but without actually having to do the windows function and so we're going to do this with a subquery. So I'm going to select and really quick actually let me copy this. So we're going to do employee ID, here we go, we're going to do salary and now we can start building our subquery. So we need to do an open parentheses and I'm just going to copy this really quick because we're going to be doing it off of that table. So we're going to say select and then I'll paste that and close it as well but what we want to do is we want to say average and salary. Now what this is going to do is it is literally going to run this and let's run this really quick. It is going to run this and it's going to show that the average salary for all the employees is $47,909. So we are looking at the average salary for every employee. So when we run this is going to give us the employee ID, the salary and then in the very last one is going to show the average salary for every employee. Now it doesn't have a column header so or column name so let's give it let's say as all average salary and we'll run that one more time just to make it a little prettier. You can also do this in partition by I'm going to super quickly just really quickly write this out it should take no time at all and then I'm going to show you why we can't do this without the subquery why you aren't able to do this with a group by. So really quickly let me copy this I'm going to put it right down here and we're going to say average salary whoops and we can get rid of all this and we can say over and we're not going to partition it by anything but let's run both these at the same time you'll see that they're the exact same outputs and so it's just a different way of doing it in this example but it really is just to show a comparison of how you might be able to use a subquery in the select statement. Now you might be wondering why group by does not work for this really quickly I'm going to write this out and let's get rid of that and we'll say group by whoops let me at least try to write it correctly group by and we'll do employee ID and we also have to do salary and then we'll say order by one two so let's run this and as you can see since we have to use the group by groups by both the ordered ID and the salary and so we're not going to be able to get that all average salary that we're looking for that we can get in the partition by and also the subquery in the select statement. Now I'm going to show you the subquery in the from statement so let's just get rid of that really quick and let's say select everything let's say from and we're going to do an open parentheses here and here is where we're going to write our subquery so if you have watched previous videos where I've done tutorials on the CTE or tutorial on the temp tables this is one that is very much like those except I think a little bit less efficient when I'm doing something where I'm creating a table and then querying off of it which is what we're about to do I much prefer a CTE or a temp table subqueries tend to be a little bit slow compared to a temp table or a CTE I tend to use temp tables a lot more because you can reuse them over and over whereas a subquery you cannot you have to write it out each time so really quickly I'm going to show you how it's done although I don't really recommend using this method really quickly let's go up here and let's steal this partition by really quick this will be our subquery and let's paste this in here make this look a little nicer so you can visualize it a little bit easier so really quick what this is going to do is it is first going to run this and create this table again much like a temp table or a CTE so let's execute this really quick it's going to create this table and then it's going to allow us to query off of it so I can actually say and let me give kind of an alias to this a dot employee ID and then let's say all average salary so now I can take columns from this inner query if I want to and just select those or I can select everything and return that entire table again I much prefer a temp table or a CTE for this type of situation but as an example I just wanted to show you how it works now let's go down to the subquery in the where statement but really quick I just want to steal this query so I don't have to rewrite everything and let's get rid of this really quick and add back the job title all right let's look at this really quick so we have our table that we've been using our employee ID job title salary so for this example we only want to return employees if they're over the age of 30 and as you can see in this table there is no age column that is in the employee demographics table now if we wanted we could join to that table and get that information or we could use a subquery and so for this example we are going to be using a subquery so let's go right down here and say where employee ID is in and we'll do an open parentheses and now this is where we are going to build out the subquery so just for visual purposes I'm going to go right here I'm going to say select everything and we'll do from employee demographics and close the parentheses so we're going to try to select something in this subquery that will then identify the employee IDs that are over the age of 30 so really quickly let's take a look at this table so right now we have the entire table selected so we have the employee ID first name last name age and gender so in this subquery the only thing that should be returned is the employee ID and in fact in your subquery you can only have one column selected so I can't select everything I have to specify one column and that's a little bit different than how we did it in this from statement where we were basically able to select the entire table and then in the select statement specify what columns we wanted anywhere statement we can't do that so we want to return the employee ID and we also want to say where the age is greater than 30 so let's run this really quick and see if it works as you can see in the results these are the employees who are over the age of 30 now if you wanted to display the age as a column in this output you would have to join to that table and then put that column or that field in the select statement but in a lot of situations you won't actually want or need to do that and so a subquery can be a really good option in these scenarios with that being said this is the last video in the advanced sequel tutorials I hope that this series has been helpful and that you learned something along the way thank you so much for joining me I really appreciate it if you like this video be sure to like and subscribe below and I'll see you in the next video