新鲜唛啃吸 Mckinsey 24 NG SDE OA有新题，求加米！！

第一题SQL，第二题算法dfs，第三题Frontend，第四题写后端API

其中第三题感觉是题目的设置有问题，UI test跑不出来额，不知道其他朋友有没有这个问题


1.
write a query to print the name and the weather and the weather type for each plant that blooms in only one type of weather. the order of output does not matter.

Each row should contain  plant name, weather.type.

there are 2 tables

（tables省略）

2. A set of computers need to be connected using ethernet cables. Two computers are said to be connected if they have either a direct or indirect connection to each other via cables. An example of a direct connection would be a cable connecting computers 1 and 2. If computer 2 were then directly connected to computer 3, we would say that computers 1 and 3 are indirectly connected. A cable only connects two distinct computers. No two computers are connected by more than one cable.
Initially, some groups of computers are connected to each other. If some groups of computers are disconnected, one operation may be performed: remove the cable between any two computers and connect any other pair of computers with the cable. Determine the minimum number of operations to connect all the computers. Report -1 as the answer if it is not possible to connect all the computers.
Example:
comp_nodes = 4
comp_edges = 3
c from = [1 1 3]
C_to = [2

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

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

e location details. The object has the following schema:
*
* city: (String)
country: (String)
region: (String)
*
*
*
Complete the bestUniversityByCountry where given the name of a country as a parameter, return the name of the university with the highest rank in the country specified. If the country does not have a university within the data, return an empty string ("") instead.

Function Description
* Complete the function bestUniversityByCountry in the editor.
* bestUniversityByCountry has the following parameters: string country: name of the country whose universities have to be filtered
* Return string: the highest rated university or an empty string ('").

jitbanerjee4 发表于 2023-08-06 01:34:01
Anybody able to pass test cases for the frontend challenge?? It just don't work eve with correct cod

过不了 他自己的毛病

二摆舞 发表于 2023-08-03 18:26:35
之前我做过intern的，投了就发oa，全做上来也没有下一步，不过我是需要sponsor的，不需要的可能会不一样

了解谢谢～但是这次我看一是ng岗，二是投了有一两周后才收到oa的，不确定这是不是也是白嫖

第一题SQL要用哪些指令呀? 我都不会SQL也不会前端，第一题第三题直接挂啦。为什么做个OA要求懂的东西那么多？只有我一个人感觉像shi一样吗

可以问问楼主中间隐藏的内容么，积分差一点点。。。

全考啊天

楼主，请问一下第二题dfs那个，是看做一个无向图吗？

考得还挺全，不过也是白嫖oa，全做对了也未必有下一步，就当练手了吧

第三第四题一样，第三题也是手动测试没问题但 npm test 报错，瞅着像是测试脚本有问题。

yelv 发表于 2023-8-2 22:12
第一题SQL要用哪些指令呀? 我都不会SQL也不会前端，第一题第三题直接挂啦。为什么做个OA要求懂的东西那么多 ...

要学下嵌套 join(Nested join query), group by 和聚合函数，不算难但有点麻烦。

确实第三题直接没法跑. import jsdom直接报错了

二摆舞 发表于 2023-08-02 19:28:36
考得还挺全，不过也是白嫖oa，全做对了也未必有下一步，就当练手了吧

哪里看出是白嫖的啊？这些公司都不招ng吗？