Business Analyst

What are the different types of joins in SQL? (Learn)

What is the difference between DELETE and TRUNCATE commands? (Learn)

What is the difference between DDL and DML commands? (Learn)

1. Why do you want to join Paytm?
2. What Significant Challenges and Difficulties Did You Face? How Did You Handle Them?
3. How Much Salary Do You Expect?

Imagine you are working as a data analyst at Paytm. Your task is to filter down the customer transaction data based on multiple boolean conditions. You need to find all transactions that were done during the month of March and April, for total transaction amounts greater than 500. Also, separate the transactions that were successful from the ones that failed.

Given the table EMPLOYEES(EMPID, NAME, DEPARTMENT, SALARY), write a SQL query to get the information for the employees with the top three highest salaries. (Practice)

You are given an array ‘arr’ of size ‘N’. You are provided with ‘Q’ queries, each containing two integers, ‘L’ and ‘R’. Your task is to return the sum of elements from the position ‘L’ to ‘R’ for each query.

For example:

You are given arr = [1, 3, 4, 5, 6, 9], and queries = [[1, 3], [5, 6] , [1, 6]].

For the first query [1, 3] sum of elements = 1 + 3 + 4 = 8. Hence the answer is 8

For the second query [5, 6] sum of elements = 6 + 9 = 15. Hence the answer is 15

For the third query [1, 6] sum of elements = 1 + 3 + 4 + 5 + 6 + 9= 28. Hence the answer is 28. 

Hence the final answer is [8, 15, 28]

What will be the output of the following Python function?

min(max(False,-3,-4), 2,7)
a) -4
b) -3
c) 2
d) False