Activity
streaming activity table questions_multiple questions
streaming activity table questions_multiple questions
Generate a report with all dates (recursive cte)
Generate a report with all dates (recursive cte)
Screening Interview questions_multiple questions
Screening Interview questions_multiple questions
Given a table Sales that records transactions_multiple questions
Given a table Sales that records transactions_multiple questions
customers who have placed at least two orders and order value more th…
customers who have placed at least two orders and order value more th…
shift schedule in a comma-separated format for each date
shift schedule in a comma-separated format for each date
column with comma-separated product categories into individual rows
column with comma-separated product categories into individual rows
customers who had overlapping bookings at different hotels
customers who had overlapping bookings at different hotels
conditional aggregation find high value orders and low value orders
conditional aggregation find high value orders and low value orders
find customers who have booked at least three consecutive seats for t…
find customers who have booked at least three consecutive seats for t…
identify customers who have viewed the same product for more than 3 c…
identify customers who have viewed the same product for more than 3 c…
find the longest sequence of consecutive days a customer placed orders
find the longest sequence of consecutive days a customer placed orders
find the longest sequence of consecutive days a customer placed orders
find the longest sequence of consecutive days a customer placed orders
average review rating and top performing products
average review rating and top performing products
most streamed songs overall, regardless of the subscription type
most streamed songs overall, regardless of the subscription type
calculate the average subscription duration, subscription gap and the…
calculate the average subscription duration, subscription gap and the…
generate a report where you transform the data in the given format (s…
generate a report where you transform the data in the given format (s…
calculate the balance for each account on a daily basis
calculate the balance for each account on a daily basis
Find the delivery drivers who have delivered all types of packages av…
Find the delivery drivers who have delivered all types of packages av…
find the highest SaleAmount for each ProductID using correlated sub q…
find the highest SaleAmount for each ProductID using correlated sub q…
find all flights where at least two passengers have confirmed reserva…
find all flights where at least two passengers have confirmed reserva…
find all pairs of cities where the distance between them is mutual
find all pairs of cities where the distance between them is mutual
Find Customers with Consecutive Purchases
Find Customers with Consecutive Purchases
find the top 2 products that generate the most revenue per unique user
find the top 2 products that generate the most revenue per unique user
find customers who made more than 3 transactions within any 1-hour wi…
find customers who made more than 3 transactions within any 1-hour wi…