Hey beauties, I'm Bianca Renee and you're watching Bianca Renee Today and today I'm going to take you through the ultimate beauty spa at home mask day.  If that's you and you know you committed to the challenge, go ahead leave me a comment so I can give you some props. But the main thing or my main tip that I can give you guys while deep conditioning is to also do a face mask.  Am I right? So today I'm going to show you some new products that I've incorporated into my mask today. Starting with my face, I have some new Glam Glow Mask. If you guys follow me on Instagram or Snapchat, if not go ahead and do that right now. But I always have on a Glam Glow Mask like probably 90% of the time. A lot of you have seen me use the Glam Glow Super Mud Mask. I have a full video on that one as well which is really good for acne. But another one I like to use is this orange box right here which is their Flash Mud Mask. First of all, Glam Glow always wins for the cutest packaging. Look at this little, what shape is this? How many sides? I don't know, but it's a cool looking shape, right? So then you open the box, let me do a little unboxing for you. Hello sexy, see it just compliments you as soon as you open the box, right? So you're like, hello, how are you? And then you open it and then you see the cute little bottle nestled on the inside. The actual packaging itself is also really cute and sleek. This is 1.7 ounces or 50 grams of product and this is their new price point. So now this one is $59 which is definitely reduced. I want to say the old price was like 69 but they did lower the price and they gave us 50 grams of product which is pretty awesome. So not only do they have a new price for their original one, they also have a new mega size and in the mega size it actually has this cute little squeeze bottle. I think I prefer looks just like this and this one is 3.5 ounces which is 100 grams of product and this one also has this cute little brush double-sided Glam Glow brush which is so cute. So there's a little side-by-side comparison of the two options as the 50 grams for $59 or 100 grams for $79. I believe there's also a little cute little baby one which is their travel size for 24 if you want to give it a try before committing to the mega size. So let's go ahead and get started with our mask day starting with my face. The interesting thing about the flash mud mask is that it's a little bit different than your average mask because you're actually starting on a dry face. So you're going to apply some of the product using your brush putting it on your face and then you're going to scrub it into your skin while it's dry to really get a good exfoliating start. The flash mud is known to be a brightening treatment so as you can see I have a lot of dark scars so this is going to help with my acne scars and brighten my face giving me a more even skin tone. The flash mud is also a good mask if you do have acne because it has salicylic acid, lactic acid and real diamonds.  The great thing about glam glow masks is they use a teoxy technology and in the flash mud they use a white birch leaf. The white birch leaf is going to help create an improved color balance skin tone. So when applying this mask you're going to apply it on your dry skin and rub it in circular motions to pre-exfoliate your skin. This is going to help all the ingredients absorb into the skin. They're going to leave it on for 20 minutes and it's going to turn into a semi-transparent look. When first trying out this mask it is recommended to do it three days in a row and then after that you could do it two to three times a week. Now while our face is getting all pampered and beautified let's go ahead and move on to our hair. The mask I'm going to be using today is by Maui Moisture. This is Maui Moisture's Heal and Hydrate Shade Butter Hair Mask for Dry Damaged Hair. Now I have already done a full video on this if you guys want to watch my full Maui Moisture review I'll put the video right here and below so you can check that out but I wanted to kind of bounce out your checkbook today by doing a high-end face mask and then using a drugstore hair mask. You can obviously use any hair mask you want just make sure that it is silicone-free. The Maui Moisture one has no silicones, no parabens, no gluten, it's vegan, eco-friendly, pure coconut water, pure aloe juice. So this has really good ingredients that's going to really help moisturize your hair. When applying a deep conditioner it can replace your normal conditioner or if your hair really needs some extra moisture you could do a deep conditioning treatment after your shampoo and conditioner do it works best for you.  So to get the best results you want to get a very good amount you know don't be skimpy on your deep conditioners and really saturate each curl and smooth the product into the cuticle. You want to make sure that every curl is getting some love and so really glop it on there. Once you finish applying the product to both sides of your head we're going to wrap it up put on a shower cap and let it sit for 20 minutes. I actually like to take my deep conditioning to the next level by using a heat cap this is by thermal hair care and this heat cap is something that you put in the microwave it heats up and it helps open up all the hair shops so that moisture could really get in there. I also have a full video on this heat cap so I will put that right around here and below as well. My moisture is sold pretty much everywhere I've seen it at every drugstore, Walmart, Target, it's pretty easy to find and it's always around $9. After our 20 minutes is up we're gonna hop back in the shower and rinse it all out.  And hey since we're pampering ourselves today let's go ahead and give some love into our body. Introducing the plush body 24 karat gold coffee body scrub. Yes I said 24 karat gold 24 karat 24 karat magic in the I'm not gonna sing for you guys you guys get the point. But yes Bruno Mars should be using this body scrub because it actually has gold inside. Dang this is a bougie wash day we have diamonds on our face gold on our skin like we are just flossing. So this body scrub right here is amazing.  For those of you that like gold any gold lovers yeah gold diggers uh gotcha. Anyone bad and bougie yeah you're definitely gonna love this. So this body scrub is literally grounded coffee and gold okay all mixed together it also has purified water coconut fruit coconut essential oil jojoba essential oil sea salt ground sugar vitamin e oil 24 karat active gold wow those are some amazing ingredients to be rubbing all over our body it's also 100 vegan cruelty free all natural non-gmo and it's made in LA can we talk about this cute packaging it's so like luxurious it's basically like a really fancy ziplock bag on the bag it says you are gold baby solid gold apparently I just like to buy products that compliment me it's best to use this two to four times a week definitely works best in the shower while your skin is wet and you're just going to gently scrub over your body then rinse it all off and enjoy your beautiful shimmer yes when you get out the shower you will actually see gold shimmer all over your skin so it gives you a beautiful golden glow and when that light hits you girl let me just say you will be shining shining shining shining shining yeah do you see that shimmer that isn't even like with lotion this is just straight out the shower because of our body scrub so pretty I cannot wait until spikini season and I have this all over my body in the sun so not only is caffeine good for waking up your mind it's also going to wake up your skin the coffee beans are going to exfoliate the skin and the coconut oil is going to moisturize the skin if you are a coffee lover no a coffee lover know someone that's bad and bougie someone that likes the best of the best high-end body scrubs to leave you glowing you gotta get the cocoa and gold plush body body scrub this bag has 200 grams of product in it you can get at plush body comm also follow them at plush body of course I have a promo code for you guys you get 15% off when you use code beyond grenade so glam glow is going to have my face look and luminous bright get rid of my acne and scars then I'm going to use my mali moisture mask to add some moisture to my dry curls so they stay popping and then I'm going to scrub down with some 24 karat gold so I stay glistening if you enjoyed this video hope you gave me a thumbs up and subscribe let me know what product you found most interesting which one you have which one you want to try and make sure we stay like best friends follow me on everything twitter instagram and snapchat at miss beyond grenade and hit that subscribe button because I post two new videos every week let me know if you guys want me to do more mask videos like maybe I can start doing mask mondays facial fridays I don't know you guys let me know in the comments below I'll see you guys next time thanks for watching beyond grenade today


