Awesome tutorial on cte, concise and crystal clear. It was a bit frustrating for me working in sql and not being able to chain the results or save the objects to be reused. From now on, after your cte tutorial, it will be more funny and pleasant working with sql as never before. For greater readibility, I would like to suggest you to consider some formatting or beautifying your code, specially your inner inner query/the derived table from the first join Keep it up Sir, you are a legend!
In PostgreSql, We can do select c.cust_id, concat(c.cust_first_name, ' ', c.cust_last_name) as full_name, SUM(os.amount * os.quantity) filter(where date_part('year', o."date") = '2020') sale_2020, SUM(os.amount * os.quantity) filter(where date_part('year', o."date") = '2021') sale_2021, SUM(os.amount * os.quantity) filter(where date_part('year', o."date") = '2022') sale_2022 from customer c join orders o on o.cust_id = c.cust_id join order_summary os on os.orderid = o.order_id group by 1,2 order by 1
Bro can i use mongo db campus for data analytics jobss or i have to do it with other language means who will get more preferrence And one more ques ... Are you doing any job r8 now ??
Awesome tutorial on cte, concise and crystal clear. It was a bit frustrating for me working in sql and not being able to chain the results or save the objects to be reused. From now on, after your cte tutorial, it will be more funny and pleasant working with sql as never before.
For greater readibility, I would like to suggest you to consider some formatting or beautifying your code, specially your inner inner query/the derived table from the first join
Keep it up Sir, you are a legend!
Patiently and Detailed Explanation. Please make a video on Dynamic SQL as well
Thanks a lot
@@AshutoshKumaryt Please make videos on Stored Procedures, Triggers, ETL also
you are one of the best teachers on youtube just a request to make videos in hindi as well
thanks
In PostgreSql, We can do
select
c.cust_id,
concat(c.cust_first_name, ' ', c.cust_last_name) as full_name,
SUM(os.amount * os.quantity) filter(where date_part('year', o."date") = '2020') sale_2020,
SUM(os.amount * os.quantity) filter(where date_part('year', o."date") = '2021') sale_2021,
SUM(os.amount * os.quantity) filter(where date_part('year', o."date") = '2022') sale_2022
from customer c
join orders o on o.cust_id = c.cust_id
join order_summary os on os.orderid = o.order_id
group by 1,2
order by 1
Did u know we love ur teaching and content
Thanks
Thank u. Pls make more videos
Thank you
Can you provide video for indexing as well
Teaching and content quality is best, but less views Keep doing it bro
thanks
To the point! Thanks bro
Thank you
@@AshutoshKumaryt Expecting a detailed video on UNION & UNION ALL
@@sabarinathan594 noted
sir me Excel, SQL and Power Bi sikna complete kiya he lekin job nahi mil rahi he 😢 keya karo
keep applying one day you will get success
Hello Ashutosh,
I want to know whether the Syntax of this advance SQL tutorials will be same for MySQL as well?
Please reply.
Thanks in Advance.
Yes
Bro can i use mongo db campus for data analytics jobss or i have to do it with other language means who will get more preferrence
And one more ques ...
Are you doing any job r8 now ??
Bhai ne into into mei jhol kar ditta
Jara detail mein btao bhai kya jhol ho gya