SQL Joins for Beginners | SQL Practice Queries

#sql #sqlinterviewquestionsandanswers #sqljoins #joins #sqlvideos #sqltutorial #oraclejoins #oracle #snowflaketraining #snowflakejoins #snowflake #trending #trend SQL Joins Task : We need to get the student details sorted in the decreasing order based on the total score and add ranking column accordingly. CREATE TABLE STUDENTS(ROLLNO int, NAME VARCHAR(200)); CREATE TABLE EXAM_SCORES(ROLLNO INT, SUBJECT VARCHAR(100),MARKS INT); INSERT INTO STUDENTS values (101,'Gaurav Singh'); INSERT INTO STUDENTS values(102,'Pratima Malviya'); INSERT INTO STUDENTS values(103,'Shakti Reddy'); INSERT INTO STUDENTS values (104,'Bhushan Patil'); INSERT INTO STUDENTS values (105,'PravEEN KUmar'); INSERT INTO exam_scores values(101,'Maths',96); INSERT INTO exam_scores values(102,'Maths',91); INSERT INTO exam_scores values(101,'Science',40); INSERT INTO exam_scores values(104,'Maths',56); INSERT INTO exam_scores values(103,'Maths',87); INSERT INTO exam_scores values(102,'Science',91); INSERT INTO exam_scores values(103,'Science',99); INSERT INTO exam_scores values(104,'Science',76);