SQL Tutorial for Beginners | Query to find profit and loss for stocks | Learn SQL Concepts
#sqlforbeginners #sqltraining #sqlinterviewquestions #learnsql
#sqlprogramming
SQL Tutorial for Beginners | Query to find profit and loss for stocks | Learn SQL Concepts
What are the most common SQL interview questions for freshers?
How do I prepare for SQL interview questions and answers for experienced professionals?
What are some tricky SQL interview questions?
Use below scripts for the video:
CREATE TABLE stocks(
[stock_name] [varchar](50) NULL,
[operation] [varchar](10) NULL,
[operation_day] [int] NULL,
[price] [int] NULL
)
insert into stocks values('LG','Buy',1,1500);
insert into stocks values('Godrej','Buy',2,1200);
insert into stocks values('LG','Sell',5,5000);
insert into stocks values('Voltas','Buy',17,20000);
insert into stocks values('Godrej','Sell',3,1300);
insert into stocks values('Godrej','Buy',4,1500);
insert into stocks values('Godrej','Sell',1,1100);
insert into stocks values('Godrej','Buy',5,1400);
insert into stocks values('Voltas','Sell',6,15000);
insert into stocks values('LG','Sell',10,1200);
Learn SQL Step by Step | Database Queries Made Easy
SQL Made Simple: The Only Tutorial You Need
Stop Struggling with SQL — Learn It the Easy Way
SQL Secrets Every Data Analyst Should Know
The SQL Skills That Can Get You a Data Job
sql interview
sql interview questions
sql coding interview
sql practice questions
sql interview preparation
data analyst sql
sql for data analyst
sql developer interview
sql assessment
sql test
#sqlforbeginners #sqltraining #sqlinterviewquestions