Easy SQL Challenge: Using INNER JOIN

365 Days of Daily Coding: Day 45

I woke up extremely late today and I didn’t have much planned for the entire day. I was pretty much occupied reading posts and comments on the reddit group “wallstreetbets” and perhaps understand where this all is heading. Although that I wish those redditors hold until the “moon” but I worry about this being so detrimental and catastrophic that it may create a butterfly effect for a market crash. I guess that’s too extreme as a prediction but this has totally changed the possibility of any event no matter how absurd it may sound.

I have been wanting to learning to invest for some time and I must say that this frenzy episode has really expedited my interest in learning how to invest for long term. So I followed some social media channels and pages on value investing.

I solved an easy sql challenge today partly because I am feeling exhausted after my evening walk after days of procrasting. Might go for a morning walk tomorrow.

Easy SQL Challenge

SELECT name FROM
(SELECT c.name, COUNT(f.film_id) AS counts
FROM category c JOIN film_category f
ON c.category_id = f.category_id
GROUP BY c.category_id
ORDER BY counts DESC
LIMIT 1) AS k;

Karma

Leave a comment