SDE - Intern

You are given an array of integers 'ARR' of length 'N' and an integer Target. Your task is to return all pairs of elements such that they add up to Target.

Note:

We cannot use the element at a given index twice.

Follow Up:

Try to do this problem in O(N) time complexity. 

1. Write a query to find the names of the customers who have purchased less than or equal to one product. Order the output by customer name. The customer table contains customer ID and customer name, while the product table contains product ID, corresponding customer ID, and product name.

2. Write a query to find the average marks of each class using the given table. The output should be rounded off to four decimal places and sorted based on the class. A single table with student information is provided.

• Questions mostly regarding personal details that are not on your resume.
• What do you do on a stressful day?
• A situation where you had to prove your time management skills.
• What do you know about our company?
• Why did you choose our company?