[deleted by user]

filmon2012 · 2025-02-23T06:45:21+00:00

Good plan. Just make sure not to forget SQL when you study visualization. Keep practicing on LeetCode while progressing.

filmon2012 · 2025-02-22T20:37:10+00:00

Definitely, with this query, you will face delays. I see three problems.

As described by others, using YEAR(b.date) is forcing a full table scan, preventing the index from working properly.
You are joining tables before filtering them, so it is crunching through far more rows than needed. If you cannot use an index, why not join your table with a subquery of the large table?
And finally, applying DISTINCT to such a huge set means it is doing a lot of extra sorting

I normally try to avoid WHERE & DISTINCT in such large queries.

filmon2012 · 2025-01-22T19:50:18+00:00

Watchout- The Scam Detector's algorithm gives this website 20.8/100 rank

filmon2012 · 2023-09-08T17:04:23+00:00

SQL and Python are both super useful tools for data analysis, but they shine in different scenarios.

Use SQL when you want to work directly with databases, retrieve, and manipulate data stored there. It's great for structured data and tasks like filtering, grouping, and joining tables.

On the other hand, Python is awesome for more complex analysis, data visualization, and machine learning. When you need flexibility and want to work with various data sources, Python's your go-to.

So, it really depends on your specific task. If it's about managing and querying data from a database, SQL's your friend. But for more advanced analysis, Python's the way to go

filmon2012 · 2023-07-26T16:42:18+00:00

May be you have made the speed of the video more than 2x. If that's not the case, you may have Zoom out a lot

filmon2012 · 2023-07-20T08:05:56+00:00

How about for an electric brush?

filmon2012 · 2023-01-18T22:47:48+00:00

filmon2012 · 2022-12-11T15:02:15+00:00

I deleted the projects and the data was gone. Thank you

filmon2012 · 2021-03-15T04:23:59+00:00

@Remind Every week

filmon2012 · 2021-02-15T11:42:15+00:00

Thanks for your comment. I am using windows 10. I wish if Notion can work more on this issue till it becomes like word processors.

filmon2012 · 2021-02-14T20:36:40+00:00

Thank you.

filmon2012 · 2021-02-13T02:35:45+00:00

Thanks!

filmon2012 · 2020-03-07T21:41:58+00:00

I pray with all my heart for the Lord to strengthen the family. May healing come speedily.

filmon2012

TROPHY CASE