Question
Table - Incidents Column Date_of_incidence , incidents Get the start date with the longest period without any incidence  
in progress 0
3 weeks 0 Answers 74 views Grand Master

Question
Q: We have a product. It’s screen and event data is as below: Screen Name  Event Name  Timestamp A                        1                      ...
0
4 weeks 0 Answers 40 views Newbie

Question
Q: We have CUSTOMER table having columns as Customer_Name, Merchant_name (Amazon, Flipkart, Myntra etc.) and Transaction_value (Purchase value for each of these merchants). Write a query to Transpose this into Customer Name, Merchant Names as individual columns and their transaction ...
0
4 weeks 0 Answers 41 views Newbie

Question
Q: We have a CUSTOMER table having columns as Cust_ID, Month, Sales_value. Write a SQL query to add the missing months for each customer and to have sales value = 0, corresponding to those missing months which are added
0
4 weeks 0 Answers 43 views Newbie

Question
Assume you are given a table for spending activity by product type which has column names as order_id, user_id, product_id, spend, date . How to write a query to calculate the cumulative spend for each product over time in chronological ...
in progress 0
Anonymous 1 month 1 Answer 56 views

Question
Given a string containing just the characters '(' and ')', find the length of the longest valid (well-formed) parentheses substring.
0
3 months 0 Answers 39 views Great Grand Master

Question
You are given a set of n types of rectangular 3-D boxes, where the i^th box has height h(i), width w(i) and depth d(i) (all real numbers). You want to create a stack of boxes which is as tall as ...
0
3 months 0 Answers 31 views Great Grand Master

Question
Given an array of integers nums sorted in ascending order, find the starting and ending position of a given target value. If target is not found in the array, return [-1, -1]. You must write an algorithm with O(log n) runtime complexity.
0
3 months 0 Answers 34 views Great Grand Master

Question
Given two non-negative integers num1 and num2 represented as strings, return the product of num1 and num2, also represented as a string.
0
3 months 0 Answers 33 views Great Grand Master

Question
Given an array of distinct integers candidates and a target integer target, return a list of all unique combinations of candidates where the chosen numbers sum to target. You may return the combinations in any order. The same number may be ...
0
3 months 0 Answers 84 views Great Grand Master

Question
Given a rod of length n inches and an array of prices that includes prices of all pieces of size smaller than n. Determine the maximum value obtainable by cutting up the rod and selling the pieces. For example, if ...
0
3 months 0 Answers 42 views Great Grand Master

Question
Given n dice each with m faces, numbered from 1 to m, find the number of ways to get sum X. X is the summation of values on each face when all the dice are thrown.  
0
3 months 0 Answers 37 views Great Grand Master

Question
Describe a project you're proud of If I interview your PhD advisory, and I invite him/her to describe your strength and weakness, what do you think he will say.
0
3 months 0 Answers 41 views Great Grand Master

Question
The homicide rate in Scotland fell last year to 99 from 115 the year before. Is this reported change really noteworthy?
0
3 months 0 Answers 40 views Great Grand Master

Question
Given a list of all followers in format: 123, 345;234, 678;345, 123;…where the first column contains the Id of the follower, and the second one is the Id of who’s followed, find all mutual follows(pair 123, 345 in the example ...
0
3 months 0 Answers 38 views Great Grand Master

Question
Given a 2-column file with user codes and counts, retrieve the top-k users based on a score that is a function of the number of times they appear on the file and these counts.
0
3 months 0 Answers 41 views Great Grand Master

Question
If you got the job at Twitter and got access to all of its data what kind of data analysis would you like to perform?
0
3 months 0 Answers 34 views Great Grand Master

Question
Let’s say we want to roll out a new push notification system to see if we can retain more users. How would we go about doing this?
0
3 months 0 Answers 32 views Great Grand Master

Question
What features would you use to build a recommendation algorithm for Twitter users?
0
3 months 0 Answers 27 views Great Grand Master

Question
what is the most challenging aspect of what you do now Describe a recent data science project you have worked one.
0
3 months 0 Answers 38 views Great Grand Master

Question
Infection rates at a hospital above a 1 infection per 100 person-days at risk are considered high. A hospital had 10 infections over the last 1787 person-days at risk. Give the p-value of the correct one-sided test of whether the ...
0
3 months 0 Answers 32 views Great Grand Master

Question
Given measurements of acceleration taken from a wristband, with second by second acceleration in the X, Y, Z axis, how would you predict if the person wearing the wrist is sitting, walking or just standing?
0
3 months 0 Answers 36 views Great Grand Master

Question
Given a sorted array A and a target value B, return the index if the target is found. If not, return the index where it would be if it were inserted in order.You may assume no duplicates in the array.
0
3 months 0 Answers 70 views Great Grand Master

Question
Given an sorted array A of size N. Find number of elements which are less than or equal to B.NOTE: Expected Time Complexity O(log N).
0
3 months 0 Answers 40 views Great Grand Master