Media.net Web Developer interview questions

First Round : After that shortlisting was being shared, and candidates had to a online interview on google meet. Question asked: 1)What is difference between SQL and NO-SQL, give examples. 2) 55. Jump Game Problem, You have to write the code on docs shared with us by interviewer , then he asked to dry run each loop and show the value of each variables involved, then asked the Time and space complexity. 3) What is stack ? 3) Implement stack but not with already provided stack library, In such a way that it would have minimum time and space complexity. (In short use Array as it has constant time and space complexity for push and pop). I was shortlisted for 2nd round. Second Round: This round was held offline in the media.net office First they ask some info about you and your interest in coding and development. Questions asked: 1) which data structure are you comfortable with (Here choose wisely, only say something which you have done a lot practice on, i said Linked-list and Graph). 2) https://www.geeksforgeeks.org/problems/subtraction-in-linked-list/1 , Create two linked-lists for a given two numbers in such a way that each node represents a digit of that number, after that add or subtract nodewise. (i have achieved solution for addition but the solution for subtraction was not satisfactory to the interviewer, as most of the time was consumed in this problem interviewer did not asked further coding question). 3)What are joins in SQL. 4)Write a query to get employees who have salary greater than the average salary of the table. 5) Different types of joins 6) Does every join requires a common column (here just cross join does not require common column). 7) Puzzle question : Give 3 bags with apple, orange and mix of both. Every bag is wrongly labbled, you can only take out apple or orange once from each bag, Find out the correct labels for each bag. Interviewer were always helpful, if you are wrong they say it is wrong and ask you rethink and come to correct solution.