Performance Improvement | SQL Interview question for Data Science | InterviewBit

Try is yourself:

MySQL Query:

CREATE TABLE tests (
TestId int,
Marks int
);

INSERT INTO (TestId,Marks) VALUES (100,91);
INSERT INTO (TestId,Marks) VALUES (101,59);
INSERT INTO (TestId,Marks) VALUES (102,10);
INSERT INTO (TestId,Marks) VALUES (103,10);
INSERT INTO (TestId,Marks) VALUES (104,36);
INSERT INTO (TestId,Marks) VALUES (105,9);
INSERT INTO (TestId,Marks) VALUES (106,17);
INSERT INTO (TestId,Marks) VALUES (107,39);
INSERT INTO (TestId,Marks) VALUES (108,50);
INSERT INTO (TestId,Marks) VALUES (109,77);
INSERT INTO (TestId,Marks) VALUES (110,9);
INSERT INTO (TestId,Marks) VALUES (111,33);
INSERT INTO (TestId,Marks) VALUES (112,73);
INSERT INTO (TestId,Marks) VALUES (113,82);
INSERT INTO (TestId,Marks) VALUES (114,45);
INSERT INTO (TestId,Marks) VALUES (115,71);
INSERT INTO (TestId,Marks) VALUES (116,96);
INSERT INTO (TestId,Marks) VALUES (117,2);
INSERT INTO (TestId,Marks) VALUES (118,60);
INSERT INTO (TestId,Marks) VALUES (119,1);
INSERT INTO (TestId,Marks) VALUES (120,64);
INSERT INTO (TestId,Marks) VALUES (121,17);
INSERT INTO (TestId,Marks) VALUES (122,61);
INSERT INTO (TestId,Marks) VALUES (123,62);
INSERT INTO (TestId,Marks) VALUES (124,39);
INSERT INTO (TestId,Marks) VALUES (125,74);
INSERT INTO (TestId,Marks) VALUES (126,83);
INSERT INTO (TestId,Marks) VALUES (127,15);
INSERT INTO (TestId,Marks) VALUES (128,89);
INSERT INTO (TestId,Marks) VALUES (129,100);
INSERT INTO (TestId,Marks) VALUES (130,33);
INSERT INTO (TestId,Marks) VALUES (131,88);
INSERT INTO (TestId,Marks) VALUES (132,64);
INSERT INTO (TestId,Marks) VALUES (133,54);
INSERT INTO (TestId,Marks) VALUES (134,82);
INSERT INTO (TestId,Marks) VALUES (135,40);
INSERT INTO (TestId,Marks) VALUES (136,78);
INSERT INTO (TestId,Marks) VALUES (137,87);
INSERT INTO (TestId,Marks) VALUES (138,93);
INSERT INTO (TestId,Marks) VALUES (139,94);
INSERT INTO (TestId,Marks) VALUES (140,82);
INSERT INTO (TestId,Marks) VALUES (141,51);
INSERT INTO (TestId,Marks) VALUES (142,74);
INSERT INTO (TestId,Marks) VALUES (143,29);
INSERT INTO (TestId,Marks) VALUES (144,96);
INSERT INTO (TestId,Marks) VALUES (145,52);
INSERT INTO (TestId,Marks) VALUES (146,61);
INSERT INTO (TestId,Marks) VALUES (147,13);
INSERT INTO (TestId,Marks) VALUES (148,18);
INSERT INTO (TestId,Marks) VALUES (149,81);

#sql #sqlinterview #sqlinterviewquestions #datascience #datasciencetutorial

[ashishdukare]

thank you for the detail explaination. This is the only solution available on internet so far.
Please continue making such videos. Soon you will have great number of subscribers. Best luck