Journey

CREATE TABLE orders (     id INT PRIMARY KEY,     customer_id INT,     courier_id INT,     seller_id INT,     order_timestamp_utc DATETIME,     amount FLOAT,     city_id INT ); INSERT INTO orders (id, customer_id, courier_id, seller_id, order_timestamp_utc, amount, city_id) VALUES     (1, 101, 201, 301, '2023-01-15 10:30:00', 50.00, 401),     (2, 102, 202, 302, '2023-01-16 11:45:00', 75.50, 402),     (3, 103, 203, 303, '2023-01-17 12:15:00', 120.25, 403),     (4, 104, 204, 304, '2023-01-18 09:00:00', 30.75, 404),     (5, 105, 205, 305, '2023-01-19 14:20:00', 90.80, 405); Q.1 Which hour has the highest average order volume per day? Your output should have the hour which satisfies that condition, and average order volume. Approach 1: With CTE WITH RankedHours AS ( SELECT DATEPART(HOUR, order_timestamp_utc) AS hour_of_day, AVG(amount) AS average_order_...

27th February 2022, started with late-night (26th February) advance wishing. For the first time, I slept early, then witnessed a lot of WhatsApp messages. I did not go through all of them straight away, and I got ready for cycling. I cycled for 21 kilometres and wanted to put a good note towards the end of this month—346 Km of 400 Km in February. When I reached home, mummy hugged me and wished me "Happy Birthday". My day just started. Saw my niece record a Happy Birthday message video, and she was excited to expect me.  There were a few more surprises today- my brother in law, sister, and Ishaan planned a lunch party at Big Barbeque, Marthahalli. We had a good time till 5:00 PM. I love earrings, and my sister got them only as my birthday present. Vijay, with whom I am meeting for marriage purposes, was the first person who wished me a Birthday. I was the second person who sat in his car after his Mother. The vehicle looked lavish, classic. He gifted me a valet, a mirror, and ...

  Since my childhood, I used to wish I could have a cycle and would go cycling on Road without any fear.  Well, that came true in the last year, 2021, in October. :) Well, what to say about cycling? It's becoming one of my daily routines; I miss it badly if I do not go out cycling. It gives me immense satisfaction and calmness.  Make my mind filled with a particular ray of hope for solving or fighting out any problematic situations. We all know how complicated life is for an individual, including work satisfaction, work pressure, personal commitments, etc. We don't always analyze every situation at one go; we take it slowly and carefully. Similarly, when you cycle at full speed, you often get to have inevitable distractions. For example, someone is asking for a pass; someone is constantly behind to surpass you; someone wants to ride faster than you; someone will come from another way without following any rules. We take it one by one depending upon our strengths and weakn...

Society Norms in India Since my childhood, I have been observing quite a few things that are prevailed for many years. These are my personal thoughts and not the judgment for someone. As girls or women, we are always considered enemies of each other. A female working professional can't see their friend's success. It's also applicable to their personal life. The question which remains unanswered for me is why mothers compare between a girl child and a boy child. Why there is a comparison between a daughter and a son? Why freedom is not equally provided to a daughter as compared to a boy child?   From childhood, girl children have been taught how they need to take care of their things and do household chores along with study or work. If they are not capable of doing these things they are supposed not to be trained by our guardians or parents. Also, most of the time especially, mothers will say they should learn this will help us in their future. Whereas, these a...

Hello Everyone! I am thankful to God who gave me such a good memory. This helps me arrange those memories in the form of clouds that always stay in my subconscious mind. As and when I want I can see those on my mind's projector. Since all my siblings were very good in studies they choose all their lines of study; left Patna starting from 2002 to pursue their studies. Firstly, it started with my eldest sister Shalini who went to the US at our Uncle's Place. After that other two sisters to Davangere and then Brother.  My mother, I used to see off them and used to wait for their midterm holidays. I started losing all my interest in studies. Gradually, the results into the exit of rank in School Examination from Top 5 and Top 10 respectively.   I remembered an instance where I dialed Sheetal Didi's Hostel number in the evening hours and asked if she was available to talk? When we received a call- back I lied stating I did not call. There must be some confusion or wrong con...

31st October 2019 -An Evening to remember!!! As the article's name is an evening to remember, I must say what a fantastic evening we had from 6 PM to 9 PM. The five amazing ladies (Sunitha, Rishika, Urva, Manali and Me) were just clueless about what was happening during the snack time of Edureka's Monthly Team Meeting. I was already depressed because of professional commitments. However, I tried hard to mingle and do some peals of laughter. Unfortunately, it did not last for a long time. I started feeling suffocated as I badly wanted some fresh air to dissolve in my mind and heart, which could rejuvenate me. I believe God at the time was looking down at 5 Ladies and wrote all the fun activities for us one by one. We left the party at 6 PM from Bowring Institute MG Road and decided on a pub where we could dance. We decided to hop at  Shakesbierre Mg Road to drink and dance to some hip hop kinds of music.  Parallelly, we also wanted to explore Decathalon clothes, sports...

