Ebay数据相关面经_Ebay数据相关面试真题及高频题

1.Relationship between eigenvector and invertible matrix

2.Item平均价格

3.Sum of Lists and Return Most Frequent

4.Word Transformation Based on Length

5.Department Top Three Salaries

6.Calculate Average Monthly Revenue by Country

7.R Language Proficiency

8.Linear Regression Fundamentals

9.Understanding Decision Trees

10.Write SQL queries for business-related calculations

11.Write a SQL query for a Hard level problem

12.SQL Query for Airline Seat Reservation and Purchase System

13.Difference between Key-Value Databases and Document Databases

14.Reverse Words in a Sentence

15.Find the Kth Largest Element

16.Array Value Reduction and Summation

17.Sorting Submatrices by Minimum Element

18.Subarray Matching a Pattern

19.Count Even Number of Digits

20.Matrix Value Search

21.Rectangle Fit Operations

22.Binary String Analysis

23.Memory Allocation and Release System Simulation

24.Minimum Circular Shifts to Match Arrays

25.Addition and Subtraction Validation

26.Rectangle Box Fit

27.Array Sign Check

1. Relationship between eigenvector and invertible matrix

特征根和可逆矩阵之间的关系

2. Item平均价格

一个item list有item id，item categories（即一个item可以属于多个category）和 price，计算某个category的item的平均价格。

3. Sum of Lists and Return Most Frequent

Given a list containing sublists of numbers, calculate the sum of each sublist. Return the sublist that has the sum which appears most frequently. If there are multiple sublists with the most frequent sum, return the one with the highest sum.

4. Word Transformation Based on Length

Given a list of words, transform each word according to the following rules: if the number of characters in the word is odd, return the word in uppercase; if the number of characters is even, move the last character to the front of the word.

5. Department Top Three Salaries

The interview question is based on a LeetCode problem named 'Department Top Three Salaries'. The task is to write a SQL query to find the employees who earn the top three salaries in each of the departments. A link to the problem is provided for reference.