SQL Case Study - Bike Rental Shop | Practice SQL Queries

[@UrviKuvera]

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]

Thank you ❤️ So glad to know it

[@mrbartuss1]

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;

[@kamalprajapati9955]

Great tutorial

[@cristianoronaldo7476]

Once again very informative thanks bro

[@techTFQ]

Thank you 🙏

[@setusrivatsa2563]

Beautiful vedio as always. Dear sir, can you please post in future about query Optimization techniques, explain analyse etc.

[@techTFQ]

Thank you and yes I’ll cover performance tuning soon

[@luckyqueen7540]

Can you do crosstab video for multiple columns.. I have seen for three column. Can you please do for multiple columns

[@sheebaparveen8408]

Thanks for this informative video❤

[@techTFQ]

Thank you ☺️

[@PAAOMahesh]

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]

The explanation u r providimg im ur every video is really superb, thank you 😊

[@techTFQ]

Thank you 🙏

[@AbdelkrimJa]

I appreciate the why ho you explain and resolve problems step by step !!! Many thank's

[@chuksifeanyi992]

Thank you so much for this informative video. I recently started following your KZbin 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]

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]

Great videos. But why did you hide other videos?

[@techTFQ]

Some issue with KZbin, Wasn’t able to upload previous videos

[@shubhamsoni174]

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;

[@nilabja2974]

Amazing learnt from you. Very nice.

[@shashankgupta9351]

Hi sir, videos sound is not coming properly, more sound in left earbud and less in rights

[@nandinipundipandu6163]

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]

568 Schmidt Bypass

[@kyliegujones3542]

Clark Maria Gonzalez Mark Miller Ronald

[@victorslawman9778]

Davis Michael Lewis Thomas Brown Anthony

[@DavidLee-b9k]

Miller John Brown Thomas Brown Timothy

[@MaltzDora]

Hall Linda Lopez Donald Allen Christopher

[@mollyesebargeman7395]

Harris Donald Lopez Carol Lewis Scott

[@pragatheeswaranm4604]

Not audible

[@нинавасильева-щ3е]

Jackson John Lewis Patricia Young Matthew

[@YARAKalwei]

Hall Maria Lee George Davis Mark