Tesla数据相关面经_Tesla数据相关面试真题及高频题

1.Easy SQL Problem

2.SQL vs NoSQL

3.Normalize a JSON-like Structure

4.Find Subarray Start Intervals of Ones

5.Calculate Differences Between Consecutive Elements

6.Server Status Query

7.Count Reserved Tickets

8.Calculate the first ineligible date for each car that was cancelled or not delivered

9.Calculate the weekly delivery rate for a specific car model this year

10.Calculate the number of users who placed orders for at least one model

11.Calculate Test Scores as Percentage

12.Minimize Deletion Cost to Avoid Repeating Letters

13.Minimize Operations to Avoid Consecutive Characters

14.Interleave Digits of an Integer

15.Maximum Instances of 'balloon' from a String

16.Minimum Coin Flips for Alternating Sequence

17.Selecting Employee Names with Their Manager's Name

18.Selecting Customers Without Orders

19.Coding Challenges

20.Tableau Optimization

21.Simple Linear Regression Function

1. Easy SQL Problem

Solve an easy SQL problem. Provide the SQL query you would use and explain your reasoning.

2. SQL vs NoSQL

Discuss the differences between SQL and NoSQL databases. What are the advantages and disadvantages of each, and in what scenarios would you choose one over the other?

3. Normalize a JSON-like Structure

Write a function to normalize all numerical values within a JSON-like structure. The function should traverse the structure and normalize numerical values found within.

4. Find Subarray Start Intervals of Ones

Write a function that takes an array containing only 0s and 1s, and returns the start and end indices of subarrays that contain only 1s. For example, given [0, 0, 0, 1, 1, 1, 0, 0, 1], the function should return [(3, 6), (8, 9)].

5. Calculate Differences Between Consecutive Elements

Write a function that takes an array of integers and returns an array of differences between consecutive elements. For example, given [1, 2, 6, 4, 7], the function should return [1, 4, -2, 3]. For the follow-up, discuss how you would handle the case where the input array is infinite.