I've recently started learning SQL, and your tutorials have been incredibly helpful. Your clear explanations and practical examples make it so much easier to understand the concepts. I truly appreciate the time and effort you put into creating these resources. Thank you !!!
@techTFQ
8 күн бұрын
Thank you ❤️ So glad to know it
@mrbartuss1
8 күн бұрын
Another solution for Problem 1. It seems we can use GROUP BY ROLLUP: SELECT EXTRACT(YEAR FROM start_timestamp) AS year, EXTRACT(MONTH FROM start_timestamp) AS month, SUM(total_paid) AS revenue FROM rental GROUP BY ROLLUP (year, month) ORDER BY year ASC, month ASC;
@cristianoronaldo7476
8 күн бұрын
Once again very informative thanks bro
@techTFQ
8 күн бұрын
Thank you 🙏
@luckyqueen7540
8 күн бұрын
Can you do crosstab video for multiple columns.. I have seen for three column. Can you please do for multiple columns
@setusrivatsa2563
8 күн бұрын
Beautiful vedio as always. Dear sir, can you please post in future about query Optimization techniques, explain analyse etc.
@techTFQ
8 күн бұрын
Thank you and yes I’ll cover performance tuning soon
@sheebaparveen8408
8 күн бұрын
Thanks for this informative video❤
@techTFQ
8 күн бұрын
Thank you ☺️
@PAAOMahesh
7 күн бұрын
Thanks for clear cut explaination ,Some new things i have learnt today from you,even more, i have learnt things that could save my time.
@babag5324
8 күн бұрын
The explanation u r providimg im ur every video is really superb, thank you 😊
@techTFQ
8 күн бұрын
Thank you 🙏
@AbdelkrimJa
8 күн бұрын
I appreciate the why ho you explain and resolve problems step by step !!! Many thank's
@chuksifeanyi992
8 күн бұрын
Thank you so much for this informative video. I recently started following your KZitem page, pls I want to ask at what level of my learning SQL should I start applying for Jobs and where can I get these remote jobs
@chuphal_himanshu
5 күн бұрын
Hi Thoufiq, like always this video also have been very easy to learn. Your explanation is very simple and easy to understand. I have learned SQL from your bootcamp and it was very smooth. i have done many case studies but I don't know how to share them on github properly. I have done your case studies but don't know hot to upload the data and my sql statements on github. It would be really very helpful if you could make a video about that.
@garimasharma052
8 күн бұрын
Great videos. But why did you hide other videos?
@techTFQ
8 күн бұрын
Some issue with KZitem, Wasn’t able to upload previous videos
@shubhamsoni174
6 күн бұрын
For those doing it in Mysql alternate soln for question 5 as grouping sets does not work in Mysql: SELECT EXTRACT(YEAR FROM start_timestamp) AS year, EXTRACT(MONTH FROM start_timestamp) AS month, SUM(total_paid) AS revenue FROM rental GROUP BY EXTRACT(YEAR FROM start_timestamp), EXTRACT(MONTH FROM start_timestamp) WITH ROLLUP ORDER BY year, month;
@shashankgupta9351
2 күн бұрын
Hi sir, videos sound is not coming properly, more sound in left earbud and less in rights
@nilabja2974
8 күн бұрын
Amazing learnt from you. Very nice.
@nandinipundipandu6163
5 күн бұрын
hello sir! i have a doubt regarding VIEW WITH ENCRYPTION. i created a view with encrption in MS SQL & when i right click on the encrypted view in object explorer i can still see the script of SELECT, INSERT, UPDATE,DELETE statements & also DROP VIEW option .I just wanna know that the other users are able to see those scripts & able to DROP the view???? please reply ASAP sir
@JimKitty-p6z
8 күн бұрын
568 Schmidt Bypass
@Alexpudow
7 күн бұрын
select extract(year from start_timestamp) as year ,extract(month from start_timestamp) as month ,sum(total_paid) as revenue from rental group by 1,2 union select extract(year from start_timestamp) as year ,nullif(0,0) as month ,sum(total_paid) as revenue from rental group by 1 union select nullif(0,0) as year ,nullif(0,0) as month ,sum(total_paid) as revenue from rental order by 1,2
Пікірлер: 28