Skip to content

Activity

streaming activity table questions_multiple questions

vishnu-t-rpushed 1 commit to main • 2eb0285…0f18861 • 
on Apr 26

detect back to back login

vishnu-t-rpushed 1 commit to main • a8bed9e…2eb0285 • 
on Apr 26

Generate a report with all dates (recursive cte)

vishnu-t-rpushed 1 commit to main • 2f6fa77…a8bed9e • 
on Apr 26

Screening Interview questions_multiple questions

vishnu-t-rpushed 1 commit to main • fcdfe25…2f6fa77 • 
on Apr 20

Same Score in Every Subject

vishnu-t-rpushed 1 commit to main • 29956b1…fcdfe25 • 
on Apr 20

Given a table Sales that records transactions_multiple questions

vishnu-t-rpushed 1 commit to main • 48eba96…29956b1 • 
on Apr 20

customers who have placed at least two orders and order value more th…

vishnu-t-rpushed 1 commit to main • cad6594…48eba96 • 
on Apr 16

detecting Product Sales Anomalies

vishnu-t-rpushed 1 commit to main • 7e298f0…cad6594 • 
on Apr 16

shift schedule in a comma-separated format for each date

vishnu-t-rpushed 1 commit to main • 1b5071d…7e298f0 • 
on Apr 12

column with comma-separated product categories into individual rows

vishnu-t-rpushed 1 commit to main • d4f1632…1b5071d • 
on Apr 12

customers who had overlapping bookings at different hotels

vishnu-t-rpushed 1 commit to main • 42e2979…d4f1632 • 
on Feb 25

find the top spending customer

vishnu-t-rpushed 1 commit to main • ab6a01d…42e2979 • 
on Feb 22

conditional aggregation find high value orders and low value orders

vishnu-t-rpushed 1 commit to main • 0af9334…ab6a01d • 
on Feb 22

find customers who have booked at least three consecutive seats for t…

vishnu-t-rpushed 1 commit to main • 5f0162e…0af9334 • 
on Feb 20

identify customers who have viewed the same product for more than 3 c…

vishnu-t-rpushed 1 commit to main • f9c229e…5f0162e • 
on Feb 20

find the longest sequence of consecutive days a customer placed orders

vishnu-t-rpushed 1 commit to main • 1fdce24…f9c229e • 
on Feb 15

find the longest sequence of consecutive days a customer placed orders

vishnu-t-rpushed 1 commit to main • 0ed945e…1fdce24 • 
on Feb 6

average review rating and top performing products

vishnu-t-rpushed 1 commit to main • 3b23843…0ed945e • 
on Jan 31

review rating for products

vishnu-t-rpushed 1 commit to main • cec35f6…3b23843 • 
on Jan 31

most streamed songs overall, regardless of the subscription type

vishnu-t-rpushed 1 commit to main • 0a42c15…cec35f6 • 
on Jan 30

calculate the average subscription duration, subscription gap and the…

vishnu-t-rpushed 1 commit to main • 8cbf51a…0a42c15 • 
on Jan 30

generate a report where you transform the data in the given format (s…

vishnu-t-rpushed 1 commit to main • 6355cff…8cbf51a • 
on Jan 29

calculate the balance for each account on a daily basis

vishnu-t-rpushed 1 commit to main • 53e9af8…6355cff • 
on Jan 29

Find the delivery drivers who have delivered all types of packages av…

vishnu-t-rpushed 1 commit to main • d6186a0…53e9af8 • 
on Jan 29

find the highest SaleAmount for each ProductID using correlated sub q…

vishnu-t-rpushed 1 commit to main • 1440aa4…d6186a0 • 
on Jan 26

find all flights where at least two passengers have confirmed reserva…

vishnu-t-rpushed 1 commit to main • 5f78a29…1440aa4 • 
on Jan 26

find all pairs of cities where the distance between them is mutual

vishnu-t-rpushed 1 commit to main • 9aa7fdb…5f78a29 • 
on Jan 5

Find Customers with Consecutive Purchases

vishnu-t-rpushed 1 commit to main • f3e5ba1…9aa7fdb • 
on Jan 5

find the top 2 products that generate the most revenue per unique user

vishnu-t-rpushed 1 commit to main • 91bc870…f3e5ba1 • 
on Jan 5

find customers who made more than 3 transactions within any 1-hour wi…

vishnu-t-rpushed 1 commit to main • 3068421…91bc870 • 
on Jan 2