python :average length of words.
Data Engineer Interview Questions
20,247 data engineer interview questions shared by candidates
High level SQL questions, Designing a database given a scenario and questions based on that, join optimization, reporting SQL questions without using special functions like lag.
Can't remember them, but I know it wasn't the simple stuff like basic commands. CD, LS, PWD, RM, MV, TOUCH etc.
Phone call with recruiter with 5 SQL, 5 Python questions
Python: 1. count occurrence of a word , 2. Uncommon words from two sentences 3. Replace None with previous value SQL: questions on Sales, Promotion, Product tables. Calculation of percentage of total sales on start and end dates with overall sales, etc.
Sql, python and data modeling
Select a couple columns from a single table where one column equals a keyword.
Given a table of users and whom they sent friend requests to, what is the average number of friend requests sent in the last week?
sql: already present in glassdoor. 1)ratio of is_fat and is_someother among total products 2)top 5 single channel companies that spent max amount on promotion. take into account of the ones that have only single entry company , channel; 1 food, water 2 food 3) percentage of sales on first day and last day python: occurrences of a letter in a string, replace none with previous value in a list, from a dictionary get the keys corresponding to nth highest value.
simple sql queries, but hard schema
Viewing 1561 - 1570 interview questions