Thank you, that was great

Bravo Sir! 👏 What a valuable mini-project using SQL! 🎉 Comments: 1. MySQL: No need to specify INNER word in MySQL syntax (i.e. JOIN means INNER JOIN) 2. Type of JOINS: In the real world; INNER JOIN & LEFT JOIN are the most frequently used types of joins 3. Data Cleansing: Handling missing data (i.e. NULLs) using COALESCE (Column_ name, a specified value) function is a MUST. Congrats sir for such informative SQL demo! 🎉🎉🎉🎉

where you add scrollbar?

Thank you bro very important Project

bro you are using older modules like pdfFileReader. This moduile is not available in today's time. and if available then particular functionality isn't working

Sir, email automation not working...

Helpful video thanks. BUT get rid of the annoying and distracting music.

using SUM() over partition was briliant, learnt something new today! thanks a lot man!

Great video, thank you. I can't stand SSMS anymore - so NOT user friendly. VS Code is King!

Thank you so much Brother

It would be helpful if you demonstrated how to link to other files in the same repository from this notebook.

The first two answers are incorrect and do NOT SHOW A RUNNING TOTAL IN ACCORDANCE TO ASCENDING MONTHS (just look at the answers). Since the Month field is a VARCHAR, you've ordered the running total alphabetically ('Apr' first month, 'Sep' last month). A solution as follows could be used to overcome that: SELECT *, SUM(Revenue) OVER (ORDER BY CASE WHEN Month= 'Jan' THEN 01 WHEN Month= 'Feb' THEN 02 WHEN Month= 'Mar' THEN 03 WHEN Month= 'Apr' THEN 04 WHEN Month= 'May' THEN 05 WHEN Month= 'Jun' THEN 06 WHEN Month= 'Jul' THEN 07 WHEN Month= 'Aug' THEN 08 WHEN Month= 'Sep' THEN 09 WHEN Month= 'Oct' THEN 10 WHEN Month= 'Nov' THEN 11 WHEN Month= 'Dec' THEN 12 END ASC) FROM Revenue

DROP TABLE IF EXISTS Employee; CREATE TABLE Employee ( EmployeeID INT PRIMARY KEY, FirstName VARCHAR(50) NOT NULL, LastName VARCHAR(50) NOT NULL, HireDate DATE NOT NULL, Salary DECIMAL(10,2) NOT NULL ); INSERT INTO Employee (EmployeeID, FirstName, LastName, HireDate, Salary) VALUES (1, 'John', 'Smith', '2019-01-01', 75000), (2, 'Jane', 'Doc', '2019-02-15', 80000), (3, 'Bob', 'Johnson', '2019-03-30', 90000), (4, 'Sarah', 'Lee', '2019-04-15', 85000), (5, 'Mike', 'Brown', '2019-05-01', 95000), (6, 'Lisa', 'Davis', '2019-06-15', 100000), (7, 'Tom', 'Wilson', '2019-07-30', 110000), (8, 'Ann', 'Jones', '2019-08-15', 120000), (9, 'Peter', 'Parker', '2019-09-01', 125000), (10, 'Mary', 'Kim', '2019-10-15', 130000); DROP TABLE IF EXISTS Revenue; CREATE TABLE Revenue ( Year INT NOT NULL, Month VARCHAR(3) NOT NULL, Revenue DECIMAL(10,2) NOT NULL); INSERT INTO Revenue (Year, Month, Revenue) VALUES (2021, 'Jan', 50000), (2021, 'Feb', 75000), (2021, 'Mar', 90000), (2021, 'Apr', 65000), (2021, 'May', 80000), (2021, 'Jun', 95000), (2021, 'Jul', 110000), (2021, 'Aug', 120000), (2021, 'Sep', 100000), (2021, 'Oct', 90000), (2021, 'Νον', 75000), (2021, 'Dec', 60000);

Great video, Big Help.. Thank you. Could you please provide the hex code for Background color and Green one too.

Seu video me inspirou para fazer um dashboard

not working with sql 2014 ?

How do we do the same thing for the walking time?

Nice trick, but it doesn't work when you have columns without data (i.e. sales for Aug/Sep/Oct/Noc/Dec when you are still in July) that are forced with "Show items with no data"

thankk you for this. I was searching for this. now i need to do something else per row get the absolute varainace/sum( total absolute variance column) how would you do that?

The demos of this look nice but I've tried it on UK geojsons and haven't get it working.

Thank you so much for sharing your knowledge and experience.

how to open a epxlorer window of a certain size in a certain location?

so helpful thanks boss

Pls continue

your video helped me, thanks bro!

I am in tension how to achieve total and subtotal in sql query. But this video make me free from tension. I believe everything is possible in sql. Thanks

Has anyone tried this in 2024? I've tried to troubleshoot this for 30 mins and mine still isn't working >.< I think to do with google not allowing me to login using the SMTP? Thanks for any help.

How can you make the table you added be more dynamic for all employees? Will this work on Groups?

Sorry, but how did you manage to insert line breaks in text inside the buttons?

Great Workaround. so simple. I have another challenge on advanced filtering and can't find a solution. I want to filter on certain phrases: e.g. "today is a great day" and "today is the best day". How can I filter on exactly these phrases if they're a part of a longer text block?

Dear sir you show google sign up without phone number automation

This was helpful and very well explained. Thank you for sharing this video.

thank you man!

OMG!! Rockstar! Thank you sir - saved a BIG headache! How stupidly obvious-but-not-intuitive MS.

Nice explanation in step by step procedure. Thank you!

bro, you are the Best, thanks

Very good content, nice and simple. I have a question regarding the email automation. If I want to send automatically every week an email, do I have to run the script or can I "program it" somehow for this to be sent without me running the script? Thanks in advance! :D

very helpful, thanks a lot.

Hi, Can we use this method without premium subscritpion? Is there any other ways?

Thanku so much ...i have resolved successfully.... thnaks a lot

Storing keys as plaintext is a good start but using environment variables is a bit nicer because you can upload your code and run it in public

Real nice tutorial. Crisp and to the point.

Matadorjob Very Bad Service And Customer Support Bad Service

can you please tell how to show a number in K which is in thousands? For eg. 989,575.98 should be shown as 990K.

Great tutorial and thanks for sharing! Is it also possible for you to share the example data file?

thank you blud, you did what other pros in microsoft community didn't do. respect

Will this run, even if I didn't turn on the pc?

Solution 1 doesn't work, look at September column, it's still wider than others due to its header longer than 0000 value. It's easy to solve by adding more zeroes in that case where we have constant amount of 12 columns only, that' fine, however what it is not useful for tables with huge number of potential columns which may appear depending on page or visual filtering, when we don't exactly know, which header can be the largest one...

Great! Thanks a lot🙏

So aesthetic ngl 🥺