Wayfair数据相关面经_Wayfair数据相关面试真题及高频题

1.Measure the strategy of pricing

2.Decrease of conversion rate

3.MySQL Query to Match Train Departures with Passenger Arrivals

4.MySQL Query Using LEFT JOIN to Calculate Test Pass Rate and Score

5.MySQL Query to Select Condition-Satisfying IDs

6.Python Sum of Two-Digit Numbers

7.SQL Aggregation Query

8.Calculate Total Imports and Exports by Country

9.Calculate Total Import and Export Amounts by Country

10.Group By Company SQL Query

11.Python Programming for Number Printing

12.SQL Query with LEFT JOIN and IFNULL

13.Ice Cream Dataset Analysis

14.SQL Ranking Query

15.Ice Cream Dataset Insights and Recommendations

16.Shipping Time Reduction Analysis

17.SQL Window Function Application

18.Ice Cream Case Analysis

19.Python Array Rearrangement

20.SQL Question

21.AB Testing Case Analysis

22.Debugging Python Code

23.SQL Ranking by Partition

24.Coffee Maker Pricing and Policy Case

25.Logistics Pricing Analysis Case

26.Google Bid Problem Case Study

27.Linear Model for Predicting House Prices

28.Take-Home Presentation on Channel Analysis

29.Case Study on Assignment and Scheduling

30.Shipping Cost Estimation Case

31.Product Matching Case Study

32.Forecasting Monthly Sales from Daily Sales Data

33.Design an Autocomplete System

34.Calculate Total Weight of Goods on a Truck

35.SQL Query for Employee Count and Total Salary by Department

36.Sort Roman Numerals

37.Convert Date Format

38.Project Deep Dive

39.Problem Analysis and Simple Calculations

40.Data Analysis and Conclusion with Google Sheets

41.SQL Problem Solving

42.SQL and Pandas Assessment

43.Name Sorting with Roman Numerals

44.Date Format Conversion

1. Measure the strategy of pricing

关于wayfair针对coffee maker的定价做出了一个决策，让你分析决策的好坏。数据包括决
策执行前半年和之后四个月的cost、sales、visit数据。另外还提供了coffee flter和toast ovens
的数据，但它们是没有定价调整的，可用来做对比

2. Decrease of conversion rate

| 关于conversion rate，问你关于一些怎么利用conversion rate 去判断新的period 哪里出
错了导致conversion rate下降，并问解决方案

3. MySQL Query to Match Train Departures with Passenger Arrivals

Given two tables, one with train departure times and the other with passenger arrival times, write a MySQL query to find out how many passengers can catch each train, assuming passengers arriving before the train's departure can board the train. The output should include the train ID and the count of passengers.

4. MySQL Query Using LEFT JOIN to Calculate Test Pass Rate and Score

Write a MySQL query that uses LEFT JOIN on tables test_groups and test_cases to calculate the number of passed tests, the total number of tests, and the resulting score.

5. MySQL Query to Select Condition-Satisfying IDs

Write a MySQL query to select IDs from a dataset that satisfy certain conditions. The conditions include whether the car is new or old, the price, and the production year.