Numbers Logic Challenge
I got awesome response to the previous MySQL Challenge. Awesome means, I got 6 responses, out of which 5 are correct (working) solutions and 2 are optimized solutions. You must be thinking, just 6 responses, but I am saying awesome. Yes, in my opinion quality is what matters, not quantity. I will explain the solution to that MySQL challenge in few more days. Before that, I am back with another small problem. This problem deals with numbers and simple mathematical calculations like addition.
MySQL Challenge Contest
While we were working at Indibits, on a project, we had a small requirement. We had to calculate all sign ups so far in this week. And our week starts from Saturday. I wanted to do it all in one shot. A single, short and optimized MySQL query which will return the count of all valid sign ups happened at or after 12 AM on last Saturday. And if today is Saturday, then we consider today as the date. But the problem was, how to get date of last Saturday? In PHP, it is almost easy. But in MySQL it was looking bit difficult. But when I started finding the solution, then I realized, it’s more difficult than I estimated. But I applied my logic and found a good and optimized solution in just 12 minutes.
Summer @ Indibits
You must know that I work at Indibits. And it’s a news for you. Summer @ Indibits is going to be special, as we are starting a summer internship program. We have a product idea and the team selected for the internship will work on that project from scratch. Of course, I will be there to manage the project. There will be a great learning opportunity, not only for the people who will be working on this program, but also for me. This is the top most reason which excites me.
Mosquitoes, Integral Part of Indian Life
In your opinion, which one is the biggest problem, in this world, or in your country? There are quite good options to answer. Global Warming, Terrorism, War, Lack of drinking water, Lack of education, Deficit of fuels for the future, Maoists, and Mosquitoes. You must be thinking, how Mosquitoes made an entry in the list of biggest threats to World? Don’t surprise, they are really a great threat. One night, while I was sleeping and it was around 4.30 AM, mosquitoes attacked me severely, and I could not sleep. And I started planning how to start war against Mosquitosm. Suddenly one mosquito entered into one of my nasal holes and I felt severe pain of sneezing, while I am sleeping. I also surprised how she (yes, that was a female one, because male mosquitoes don’t eat human blood) came to know what was in my mind and suddenly started attacking me!
The World is Boiling
When did I listen the word ‘Sunstroke’ for the first time? Let’s me think. Unable to find the exact info, but I guess it would be around 10 years, more or less. Before that, in summer, we used to have morning classes, then summer holidays. We used to visit our village and home of other relatives in those summer holidays. Occasionally drink local version of Lassi and cold drinks. Sometimes enjoyed to drinking coconut water too. But it was not that hot, and no sunstroke.
Then we were introduced to ‘sunstroke’. We stopped going out at noon during summer. But the morning was always cool. The days in the summer used to too hot in the evening, but too cool in the morning and I never used to run the fan in the morning. But morning are not like those days. The world is now boiling.