My friends ask me how can you just manage to prepare meals every day and carry it? My answer to them has always been it's a matter of practice and you should not have expectations from anybody. I believe I have learned from my mother and my sisters. My school days were actually difficult for me in terms of Travelling. I failed to understand who coined the term FIFO. That did not work for me at all. Like every other day, my school bus used to come at 6:45 am to pick me from Ashok Raj Path, opposite to B.N. College, Patna. I was lucky enough that Mummy used to get up early to prepare meals for me. Gradually, my sister Shalini took that responsibility for a limited period. I used to enjoy my window seat on the bus, seeing people traveling with different means of Transportation. My energy level used to be so high and this was the reason to organize assemblies like Reading News, Singing National Anthem, etc. I loved them all! My school bus used to do Daily two trips and I w...

No doubts there are many people (especially my family members) in my life who has always motivated me and want me to work on myself. This time, I would like to draw some instances when I was completed shattered personally and professionally. There are various instances but would share 5 to 6 from my end. Here you go!  1st Time - April 2017 during the second week  My sister -Shaily Choudhary was travelling to India with her family. I was so excited to see Shivi (my niece) for the first time because I used to enjoy playing with her on Skype calls. We had plans to roam together. But could not happen as we thought of. In between, my guardian was trying to fix an alliance for me as usual. The guy's family was supposed to see me and wanted to take the matter forward.The guy was working in Dubai for the last 8 to 10 years. But when we did some homework regarding his profile, we found that he was 36 or 38 years old. His parents hid his age from us. It did not bother much ...

Life never gives a damn where you are right now and what you shall be after certain decades. Life is unpredictable, it motivates and demotivates a person with somebody's achievements or success. Life always gives various chances to everybody and it's in our hand to choose to exceed.  There are instances, where we are neglecting the chances and not helping us to move forward in life. Yes, I mean it personally and professionally both. There are instances, where you find things which are apt for your life but, also you will encounter things aren't unseemly. One isn't sure why they feel that as unfitting.  I am sure, they must have thought, they would not be able to do it because of reasons like lack of determination, lack of confidence, doubting on their own capabilities, can't take things forward and etc. I am in fact very attentive, and usually came across a situation where I saw people starting the things in full enthusiasm but unfortunately, unable to carry...

Different Opinion At An Age of 19

16/4/2017 - Sunday Well from where should I start off? If I go back to 2016, search for a new job had started. Fortunately, I got to hear about Unacademy and desired to join this company since it was a startup company.  I joined Unacademy on 10th Dec as Content Manager. My starting day was Monday i.e 12th Dec. I was extremely happy that I joined Education space and wanted to leave my mark. I had already left my mark in Healthcare and was not willing to continue. My journey started working with Roman. I was assigned to convince and train probable Educators to get onboard to our platform. I still remember I was asked to train 25 to 30 people every day. Eventually, I held up executing that for a month.Eventually, I got another responsibility for finding out people for Banking category. With an experience of 5 years in Business Development Role, I thought it would be a cake walk for me but it wasn't at all. I had to mug up all my experience and cast them into my conver...

A Stall of Momo(2) - 21/3/2016 As every day, I walk from KFC Signal to my house, I often observe a man who stands and waits for customers.Failed to understand what's happening? When I started going to that place I got to know what he has been selling.That particular place is surrounded by no. of showrooms, diagnostic centres, malls like Maxmart, Peoplemart.I have been seeing the amazing correlation of management terms and his stall of Momo. When I started for Zumba classes in the month of April 2015, I saw the vendor for the first time.I could not resist myself and inquired about from the vendor what is this? how often you stands over here and sell these foods.  It seemed to me like Modak but it was not Modak. It was piping hot and lips smacking. I was amazed to see efforts of owner to serve the customers.He hails from Assam and speaks in English with few customers if, required. He may be of 35 or 40 years old.He usually wears pant of old style and half sleeves shi...

6/10/2015: Journey from June to October in Qyk comes to an end It all started well in June , was very happy after getting a prestigious position in a start-up company Qyk. During initial week of work, I took back to back interviews for selecting good candidates. Fortunately, I hired a good bunch of people in my team. The first week with Reshmi, Kalyan and Prabu I had the wonderful time by different mock session.The mock session was totally based on how to convince the professionals for getting hired on our platform. Week by week we grew from 5  members to 12 members.By 22nd July,2015 we had 12 members in a team.We started from 0 professionals on 7th June and made it to 9000 professionals till 30th September 2015. After spending a good time in the company, we on-boarded 1500 plus professionals to our platform. We got first appreciation by my manager for doing brilliant and congratulated every members who partake for boarding.That day was very special as I felt mission g...