Flatiron Health DA Karat interview

40 mins totally


brief self-introduction


OA for SQL + R, no other questions

• R

csv file download here


you should:
ignore missing id if id is missing, covert missing pay as 0, missing churned but pay exist: treat the customer as active
.google  и

Task: calculate the average number of days a customer remains active and their average pay for customers who have churned.

• SQL

find top students, select only those students whose average scores are in the top half of all students, rank them by their score. Exclude those students who have never completed an assignment.




Open Mysql and use the code below to try this question by yourself.
-------------------------------
CREATE DATABASE FH;
USE FH;


drop table if exists Grades;
drop table if exists Assignments;
drop table if exists Students;
drop table if exists Teachers;


create table Teachers (
  id int primary key,
  name varchar(16) not null,
  classroom int not null
);


create table Students (
  id int primary key,
  name varchar(16),
  primary_teacher_id int,
  FOREIGN

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式

w', 4),
  (11, 'Kim', 4);
  
insert into Assignments values(1, 4), (2, 8);


insert into Grades values
  (1, 1, 100), (1, 2, 50),
  (2, 1, 100), (2, 2, 100),
  (3, 1, 40), (3, 2, 8),
  (4, 1, 80), (4, 2, 81),
  (5, 1, 30), (5, 2, 60),
  (6, 2, 90),
  (9, 1, 65), (9, 2, 65),
  (10, 1, 85);
----------------------------------

. .и


求大米,谢谢!

面过了吗？Karat 真的好难受，求攻略

lz面过了吗

眼仁褐黄的竹笋 发表于 2024-11-15 00:12
lz面过了吗

没哈哈哈哈哈哈

匿名用户 发表于 2024-11-11 18:32
面过了吗？Karat 真的好难受，求攻略

没哈哈哈哈