SQL vs No SQL

This is a classic question which arises in system design interviews and also practical distributed systems. Should I use sql or no sql for a particualr database. Looking at enginering blogs of tech companies like youtube they use a hybrid sql and nosql solutions. Can anyone give me a link or reason on how for which component are we deciding which database to use. Some specific questions suppouse you want to design tinyurl do you use sql or no sql, I would say no sql because we are not joining and it is easier to shard, but there are sql shardung solutions also availiable. What about designing a scoreboard for leetcode again we can use either.