on using GitOps to increase system resiliency with Litmus Cures. This is Saina and I work at Harness at Senior Software Engineer and I am one of the core team member at Litmus Cures which is now a CNC incubating project and I've been contributing to it for the past, for around for two years and it has been a great journey so far. And now Amit will be introducing himself. Hey everyone, I'm Amit Kumar Das. I'm a Senior Software Engineer at Harness and I'm a core contributor to Litmus Cures and I've been contributing to the project from past two years and yeah, very excited to be a part of KCD Chennai. Yeah, that's pretty much about me looking forward to it. Thank you. Yeah, thank you Amit. So today's agenda will be, will be first of all, will be talking about Cures engineering, why is it required and then we'll be introducing Litmus Cures, talk about its core components and features. Then Amit will be taking us through the GitOps and giving us a small demo of how you can use GitOps to like leverage, like use, like increase the system resiliency using Litmus. So yeah, without further ado, let's get started. To start off with, first of all we need to know what is resilience.  So for example, let's say a pod gets evicted from the node, what is its state? Is it healthy or not? Does it bring itself back up? If it does then it is resilient and that period from going down to bringing itself back up is the resilience. So similarly is the case with node and memory leak as well. Talking about downtimes, downtimes are expensive, not just in terms of money but also they're in other aspects as well such as customer conferences, the loss of customer confidence, then damage to brand integrity, then loss of productivity and employee morale as well. So considering all these, et cetera, like these are some of the aspects and considering all these aspects, we definitely want to avoid downtimes at any cost and one way to do this is by adopting the practice of Kiosk Engineering and Kiosk Engineering is the like process of testing a distributed computing system by injecting fault intentionally. So the goal here is to identify the weaknesses in the application through control experiments so that to check whether it can withstand the unexpected situations or not. So how it is done, it is typically done by like, first of all, you have to identify the steady state conditions. So steady state conditions are the desired behavior of the application in a given scenario when it is healthy. So first of all, you identify that, then you introduce a fault in application, then you check if the steady state conditions are met or not. If yes, then the application is resilient and if not, you can go and fix it and if some similar case happens in production, you are already covered. Then are talking about the foundations of Kiosk, cloud native Kiosk Engineering and how it can practice effectively. So the cloud native definition itself includes some mandatory principles such as it requires declarative configs being scalable, flexible and support of cross cloud. So these are some of the main principles which we have been following for the past few years. And yeah, so cloud native communities and technologies revolve around open source and these Kiosk Engineering framework being open source gives them the benefit to make themselves better and add more and more features. And the Kiosk experiments need to be very simple to use highly flexible and highly tunable with very less or little or no chance of false positives or false negatives. Then with more and more people getting involved into Kiosk Engineering, more and more changes happen very frequently that with the requirements being altered. So there arises a need of like, it becomes very important for the Kiosk Engineering framework to enable proper management of the Kiosk experiment and that to in Kubernetes way. Then as you start practicing Kiosk Engineering more and more start fixing the little issues that come in more and more Kiosk scenarios come into picture and gradually it becomes very large and comprehensive. So these are Kiosk scenarios need to be automated and triggered if changes are made either in the application or in the Kiosk experiments. And tools around GitOps can are one way to achieve it. Then so this is like, this is a section we'll be talking about in detail and giving us giving you all the demo. And then lastly there's open observability which is also one of the principles. Introduction to Kiosk Engineering should not require any new observatory system. The existing ones should fit in perfectly. So yeah, that's that. Then with that I would like to introduce Litmus Kiosk which is an open source cloud native Kiosk Engineering framework with it has also, it also has the cross cloud support and currently it is CNC incubating and it has adoption across several organizations. Then talking about the features that Kiosk Center provides starting off with the Kiosk workflows. Kiosk workflows is the collection of several Kiosk experiments which can be clubbed in either a sequentially or parallelly like in any manner. And it can be created, these workflows can be created using custom templates that you can like you can upload or you can create your own custom workflows from Kiosk Hub which is the repository kind of like it is the place where all the Kiosk experiments are present you can choose from there or you can use some pre-created, pre-created elements are also there you can choose from them as well. Then you can schedule your workflows either as a recurring one the Cron workflows or you can have a singular workflow as well. Then lastly you can attach priority to each of the experiments in the particular workflow according to your own requirements. Workflow management, this is a section we're talking about a bit later. Then you can litmus allows you to add your own image from your own image server, custom image server which can be the public or private. Or then once the Kiosk injection is done you can measure and analyze the resilience score of each workflow. You can analyze how your application performed in that particular Kiosk workflow. So yeah, that's that. Then litmus also supports multi-tenancy which means you can create your own team add other invite other users to your team and like as viewer or editor permissions like it has a fine-grained role-based access controls which gives the necessary privileges to the users. Then scope support is also there I have talked about you can install it in namespace or cluster by its scope and authentication is there. You can choose to have local authentication or the OAuth one. So yeah, that's that. Then coming to monitoring and observability so you can connect your own data source and monitor the workflows or you can visualize there are graphs present where you can visualize the workflow run statistics or the schedule statistics. You can also once the workflows are running or completed execution you can compare two or more workflows how they performed and in case you do not like the interleaved dashboard that is present, you can upload your own dashboards from the available that are available in the community. You can edit them, you can tune the dashboards according to your own requirements. And lastly, you can monitor the Kiosk in real time with the interleaved events and metrics from the Prometheus data source. Then with Litmus Kiosk, you can not only target Kubernetes application but you can also target Kiosk like on infrared sources or attack bare metals or machine as well. Lastly, GitOps for Kiosk. So it basically integrates any Gitbase source control manager to provide a single source of truth provided that you have enabled GitOps. Once the GitOps is enabled, it kind of switches off MongoDB as the DB, the data source, then Git will act as a single source of truth. And this is also bidirectional nature so that means if any change occur to either all the workflows are being stored in the Git source. So if any change happened to either Kiosk center or in the Git source, both of them will automatically sync. Then it also provides even tracker as a microservice where you can launch the subscribed workflows. Like it launches the subscribed or works automatically if there's any change in the application such as upgrades or all. So it automatically launches the Kiosk workflows. So that's that. Now Amit will be talking about GitOps in more detail and we'll be giving a demo. So yeah, over to you Amit. Thank you. Thanks, Aranya. So before moving on to the demo, I'll be talking about GitOps and why do we need Kiosk engineering with GitOps? So GitOps is basically an operational framework which uses Git as a single source of truth and any change in the code or in the Git repository needs to be fully synced with the cloud infrastructure of the organization. It follows the principle of infrastructure as a code where managing and provisioning of the infrastructure is through the code rather than manual processes. Now moving on to the main question, why do we need Kiosk engineering with GitOps? So the Kiosk engineering with GitOps will enable a vast scope of automation with CI CD pipelines. So currently Kiosk engineering is being performed in a closed environment or in a pre-production stage but what if we enable Kiosk engineering in the CI CD stage? So this will actually enable the developers with the known faults before it goes to the pre-production stage. And some advantages of GitOps are increased in productivity. So developers are more focused on the development rather than the CI CD of the infrastructure and it reduces the mean time to deployment. And the second point is high reliability. So GitOps practice are considered one of the best practices because it reduces the mean time to recovery. Like if we have any fault, we can simply roll back to a previous stable version. So the third point is better security. So Git is a very secured platform or a framework because it's very strong with its cryptography and the ability to sign your changes provides the ownership to the change or to the source code. And it improves the auditing. So since GitOps uses Git, so we can keep a track on the audit logs and we can know any change which is going into the Git repository with the logs. So it increases the auditing as well. So now moving on to the demo. I have set up the Litmus Kiosk Center. Let me, yeah. So for this demo, I have installed the Kiosk Center on GKE and along with it, I'll be using two cloud native applications which are the Bank of Anthos application and an online beauty application. And so this Bank of Anthos application is actually a banking application and we can perform a lot of operations like sending a payment or depositing a payment. And similarly, this online beauty application is actually an e-commerce application. Since you can see a lot of products listed here and we have a catalog, we have functionality to change the pricing according to different currencies and we have a cart option here. So we'll be performing some Kiosk Engineering on these two microservices. And for this, I'll be using Kiosk Center and to enable the GitOps functionality of Kiosk Center, this is very simple to do. We have in the settings tab, we have a tab named as GitOps. Simply select this Git repository option and I'll be providing a Git repository. So moving here. So this is a empty repository which I've created for this demo. And to connect this Git repository, I'll use the repository link. The branch where I'll be pushing all my changes which is the main branch. And we can provide two authentication methods which are the access token and SSH. So I have my access token with me. So I'll be using it. Don't worry, I'll delete my access token later. So I'll just click connect. It will take a few seconds, yeah. So we have successfully enabled the GitOps for our project and to verify the same, we can go to the Git repository again. And if I refresh this, I should see a litmus directory being created and the directory structure shows me the project ID here. So if I see that this 205ED is actually my project ID, which is 205ED. We can also verify it from here. The project ID is even here. So we have successfully configured GitOps within our application. And now we'll start to do some chaos engineering. And let's get started with the Bank of Anthos application. So I have deployed this application along with all its services in the namespace called bank. And here we can see a lot of services like balance reader, contacts, load generator, transition history are available. And so currently, what I'll try to do is I'll try to delete this pod, the transition history pod, which actually shows me all the transition, transaction history within this application. So let's get started with it. So I'll try to schedule a workflow. I'll click on the self agent. And here we have four options to create a chaos workflow. So we have the option to run a predefined workflow or we can clone a existing chaos workflow or we can use the Git, we can use the chaos hub, which is a marketplace of all the chaos experiments. And we can also import a workflow manifest email. So for now, I'll just use the chaos hub. I'll click next and I'll provide a name here. Delete the transaction pod. So I'll click next and I will add the pod delete experiment. Pod delete, yeah, here it is. And to target the pod, I have to select the name space, which is this bank name space. And we have the transaction history label here. So I'll select this one. And for the timing, I'll not add any probes. I'll just continue to tune the experiment. Here I can provide different environment variables to my experiment. So for now, for this experiment, I'll select the total chaos duration as 60 and the chaos interval to be as 30 seconds. Yeah, now I'll finish up all my changes and I'll turn off this reward schedule, since I want to know the logs and other details of my workflow. So I'll click next and I can select the weights here of the experiment. I'll select the schedule now option and I'll verify all my changes. It's the delete transaction pod and I'll check if the labels are correct over here. So which is the bank name space and the label is transaction history. And I'll just finish my changes here. Yeah, so we can see that the workflow has started. And if I click here, I'll get a argograph which shows the live changes which are taking place in the workflow. And interestingly, if I go to my Git repository and do a refresh, I'll see that this workflow manifest is also here. So any change which is happening in this workflow will also be reflected in my Git repository as well. So let's wait for a few seconds or few minutes for the workflow to get completed. And meanwhile, we can observe the chaos which will be happening in this Bank of Anthos application. So we can see that the pod delete experiment pause had just started up. And if we go to the litmus namespace, I can confirm that the pod delete runner has just started and the transaction pod is actually terminating. So if I refresh this page, I should see that this service is under chaos and we don't have any data related to the transaction history. And once the transaction history pod is back into its running state, we should see the details over here. So let me refresh this page again. It's still under chaos. And once the workflow is finished and this service is in running state, we should get the details. So let's wait for a while. Yeah, so since we can see that the workflow has completed and the pod delete experiment has also run successfully. So we'll go back to the Bank of Anthos application and we'll just refresh. And we can see that the transaction history is now available. So to cross verify this, we can also see that the transaction history pod is now back and running. So we have induced chaos on this service, the transaction history service on Bank of Anthos application. So what if I need like currently in this manifest, we can see that the chaos duration was 60 and the chaos interval was of 30 seconds. What if I need to change these environment variables? So instead of creating a new workflow completely, what I can do is I can go to my Git repository and I can simply update these changes in my workflow manifest. So let me go here and try to change the variables of the environment variables here. I'll change it to 100 and change the chaos interval to 50 seconds. And now I'll commit these changes. Yeah, so in our Git repository, we have made the required changes and it will take a few minutes to get synced with this with the chaos center. So let's wait for a few minutes over here. So if I refresh the page and load the manifest again, I can see that previously it was 50 seconds or 60 seconds, but since I've changed the environment variables, the values can be seen here. So these are the updated values, which I provided in my Git repository. So the total chaos duration was 100 and the chaos interval was 50 and these changes are now available in my chaos center. And to run this workflow, I just have to do a quick rerun of the workflow and the same workflow will get started with the updated values and we can cross verify it from our manifest. And we see, we can see that the chaos duration value is 100 and the chaos interval value is 50. So all the changes from my Git as well as from my chaos center are synced together. And yeah, so this is basically it. And apart from that, if you want to add some changes here, some other methods like from a pull request. So we can also do that. And for that, I let me go ahead and create a new branch. Create a new branch in this test branch. Yeah, and in this test branch, I'll add a file. I'll probably add a new chaos workflow. I have created one. So I have this workflow, which is the delete catalog workflow and it will actually target the online boutique shop. And here we can see the namespace is shop and the app label is product catalog service. So instead of configuring it from the chaos center itself, what I'll do, I'll just add a new file over here. I'll upload a file and I'll drag and drop this file over here. And I'll provide a workflow name to this. So this is the workflow name. And one thing we need to keep in mind is the workflow name should be the same as the file name. So the workflow name needs to be same as the file name over here. So now I'll just commit the changes. And from this branch, I'll make a pull request to the main branch where all our changes are being sent. So let me compare and let me just cross check if the manifest is uploaded. Yeah, so it has been uploaded, the delete catalog service. And I'll raise a PR to the main branch. Yeah, so add files via upload or PR. And I'll create a pull request. And the pull request has been successfully created. And once I merge these changes into my main branch, we can see that a schedule getting created over here as well as the workflow getting started since it's a one-time workflow. So let me merge this pull request. So the pull request is successfully merged. And in my Git repository in the main branch, I can see that this catalog service from PR has been added. And let's wait for a few minutes to see, to get the changes from the Git to get synced with the Kio Center. Yeah, so now we can see that since the PR bot merged and the changes are now in main branch, so it has triggered the Git operations. And we can see that the schedule named delete Kios, delete catalog service from PR, which is same as the file name over here, has been created. And similarly, the workflow run has also started. So let me click here and see all the related information. So we can see that it's currently installing the Kios experiments. And in a few minutes, we can see that the catalog service getting down. And let me just show all the services over here. Yeah, so this is the shop name space where I have all the services running like the card service, the currency service, the front end email service, payment service, and the catalog service. So with the current experiment, we'll be terminating this catalog experiment. And we can see that the status is in terminating state. And if I refresh this, I will see that, yeah, there is something has failed, below some details for debugging. And the service is down. So even if I refresh this, I think it should be down, but I guess it's back into its original state since the Kios injection time was pretty low in this case. Yeah, and yeah. So we can see that we have injected Kios from the gate repository. And it's now, it was visible in the application as well from the gate repository. So these were a few operations which can be performed from Kios center. So the major scope here for GitOps with Litmus Kios is to add these GitOps functionality in your CI CD pipelines or you can use these in your GitHub actions to run Kios within your CI CD stage. So I think that's it from the demo. And yeah, that's pretty much from my side as well. Thank you.


