🚩🅸🅽🆃🆁🅴🆅🅸🅴🆆 🅴🆇🅿🅴🆁🅸🅴🅽🅲🅴- 𝑻𝒆𝒏𝒂𝒏* (🆂🆃🅰🆁🆃🆄🅿)-1 ✏️ There are a total of 4 rounds:  💡 Lead Technical (Round 1)-Virtual  💡 Manager Interview (Round 2)-Inperson  💡 Director Interview (Round 3)-Inperson  💡 HR Interview (Round 4)-Inperson Result : Reached HR Round but No Offer Letter Released Lesson Learned : Need to better prepare for HR discussions 𝐑𝐨𝐮𝐧𝐝-𝟏 ----------------------------------🆂🆀🅻------------------------------------------- Question-1: Given the data for products over several days:  📌 Write a SQL query to get Calculate the difference in quantity for each product compared to the previous day.  📌 Write a sql Query Identify any two days where the quantity was lower compared to other days for each product in the following data: Product Day Quantity A 1 10 A 2 6 A 3 21 A 4 9 A 5 19 B 1 12 B 2 18 B 3 3 B 4 6 B 5 23  📌 Write a SQL Query to Employee name & man...

  𝗗𝗮𝘁𝗮 𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴 𝗝𝗼𝘂𝗿𝗻𝗲𝘆: 📌 𝗗𝗔𝗬 𝟱𝟳/𝟵𝟬 📢 𝗗𝗮𝘁𝗮𝗘𝗻𝗴𝗶𝗻𝗲𝗲𝗿𝗶𝗻𝗴--𝗣𝘆𝘁𝗵𝗼𝗻 🚩𝗤𝘂𝗲𝘀𝘁𝗶𝗼𝗻 🚀 ''' 𝘄𝗶𝗹𝗹 𝗵𝗮𝘃𝗲 𝗮 𝗹𝗶𝘀𝘁 𝗮𝗻𝗱 𝘄𝗲 𝘄𝗶𝗹𝗹 𝘀𝗼𝗿𝘁 𝗶𝘁 𝗶𝗻 𝗱𝗲𝘀𝗰𝗲𝗻𝗱𝗶𝗻𝗴 𝗼𝗿𝗱𝗲𝗿  ''' ---------------------------------------------------------------------------- 📌𝗔𝗽𝗽𝗿𝗼𝗮𝗰𝗵 𝟭 # sorting in descending #Sort the list without using the sort function def sorting(l1):   for i in range(0, len(l1)):     for j in range(i+1, len(l1)):       if l1[i] <= l1[j]:         l1[i], l1[j] = l1[j], l1[i]   return l1    

  Kafka Eco System Minimize image Edit image Delete image 📌𝗧𝗼𝗽𝗶𝗰𝘀: Minimize image Edit image Delete image Topics 👉🏼A stream of messages belonging to a particular category is called a Topic. 👉🏼Its is a logical feed name where to which records are published(Similar to Table in DB ) 👉🏼Unique identification of table is called name of the topic - can not be duplicated 👉🏼A topic is a storage mechanism for a sequence of events 👉🏼E vents are immutable 👉🏼keep events in the same order as they occur in time. So, each new event is always added to the end of the Message.  2. 📌𝗣𝗔𝗥𝗧𝗜𝗧𝗜𝗢𝗡𝗦: 👉🏼Topics are split into partition 👉🏼All the messages within a partition are ordered and immutable 👉🏼All the messages within the partition has a unique ID associated is called OFFSET. 👉🏼Kafka uses topic partitioning to improve scalability. 👉🏼 Kafka guarantees the order of the events within the same topic partition.  However, by default, it does not guarantee the ...