Database (SQL)

-
Hello readers👋 Today we will practice some SQL questions😁


I am assuming you went through the website of W3Schools that I shared in my last blog. Even if you have not, I would urge you to go through it before you start solving the questions below :) 

I would recommend you to solve the SQL50 plan of leetcode if you are revising your concepts or your PM interview is just around the corner. For structured solutions of this plan you can refer my Github Repository - Link
To sharpen your SQL problem solving skills you can check out the links below which have been segregated according to the level of difficulty.

Easy


MEDIUM


HARD

Comments

Post a Comment

Popular posts from this blog

Top 5 Technologies to learn in 2022

-
Image
With the growing technical trends and new innovations coming up every day, we all get fascinated by science and its craze all around the world. Technology has a vivid bandwidth of its own and we must be smart to learn about the latest and consequential technologies which can provide us future benefits and enjoyment as well. So, if you are a curious student or a thriving professional, here are the top trending technologies which you should know about.  Android Studio- This is the most important and fun technology developed by Google, JetBrains. Kotlin is the official language of Android Studio and it has also been listed as the top technology for 2022 . Who does not use an application in their smartphones? You know everybody, thus developers can work in this domain and show their creativity in the technical field to the whole world. Machine Learning – With the advancing times, machine learning has gained the public demand in all the professional spheres
Read more

Impact of Covid on Real-Estates

-
Image
  Impact of COVID-19 on Real-estate in India Novel Coronavirus has been termed the “Black Swan”. Being rare, this pandemic has globally made a drop in many spheres. Concentrating on the Real-estate, we notice a surge in production all over the world. India being the second largest producer of goods however has to import steel and coal from other countries and the major being China. China- the epicentre of COVID-19 Its production has  decreased drastically in the recent period. Hubei ( where Wuhan is located), has shut down all its manufacturing units. Plastic, steel, fibre, coke; and all the significant material for building purposes are on a toll So, if you were to buy a property, hang in there cause you have to plan everything once again! India's Conditions on the grounds of Real - estate In India’s 120 million population, it is an ordeal to manage the supply chains. Looking at this festive season, where occasions like Gudi Padwa, Mahavir Jayanti
Read more

Basic Product Management Jargons - I

-
Image
  Hello readers👋 Today we will learn about the basic jargons used in Product Management. As a PM you must know them thoroughly and I hope you will start using them after the end of this blog in your daily communications. North Star Metric - The NSM is the core value that your product delivers to your customers. By optimizing this metric, you can address long-term business success. Examples - For a SaaS product it is the DAU(Daily Active Users), For an E-commerce industry it can be the GMV (Gross Merchandise Value), For OTT platforms it can be the time spent by the subscriber, and many more. Churn Rate - It is the percentage of users who stop using your product after a certain period of time. There can be monthly/annual churn rates. Keeping this rate low is essential to keep the active customer base high.  Churn Rate = (Number of Customers Lost During a Period / Number of Customers at the Start of the Period) * 100 Agile - It is a project management or a product development methodol
Read more