Hey Guys! Welcome to the world of data where you will meet the king of the data.
When I started my computer science degree , I underestimated the power of sql. Thought it was boring like our teachers and never got the grip only when I started my journey towards data analysis .
Now when i make query to retrieve the data and that fucking gorgeous feeling of making the query those complex query and getting the answer which helps business to understand the product makes me feel that yes i am right track.
SQL , do wonders for retrieving our data , filtering and applying metric all these combines only happens because of SQL
Many people often question and even I had those questions when I started learning SQL.
DUDE , no amount of learning is enough in any field. Even today I learn a lot every single step.
The only thing u need to learn is are you able to even understand the questions, any interview cracking website is asking?
Chill babes!!
I was you (cry)
What I have learned till now is to get familiar with the data , familiarity is important.
DO not ever jump on the answer , you will waste time.
Read the Question , Get familiar , Read the data , Get Familiar
And now print the result , you think will be
Print output !!!! Most Important !!!!
And now start writing a query , this way you will have direction!!!
These are the steps I follow in my daily life. I know what column as an output , I understand what question is being asked , you can visualize how data will be loading and forming.
I know babes , you all need sql roadmap — and here it is — Mastering SQL
So before leaving let’s do something , I will share a question and all you need to do is comment on the answer !!!!!
The Question — Write the query on what is the Average Time Spent by User???
To Insert Data -
CREATE TABLE UserSpend (
UserName VARCHAR(50),
TimeSpend_inMin DECIMAL(10,2),
MoneySpend_inDollar DECIMAL(10,2)
);
INSERT INTO UserSpend (UserName, TimeSpend_inMin, MoneySpend_inDollar)
VALUES
('User1', 2, 25),
('User2', 5, 12),
('User3', 9, 10),
('User4', 4, 20),
('User5', 1.6, 11),
('User6', 19, 200),
('User7', 23.01, 50);I will wait for your answers , guys. See ya !!!
COMMENT THE ANSWER!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