Welcome, folks, and thank you for joining this discussion session about lessons learned running Kubernetes community days across Europe. I'm Matt Jarvis. I'm director of developer relations at a company called Snake, and I am one of the organisers of Kubernetes community days UK. And I'm joined today by my awesome panel who I'm going to ask to introduce themselves very quickly starting with Alessandro. Hi, I'm Alessandro. I live in Amsterdam and run the Dutch Kubernetes Meetup with awesome people. And we did Kubernetes community days in Amsterdam in February, just a month ago, and it was a great success. Hello, my name is Annalisa Gennaro. I'm active for the KCDE Italy in the cartographers group as well, and I'm newly appointed, fresh appointed ambassador. Hi, I'm Max Carbecha. I'm from Germany. I'm running the KCDE Munich and organised also this in the beginning of this year, the KCDE Ukraine as a fundraising event. And beside that, I do also some meet up. Thank you. Hi, I'm Paula Kennedy. I co-organise KCDE UK and we just opened our CFP on Monday. So if you'd like to talk at KCDE UK later this year, you should apply now. I see what you did there. Nicely done. Nicely done. Thank you all, folks. I'll come back to you in a second. But I wanted to start by giving a very quick overview of what Kubernetes community days are for those who may not know. So KCDEs are community events organised by local community folks for the community, but kind of under the umbrella of the CNCF. So there's lots of help there from the CNCF that we'll talk about later. But they're a way of really growing the kind of local cloud native community in your region. And events typically, you know, emphasise the local kind of flavour and region and culture. So you can see some of the stats there from the overall programme success, which are some awesome numbers. 63 events in total, 16,000 plus attendees. And these have happened from all over the world. I did have a lovely slide with the world map on it, but it won't display properly. So we'll skip over that one for today. But in stats of 2022, 18 KCDEs and across 15 countries. So it's been a really super successful programme. Has anybody in the room been to a Kubernetes community day? Awesome. Thank you for all your support. Anybody organised one? Oh, brilliant. So round of applause for all the folks who've helped organise these. Thank you very much. OK, so let's kick things off and get into some of the challenges of organising these events. So putting together the right set of folks is super important for a successful event. What insights can you folks on the panel share about the sort of people who in an ideal world you should have involved? Sort of the mix of skills and things like that. So I'm going to kick this off with asking Max what are your thoughts on this one? Yeah, sure. So I think for the team you really early need to think about a good mixture of people. You definitely need some more for marketing. Also when you're like maybe tech by heart. But you really need someone who can do the outreach, who attract the people for the event. Just popping up somewhere, it's not bringing you anyone. In our case we had luck that we also had someone who knew already how to organise partially events and has a feeling for the prices for drinks and stuff like this. Because honestly out there when you organise something the most of the people wants to make money also out of you. But when you try to make a community event you have a limited budget. So it's good if you know already maybe this drinks is too much or this food is too much. So this helps very much to have some people who can help you from their experience. They don't need to be professional event organisers but they need to have a feeling for it. And then obviously you also need to have somehow a good connection to the community. To find the first speakers who can bring in where you can discuss about. It becomes speakers also a little bit later. And yeah this general mixture in the beginning is very very important to have a good kick off. Paula, do you want to add anything to that one? I'd say it's important to have quite a big team if you can. Because for us I mean we all do it as our hobby kind of voluntary. It's not our day job. And so if you only have a small number of people it means there's a lot of work for a small group. If you've got a bigger team at least you can split responsibilities, you can share tasks. And if someone has a really busy time at work someone else can pick up the load. And I think that's quite helpful. Alessandro or Annalisa anything you want to add around people? Not really but I agree with Paula. Now we are 14, about 14 people for KCD Italy and we organized in two different teams. One marketing team and the other technical. And we meet up once a week all as far as marketing is concerned. And every two weeks we all organize us. And that makes it easier to take tasks on and to back up other people workloads. You really just need enthusiasm that you must have it before you join. And great if you don't have it you're going to learn it quite fast. How many out of interest how many folks were in each of the organizing teams for these events? I know Annalisa you've said it was 14. More or less yeah. UK I think we've got nine all together. We were around six to nine dish. We had a core team people that all year long organized that and then we have volunteers on site. So some people they decided they wanted to be there. A little bit later hopefully if we get if we get timed. OK, so that's awesome. Thank you for your insights there. So the next kind of big, big thing here and probably one of the big elephants in the room. I think when you talk about putting community events on is that putting on events is not cheap. Even a small event has fairly significant cost to it. So the next kind of starting point for discussion is around money. And I'm kind of thinking here you know if you're happy to share how much the event cost please please do. I think it's an interesting interesting thing for people to understand. And you know how do you how do you raise the money? So I'll start off with with Annalisa. Yeah, case the Italy this year will be for the first time in person. So we are talking about in person events and about it would cost about 70 80,000 euros for 250 people around sponsorship is crucial. Let's say vital without sponsors. Just no event because it's very unlikely you will cover the cost with the ticket sale. So before that I would make a step, take a step back, step back and talking about need of the fiscal sponsor or fiscal entity. Because as you know you have to put money in advance and you have to find someone who can do that. In our case we decided for a third party agency who help us on the fiscal administrative sites and on the logistics as well. In that way we have no big problems with cash flow and invoising. So you need a fiscal sponsor to take payments and make payments in advance before sponsors are identified and found. One set that you have to produce a prospect which is not as easy at its sounds because you have to find appealing perks. And it's not that easy because you have to set boundaries, clear boundaries as well with companies saying and repeating that case the events are community driven community oriented events. Organised volunteers and with no profit goals. This is not a very easy to convey message. Sponsors want something back. They want leads, they want brand visibility seems not to be enough for them. So it's always a negotiation with them. It's a struggle somehow. Sorry I've got notes because it's my first time. I have to look at them. We don't understand the reasons why it's so difficult to find sponsors. Sometimes probably it's a question of higher sea levels that do not feel the community might be. There was the post pandemics time that caused problems. This year is the layoffs time. It's never the correct time for asking money. Budget is always allocated whether it's January, February, June. It's very difficult to solve that problem. So that is our experience. We are lucky because we organise, I have five companies that back us up. So we managed to put some money in advance easier. But again we have to cover 8,000 euros cost. So it would be a battle. So Alessandro do you want to give your thoughts on this? We share all the financials. It's important to be transparent. We can share with all of you all the costs and the incomes. It cost 180,000 euros which is more money than I've ever seen in my life. It was a bit scary but we covered it. We made 5,000 euros which is a lot including all the donations we made. You're not giving up the day job though right? No, I don't think so. It is scary but you can pull it off. So a bit of planning, a bit of... Well, don't think too much. Luck is true, true luck but it's also hard work. So we and all the organisers they went on and they pinged a lot of people. Be prepared to get a lot of nos. So that's okay. That helps you build character. You have to keep going. Eventually things will go well. We are happy that thanks to the amazing team we put it off. Thank you. Max, Paul or anything you want to add that we haven't covered there already? Obviously you will need a lot of time to find sponsors. Our first KCD Munich was on a very short notice just like six months from the first idea till we hold it. So this was like every day running around and like hey, do you have something for us? This is a great event first time. Do you want to comment so on so forth? So we had obviously a lot of time of struggle to find money. We thought it was a bit easier. For the second time now we have like not almost a year but like nine to ten months in preparation it's way more relaxed. So take this time. Don't rush. Maybe because one month is like the perfect month where you want to hold the KCD in your area. It's maybe a good idea but you will have very hard time. So give yourself the time so you can also find the sponsors. Just to add on to what Annalisa said as well. The thing that's helped us is having the organising team a number of people and then all of those organising team companies being able to put money in helps you get started because it is one of the challenges I think is the cash flow where you have to pay for certain things up front. You have to pay for the venue. You have to pay for catering. You might have to pay for certain things before sponsors have paid. And one tip I would recommend is it seems like the bigger the company the slower they are to pay. So if you are worried about cash flow you might want to... We're naming no names here though. We're naming no names. No naming and shaming. But the bigger they are the slower they are to pay in my experience. So going with slightly smaller companies, scale up startups and have a bit of cash that they can pay quickly might be better for cash flow. Okay, folks, I'm going to have to move you on on this one because otherwise we're not going to have enough time but we can come back at the end if there's more questions about money. So you've raised the money. Now the second most important thing I think is probably about the content and this is another super important topic. Speakers are clearly the lifeblood of any event and why your audience is going to be turning up. So what are the challenges around managing the call for papers and getting speakers? I'm going to start with Paula on this one. So call for papers I think is the starting point for us. So open it and then publicise it and keep publicising it and keep publicising it. And you do find that with an open CFP you'll get 90% of the submissions in the last three days or something. It's always people leave it to the last minute and then you'll get a whole lot but it's really, really worth just continuously advertising it. I think the risk with CFPs is a lot of people will, you'll see a lot of the same faces will apply in the same kind of like community. And so one thing that we really tried to do with our KCDUK was also to do direct outreach to people that might not have actually wanted to apply or thought about applying, but we wanted them to come and speak. And so we had a sort of a list of people that we really wanted to invite. And then our third action that we took was to actually try to go to local groups in the UK that support underrepresented communities to try to get more diverse voices in the room. So we actually approached different groups, different meet-up groups and asked them if they would put forward speakers so that we could make sure that we didn't have a line-up of folks that all look the same. Yep, Annalisa, what are your thoughts on this? Yeah, we had the same experience as Paula just said, always the same faces, always the same voices, which is fine. But again, it would be nice to have more diverse and new people on stage. We had big problems, real troubles in engaging diverse speakers. We tried every possible channel, even outside CNCF. We reached out to women in tech, sheet tech groups that are meant to voice diversity. We reached, we contacted directly individuals that were suggested by CNCF contacts, but probably there are so few speakers available, are so few that they are overwhelmed, overloaded by requests, so probably they can't take part to any CNCF event at higher or lower levels. But I want you to tell a personal story that happened to me last year. I'm very new to the CNCF community. I started just last year and to the industry as well. It was the first marketing meeting or something like that, and a person asked me to take part to talk as a cost speaker for the CNCFP of Valencia. At first I was incredibly flattered, but I was new, newbie. I'm not a non-tech person, so I was rather surprised. And when I asked the reasons why, this person replied, well, the CNCF wants and likes people as cost speakers. They want to hear more female voices on stage. So this person didn't choose me for what I am and what I could give. I was just passed by in front of his eyes and he asked me to get on the bus. So I'm not sure this is what we really want. So I think it's a very delicate topic, very difficult. I have no solution at all. I can tell you that for KCD Italy, the marketing team is made up of five women and one man. Oh, ciao, Marcello. Yeah, he is. Sorry I didn't say it. And we, nevertheless, we find very difficult to solve this issue. But again, we don't want to have women just because they are women. So it will take time probably to find a way out. Alessandro, Max, you want to add anything too? Oh, to the personal study, thank you for sharing. Well, as an organizer, as a team of organizers, you really have a chance to set the stage for your conference. So it is the most important job that you can do, making the program, curate the program. Don't publish the agenda before you check for diversity. Don't do the mistake. But yeah, it's your responsibility to choose well because everything comes from there. The happiness of the people attending their satisfaction comes from the quality of the talks. So, yeah. Max, anything you want to... I think everything is said on that. It's complicated to get it right. But I also need to say it's not only the guidelines which we need to put in place as good as possible. But it's also like meanwhile, company sponsors asking for like, hey, how is your ratio? How is your diversity ratio? If you cannot provide this, I take my money back. I take my speakers back and you can do the same by yourself. So there's also like meanwhile other pressures coming in, which is good on the one hand side to be honest. But then it's also like the other way. Like what are you doing to bring us this diversity? How do you as a sponsor bring this diversity to us? Because in the end, we are just sitting there and like we are begging for people who wants to speak. We are begging for money and like asking like, hey, let's come together, join us. But it's like someone needs also on other places to enforce this and enable this. Thank you, folks. I mean, I think the reality of that is and I think this is the message that's coming across from everyone's comments there is that you're very unlikely to achieve a diverse line up just from putting a CFP out there, right? And I think it's important for people to understand that point. Okay, so we've got some money. We've got some content. This you think is Amsterdam, right? Looks fantastic. I'm sorry I couldn't be there now. So the final big piece of the puzzle is the place. So what do we need to think about when we think about finding the right venue? So Alessandro, it looks like you had a great venue. We had a great venue, yes. Expensive, but great. No, it's important. The venue has to have a soul, right? So we didn't like, that's what I mean by you set the stage, right? So if you choose one of these corporate offices, then your conference is going to be a corporate thing. And this was instead like an old sugar factory or transformate electricity station. And it was also a club that came in handy when we did the after party in the club. So it was more cosy than very, very precise. So let's set the stage for the old conference. Yeah, awesome. Max, what's the other? Yeah, so in our case in the first KCD was actually quite funny because we searched for the right size. So it was like, you always have the problem of the combination. How many speakers do I want to have? Is it one track? Is it two track? Is it one day? Is it two days? So it's like you start first puzzling around and then you need to find one of the venues in your city or in the area where you are, which is sometimes getting very difficult. And then you start asking for like, hi, how much does it cost? So then you get another variable into this one and that's getting even more crazy. So we ended up actually was a location last year which we did not entirely liked. It was a little bit too much cosy for us. We imagined a little bit more space and more possibilities for the attendees. But we received a lot of positive feedback in the end because we like give time to for the people to move from left to right. We give enough time to talk to each other. We had for example the problem that we serve the food and the drinks in the same room where we also had one track. So what we did like, okay, we took the first and the last track out so that when we bring in food and when we start serving the food there is no talk going on and no one is getting disturbed by it.  You can still make it very cool and especially when you can give the time for the people to come around and they can adapt to it and feel more comfortable in it. I can see you thinking there for all that. No, I was just thinking back to the fact that for us we did KCDU UK and the first one was virtual so we didn't have to worry about a venue and then the second one when we came to start planning it the fun thing in our committee is that we have representatives from different parts of the UK so we have certainly England, Wales, Scotland I'm not sure if we've got anyone in Northern Ireland but anyway, so then when it came to choosing a location before we even chose the venue there was a lot of anti-London sentiment let's just put it that way people were like, why are we going to London? But we did go to London the easiest place for people to get to so I'd say that was a particular challenge for us but in terms of choosing a venue accessibility is really important it's like a number one thing if your venue is not wheelchair accessible that should be out instantly and we went for quite a central location we liked our venue it was a code node in London it's kind of a community hub space anyway so it was perfect for our size perfect for the breakout spaces and centrally located and went very well so we're going back to the same place this year What about some of the challenges around whether the venue can accessibility can mean a lot of things what about the dietary requirement bit and things like that that can be quite challenging in terms of catering Annalisa, did you have to think about things like that when you're picking venues and catering for the rest of it? No, really No, sorry, I was thinking about it but we delegated that issue to the agency I talked about so we just told them be careful about all possible scenarios that you can encounter and they handled that with Yeah, I will tell you I will answer this question in July after we will have the case later I have no idea so we are anxious and curious about Annalisa, you were all vegan, right? Yes, because it just makes it simple Yes, how many vegans are in the room? Yes, you said in the word so we could make a choice and we did and we said, okay for two days you can be vegan and it's alright, you're not gonna die we even have vegan barbecue we had fun and it was great food actually pineapple pizza is vegan so next year totally so we asked them can you work with us on this that was our strategy, our direction they worked with us, it was delicious I couldn't stop eating vegan burgers I'm not vegan myself but then we were on the news there is a movement of vegan leaders they wanted to interview us you can actually be the change you want to see in the world it's real, you can do something about it Great stuff Right, so I'm gonna kind of speed up a little bit because I do want to leave some time at the end for questions if folks have them but we're kind of on now to how do we actually get people there how do we promote and sell the tickets and I'm gonna ask this one to Annalisa I think Yeah Well, first of all thank you to Audra and Katie for all the efforts because you can find a detailed plan for marketing and promotion activities on the CNCF repo so just start from there you have to start months earlier once you choose the venue, you found the venue, just start with your promotion activities as for Kissed Italy we invested from the beginning in storytelling so we created a logo we invested on a logo because we had a story to tell and we have been doing that for the three years and we open official accounts, social accounts we have a Twitter and LinkedIn accounts we have a social posting plan and we try to be active all year long of course not only during and before the event but we ask for advocacy we ask for advocacy to all organisers with their personal and corporate accounts the CNCF accounts our support but we ask our media partners as well to be very vocal our sponsors of course we are trying them and we try to get out the CNCF community as well to attract more people from other communities so we promote on select channels on telegram channels wherever we are active outside the CNCF so that people can even know about it because we need to attract more talent on that side too and what I find very important in these terms is the collaboration with our KCD I find that it's very important to create a fabric within the KCD groups among the KCD groups for example we had a great help from KCD France and KCD Amsterdam on giving details and that is very helpful because you are talking with people that are struggling like you they understand your pain points they can find alternative solutions that you haven't think of so that could be something we could work on more in future for example trying to find a shared calendar of KCD events we were talking before this panel with Czech and Slovak KCD years it's difficult we are competing somehow Europe is a very small territory so we have to distribute KCD events better over the year and maybe to work together on the sponsorship quest collaborate on that side too that's my experience our experience as KCD Italy Paula do you want to have you got any thoughts on this topic I mean I think Annalisa is correct the amount of time it takes to promote to get people to sign up one thing that we did last year we were lucky that we had raised enough sponsorship to cover our costs and so what we tried to then do was to give more tickets away so one thing on the topic specifically of tickets one thing is to try to not price them too highly because you want community folks to come the whole point is to bring in the community so you don't want to over price the tickets and then if you can we gave some to students we gave some to again underrepresented groups we then put out a tweet that said folks who had been recently laid off could just apply for tickets you didn't need to provide proof just ask us and we'll give you a ticket just trying to get more of the community involved more people to actually be able to attend our event I think that's a good point isn't it that one way of thinking about the costing of events and I think this is where we went is that if you really cost the event on the basis of the sponsorship covering the costs then it allows you to be a lot more flexible in terms of ticket allocation and you know there's always going to be people who you would like to have at those events students, folks who can't afford the ticket price etc so if you can start from the perspective of the sponsorship actually covering the cost of the event it gives you that flexibility anyone else want to add anything on the the sort of tickets and promotion part? Yeah what we did we split the ticket so we have a two day event and now you can buy an early bird ticket this is closed sorry you can get the two day access but you can also get one access for the Monday and one ticket for the Tuesday because we have seen that some people have just too much meetings asking for a where I can sit in a meeting room we don't have a meeting room for you so this helped and it helped this year also like already for the early bird sales a lot of people like just purchases already and then if you organize something do not panic if like two weeks before the event happen you just have sold 60% of the tickets that's good because the other 40% comes in the next few hours and then it's like your inbox is basically getting spammed by people who are like start buying the tickets and you also see this little spike after you've announced to speakers for example Thanks for your sharing So this is a good thing there Okay folks well I think we've only got a couple of minutes left so I think we're going to just skip the last bit that we were going to talk about stuff on the day because we do want to put up here a bunch of resources that if you're interested in running a KCDE of your own that you can go and check out so there's fantastic resources from the CNCF in the the Kubernetes community days repo obviously you can come and reach out to to any of the organizers of KCDEs all over the world we're more than happy to share our experiences Katie is in the audience here you won't be able to miss her in the pink so just in the last couple of minutes do we have any questions from the from the audience I'm going to go to the gentleman in the middle there I know you had your hand up earlier Hang on one second if you could wait for the microphone that would be great because it's been recorded He's Italian too I'm not I'm not I have a question and a remark for the Italian KCDE I noticed that the CFP was extremely short in the time frame to submit papers so I wonder how do you plan to get reach for community with such a short CFP how short how should a CFP time be from what I understood the KCDE Italy is in July and the CFP was open I think in February and closed in March or something like that I don't remember exactly but it was open for 2-3 months Marcello Paolo, yeah I thought it was shorter but okay maybe I'm wrong Should it be longer? I think considering that that you want the reach of the local community so I say the remark and then I maybe makes more sense I think that the Kubernetes community is an event that is promoting the local community or reaching out to the local community so the local community should have a strong say or a strong chance to get there as attendees and speakers whereas what I see also in the KCDE is that there was a lot enterprise that was global rather than local whereas the like ING talks or bank stocks where the places that everybody wanted to be to listen what are those guys doing so I think the KCDE organisers should actually actively reach out to the local enterprises to say bring in speakers and especially diverse speakers and then afterwards let me say something I see the ambassadors looking at each other like I might be wrong and as I said I'm really new so this is just what I feel and what my opinion is but I think it depends on how big your local community is too Anna-Lisa I'm afraid we're going to have to wrap it up there we've literally run out trying I'm so sorry folks for those of you who had questions we will hang around afterwards out in the hallway and you can grab the panel there thank you very much for listening thank you to everybody who commits their time to organising Kubernetes community days and thank you to the fabulous panel


