The table had 3 columns. Name of the caller, Name of the phone call receiver, time of the call. Write a query to select names that have made 1st and last call to the same person in a day.
Bi Engineer Interview Questions
1,658 bi engineer interview questions shared by candidates
Tell me a time you worked in a team
SQL: 1. Dynamic join - Left Join to get next day's data. Join on a.order_date = b.order_date + 1. 2. Use CTE to join multiple tables. Use window function (Dense Rank Over).
Python assignment Amazon Leadership Principles questions
How do you manage two work tasks at once
Types of Joins in SQL, SQL vs NoSQL
Was given a python function, needed to fix it
first round sql given 3 tables Asked hours spent per each day used window functions to to build that query next question asked to join these tables to filter different process used inner join on 3 tables last question was to build a subquery and find out the data where the hours worked is greater than 100
What are the projects that you have worked on till date?
What is the difference between WHERE and HAVING clauses?
Viewing 501 - 510 interview questions
See Interview Questions for Similar Jobs
Senior Bi DeveloperMsbi DeveloperSenior Pl Sql DeveloperSap Systems AnalystPl Sql DeveloperInformatica Etl DeveloperSap Business AnalystSenior Oracle Database AdministratorSenior Oracle DeveloperEtl DeveloperSenior Etl DeveloperSql DeveloperSap SupportProgrammer AnalystApplications AnalystTechnical ExpertSenior Bi ConsultantSql Bi Developer