@ishwarkoki
Solving Engineering problems through tech and Computer Science
Nothing here yet.
Nothing here yet.
Nov 25, 2023 · 3 min read · Problem statement: There is a queue of people waiting to board a bus. However, the bus has a weight limit of 1000 kilograms, so there may be some people who cannot board. Write a solution to find the person_name of the last person that can fit on the...
Join discussion
Nov 22, 2023 · 2 min read · Given a table of tweet data over a specified time period, calculate the 3-day rolling average of tweets for each user. Output the user ID, tweet date, and rolling averages rounded to 2 decimal places. Notes: A rolling average, also known as a moving...
Join discussion
Nov 21, 2023 · 2 min read · Assume you are given the table below on Uber transactions made by users. Write a query to obtain the third transaction of every user. Output the user ID, spend, and transaction date. transactions Table: Column NameType user_idinteger spenddec...
Join discussion
Nov 20, 2023 · 3 min read · Problem Statement: Replace the null value with the previous value. NOTE: null values are one thing that you have to deal with in your career right from the day you start working. So, better be equipped. Table creation and data insertion script: CREAT...
Join discussion