Hi everybody, I'm Meera. I work at a startup called Hasuna which focuses on GraphQL as a service. So we use Postgres as part of our bundle along with GraphQL but I don't work for Postgres. I just like Postgres the background so I just had it. So yeah, so I am fairly new to SQL in terms of learning some of the more advanced topics and things like that and moving on from say ORMs and such. So in that sense, the workshop by Swannan was very useful for me and some of you may have attended the fearless joints workshop as well. So I'm going to be talking about joints but before I go on to my presentation, I'll let Kreis and Aram introduce themselves and then I'll start my presentation. Okay, I'll go for my introduction then. Hello everybody. My name is Aram. I'm at Phoenix Wizard on Twitter. I am part of the engineering team. Thanks Aram. I'm Kreis. I mostly work in Python and building back-end solutions using Python. Most of my experience with SQL has been with using ORMs on Django. Only in the rarest case scenario where you want to optimize the SQL queries and figure out what actually is happening that is when you fire up the SQL editor and figure out like what exactly is happening analyze it. So but the workshop which we attended by Swannan was to give a very good introduction to the mathematical concepts which helps to understand or to build a mental map of like what exactly goes inside a query and what is it coming out. It's not just a black box anymore. You can use certain kind of assumptions and certain kind of concepts to go to understand what actually the DB engines are doing. Go to you. All right. Okay, so I'm just quickly going to share my screen. Okay, you should be able to see my SQL War Stories presentation here. All right. Okay, cool. So I'm going to talk about one very specific thing and also the thing that Swannan mentioned as if you're taking one thing away from this workshop, let this be this, which is understanding joints from a different sort of perspective. So we actually spent quite a bit of time learning that and I found it very interesting because my previous mental model of joints basically was okay we're going to have just two tables. That's not involves two or tables. It's just two tables and basically a joint statement has these keywords. I was thinking of it in terms of keywords and it'll have all these things going on and like a lot of trial and error, which is not ideal. So a lot of trial and error till I get what I was looking for. So when you're looking at like a big dataset with like thousands of lines and several hundreds of tables sort of approach hardly works as most of you know. So this mental model was not working for me at all. So we kind of discussed this in the fearless joints workshop by talk by Swannan as well and like this was what we had in the masterclass was an extension of that. So I came across this interesting quote, which I just wanted to from sellingstar, sql.com. So our goal here isn't to learn the rules for how to use group by or when to pick a left join over an inner joint. So we know we've been successful of after writing an SQL query, you can close your eyes and imagine what the computer would do and what output it would give. Only then would you be able to solve real world problems with SQL. This really a resonated, I would say with what Swannan also taught us and in general from whatever little I've seen with respect to SQL. So going forward, I'm hoping that my mental model and all my co-classmates in the workshop will also have this sort of mental model. So moving on from here, I also encourage you to check out selectstar sql.com. It has some fantastic lessons and exercises, which are fabulous. Anyway, so that is a picture of my classmates would note, but that is a picture of me trying out the relational sort of thing for the mathematical approach that Chris mentioned. So where we actually visually write out or plot out how an inner join would work. I'm not going to really get into the details of how this is done. You should check out the fearless joins thing where Swannan talks about this, but to give a very broad overview of this idea is thinking in terms of, you know, true matches, no or false matches and null matches when you're trying to join two tables. So this is for the inner join and I told you that I used to think of it in terms of, okay, joins is just for two tables, but obviously that's not the case. There are so many cases when you will have to do multi-table joins and many cases where you have to do a self join. So in those cases, this sort of a map, this sort of a mental model really helps. So I will show you a couple of examples of those as well. So understanding, so once you have a clear understanding of inner join based on, you know, null and what sort of things are excluded and what is actually present in the final join dataset, it makes it easier to extend and understand the left and right outer join based on this. So those are actually easier is what I felt. So once you nail the inner join these things kind of get easy. So what I will do is like show you some couple of examples. I already have the code setup. So I won't actually be coding this now, but I will show you the, this is from PG exercises and again, a very good website, especially if you're just kind of new and you want to try out some slightly tricky problems in SQL, not necessarily restricted to Postgres, but though it's called PG exercises. Anyway, so this is the schema for your, just so that all of us are on the same page, there are three tables, members, bookings and facilities, think of it like a sports club or something. And there are members and all their details and bookings, details of bookings and facilities, tennis courts, table tennis, swimming pools, et cetera. And all the related fields there. So I'm just going to quickly switch over to the core editor. And I hope the font is big enough in this. All right. Okay. So yeah. So the first problem is, so I'll put a list of all members, including the individual who recommended them, if any, that is the key there. So ensure that results are, okay, ordered by something. So, so I also took us over, you know, how to construct a query in the sense of the order in which, you know, the statements are executed and not the order in which we, which is not the order in which we are actually writing them. So most of the time we started off the queries in the workshop with just a select star. And then we'll figure out as to what needs to come later because the select statement is not what is executed first. So we work with, so what we need here is to start with the from and then look at what sort of join needs to go in here. So all members, including individuals who, including the individual who recommended them, if any, so in this case, what happens is members and individual, both of these refer to both of these basically come from the CD dot members table. So it is a self join. So that was one thing. And the second thing was this, who recommended them, if any, so this kind of ruled out the thing that there is a, this kind of gave the idea that there are null feels possible there. So basically, people may not have a recommendation, they would have just joined that sort of thing. So in that case, it is, since it's not going to be not null sort of thing, this will not be an inner join and definitely left out a join in this case. So, so what I'm doing here is basically have a first name surname coming together. And then I also have, so if you look at the left outer join here, I am, I'm basically self joining it with the same CD dot members.  And then it goes on to query based on this particular join. So let me quickly show you what the output looks like. Yeah. So this is, yeah, this is, these are the first two columns are the names of the members in the last two columns on the names of the names of the people who have recommended them. And you will notice that we have null values for some of these fields. So this was, yeah, this, the mental model that we spoke about in the workshop kind of made this very easily understandable for me. I've tried the same thing maybe a few months ago and probably didn't, I just winged it. I'm like, okay, let me try this, that this. So this time it was actually very, very clear to me. So that was that. And then quickly, like a multi, multi table join example, and then I'll pass it over. Okay, so what we need is a list of bookings on the day of a particular date, okay, which will cost the member or guest more than $30. So all this, this the date and the cost and all those things ideally should go into the where class. And, but there is a trick here, remember that guests have different costs to members. If you notice here in CD dot facilities as a member cost and the guest cost. So those will differ. And all this is include in the name of the facility, all that will go into the select class, which I will think of later once I have the join going on correctly, everything else I can figure out later once I have the source and the join going on correctly. All right, so what happens here is okay, I need a book, I need data from the bookings table. I also need I need to grab, you know, the members names, because yeah, so I will use this, this particular bookings dot memory and CD members members dot memory sort of that that relationship there. And this, this will also include another join where the booking dot facility ID and the facilities dot facility ID are basically having a join is based on that. So what's happening here is since we are not there, ideally shouldn't be any null values here because we all of these should have like an exact value. If it's guest, it should instead of surname, it would be guest. So, so there is no possibility of null. So we do not want any sort of null values in our table. So we go for inner join in this case. And there is a small trick here, we have to use a case also here, because we want to kind of slot it as member cost or guest cost. For that reason, I set up a case here. And then finally, in order to display it again, as in based on the filters that were mentioned, we have both and one quick thing was to, you know, basically typecast the start time and only grab the date. That was also something new for me. So that and also this greater than 30, you know, the condition that's provided in the problem. So if I run this, what I should see is, yeah. So if you see this, it's ordered in a descending fashion, the cost, but there are both, it comes as guest, because I'm doing a concat first name, surname sort of thing. So that's the reason why. But yeah, so this is how it is listed about 18 values. So and all of them above $30. So yeah, so this was a tricky one for me. I remember talking to Swannan before the workshop about this problem. He said we'll talk about it. No worry. So this kind of cleared up a lot of misunderstanding or because I was actually scared fear of joints actually. So this workshop and the fearless joints talk really helped me. And I'm hoping to learn more SQL and looking forward to more workshops from Swannan than Haski. So thank you for listening. And if you had any questions, Swannan is here. Thank you.


Hey everyone, you're about to watch a video that's going to get thousands of views. Very cool, but your ad needs to be right here. Give me a call. A cross-country charity bike ride to raise awareness for the Fuller Center for Housing Efforts to Eliminate Poverty Housing passed through Pikeville on Tuesday, July 25th. So we're going coast to coast and along our way we have nine stops where we build for families, either build houses or a lot of it's repairing houses because our main goal is to keep families in their homes that they love so much so but it's been a joy, I think we've had seven build days so far. The 10-week adventure which began May 27th in La Jolla, California will cover 3,919 miles with its final stop being in Wilmington, North Carolina on August 5th. Riders average more than 76 miles per day and stop along the way to help clean and repair destroyed homes. So we usually go in around like 8 a.m. and work into about five-ish and it can be anything. I know we got under house, did some insulation under a house and I wore a big hazmat suit and it was great. It's a lot of work but at the end of the day it's so lovely to see just all of these families and they're so appreciative because they love their homes and that's so important right now in the United States is to keep people in a home that they love. The cyclists spent the evening at Connection Church before continuing on their journey across the country. For more information you can visit foldercenter.org. For Mountain Top News, I'm Kelsey Dean.