Performance Improvement | SQL Interview question for Data Science | InterviewBit

Try is yourself:
InterviewBit link : https://www.interviewbit.com/problems...

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