Question library
Questions from real interviews. Drill any of them by voice in a couple of minutes, with an interviewer, a score and feedback.
What kinds of JOIN are there in SQL, and how do they differ from each other?JuniorYou join the orders table with the payments table, and the total revenue in the report suddenly grows almost threefold. How would you look for the cause, and how would you fix it?Mid-levelAfter joining orders with the promo codes table, the revenue total in the report came out fifteen percent higher than the accounting team's number. How would you look for the cause, and how would you fix the query?Senior