Відео

with final as (select coalesce(order_id - lag(order_id) over (partition by id order by id),0) as diff , row_number() over (partition by id order by id) as row_num from input_table) select row_num as Order_id from final where diff=2

select month, sum(if(category="electronics",amount,null)) as electronics, sum(if(category="clothing",amount,null)) as clothing from sales_data group by 1 order by 1;

select student_name, sum(marks) as marks from ( select *, dense_rank() over(partition by student_name order by marks desc) as rnk from students ) as m where rnk <3 group by 1

Informative.

WITH RECURSIVE CTE AS ( SELECT MIN(ORDER_ID) AS cnt FROM orders UNION SELECT cnt+1 FROM cte WHERE cnt < (SELECT max(order_id) FROM orders) ) SELECT cnt AS order_id FROM cte WHERE cnt NOT IN (SELECT order_id FROM orders)

select month, sum(case when category = 'clothing' then amount end )as clothing, sum(case when category = 'electronics' then amount end )as electronics from sales_data group by month

SELECT * FROM SALES_DATA SELECT MONTH,MAX(CASE WHEN CATEGORY='ELECTRONICS'THEN AMOUNT END) AS ELECTRONICS ,MAX(CASE WHEN CATEGORY='CLOTHING' THEN AMOUNT END) AS CLOTHING FROM SALES_DATA GROUP BY MONTH ORDER BY MONTH

plss dnt stop making videos

Hi, In first question while finding the top 3 employees within each department, dense_rank() would be appropriate one because it will handle tie values without skipping the ranking rather than row_number IMO. Thank you for the constant motivation through SQL Questions ! Looking for more ...

Without using crosstab, can do with group by, will the company accept it

fantastic