注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
60 mins 2道题
一道coding一道database
都是地里没见过的题 (上传不了图片 粘文字吧)
Question 1:.
Packets are sent to different ports on a computer system based on the hash of their packet ID. The value of the hash is as given below:
Hash = mod (packet_id, numberOfPorts) where mod is the
modulus operator and takes the mod of first operand by second operand.
The ports are numbered from 0 to (number of ports) - 1, and a packet is initially sent to the port that has the port number equal to the hash of its packet ID. Each port requires t seconds to process an arriving packet. If a port is currently processing a packet, anhase events in May 2022. A purchase event has "buy" in the type field. The result should have the following columns: purchases.
• purchases - the total number of events of the "buy" type Only events of the type "buy" should be included in the report.
• Only events that occurred in May 2022 should be included in the report. |