Only mistake is both the case and the count(*) are integer values. So you want to convert it to a float to have decimal points. Easy fix to your code would be *100.0.
The definition of Power is in fact the probability of 'not' making the type II error, not the other way around mentioned by the interviewee. It is the probability of rejecting the null hypothesis when, in fact, it is false.
Why can't we use MIN function to determine the first order the driver delivered: WITH zero_rating_first_order AS( SELECT driver_id, MIN(order_place_time) FROM delivery_orders WHERE delivery_rating = 0 GROUP BY driver_id) SELECT COUNT(zrfo.driver_id)*100/COUNT(DISTINCT(driver_id)) FROM delivery_orders JOIN zero_rating_first_order as zrfo ON driver_id; Or is there anything that I missed?
ChatGPT can answer all the question related to code. So I don't think interviewer should ask those questions anymore. They would focus on how we solve the problems by ideas
The interviewee does not understand what he said. Unfortunately, he now becomes interviewer. This explains why so many people who knows these stupid stuff failed the interviews.
Q1:
SELECT
MONTH(order_time),
SUM(CASE WHEN DATETIME_DIFF(actural_delivery_time,predicted_delivery_time,MINUTE)
FORMAT_DATE('%Y%m', order_time) is an interesting alternative to avoid grouping months from different years
@@alexandretostes9002 Right, missed that detail.
I think DATE_TRUNC() also works
where year(actual_delivery_time)=2021 is required. if multiple years of data present, then all years...month wise grouping will be done
Only mistake is both the case and the count(*) are integer values. So you want to convert it to a float to have decimal points. Easy fix to your code would be *100.0.
When MDE increases, the sample size decreases !
The definition of Power is in fact the probability of 'not' making the type II error, not the other way around mentioned by the interviewee. It is the probability of rejecting the null hypothesis when, in fact, it is false.
Thats correct.
0.07 is still not stat sig - going ahead and rejecting the null in that scenario would be wrong
This was great
Why can't we use MIN function to determine the first order the driver delivered:
WITH zero_rating_first_order AS(
SELECT driver_id, MIN(order_place_time)
FROM delivery_orders
WHERE delivery_rating = 0
GROUP BY driver_id)
SELECT COUNT(zrfo.driver_id)*100/COUNT(DISTINCT(driver_id))
FROM delivery_orders JOIN zero_rating_first_order as zrfo
ON driver_id;
Or is there anything that I missed?
ChatGPT can answer all the question related to code. So I don't think interviewer should ask those questions anymore. They would focus on how we solve the problems by ideas
Awesome
The interviewee does not understand what he said. Unfortunately, he now becomes interviewer. This explains why so many people who knows these stupid stuff failed the interviews.
honestly i found the response of the interviewee so messy .. are they correct ?