@ishwarkoki

ishwar kokkili

@ishwarkokiJoined June 2023

Solving Engineering problems through tech and Computer Science

About

Nothing here yet.

Available for

Nothing here yet.

ishwar kokkili's blogs

DataVerse by Ishishwarkoki.hashnode.dev12 posts

Articles Comments

Recently published

IKishwar kokkiliishwarkoki.hashnode.devNov 25, 2023 · 3 min read

SQL Problem of the day #11

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...

IKishwar kokkiliishwarkoki.hashnode.devNov 23, 2023 · 2 min read

SQL Problem of the day #10

IKishwar kokkiliishwarkoki.hashnode.devNov 22, 2023 · 2 min read

SQL Problem of the day #9

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...

IKishwar kokkiliishwarkoki.hashnode.devNov 21, 2023 · 2 min read

SQL Problem of the day #8

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...

IKishwar kokkiliishwarkoki.hashnode.devNov 20, 2023 · 3 min read

SQL Problem of the day #7

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...

ishwar kokkili

About

Available for

ishwar kokkili's blogs

Recently published

SQL Problem of the day #11

SQL Problem of the day #10

SQL Problem of the day #9

SQL Problem of the day #8

SQL Problem of the day #7

Search Hashnode

ishwar kokkili

About

Available for

ishwar kokkili's blogs

Recently published

SQL Problem of the day #11

SQL Problem of the day #10

SQL Problem of the day #9

SQL Problem of the day #8

SQL Problem of the day #7