365 Days of Daily Coding: Day 66

Today was a fairly productive day as in I did things that I intended to do.

I solved an easy sql challenge. Unlike other challenges, I had to use FULL OUTER JOIN and a function called COALESCE. The function helps to concatenate strings from different cells and return whatever specified values incase the cells are empty. This link here provides a clearer uses of the function.

SELECT COUNT(COALESCE(a.actor_id,b.actor_id)) as counts
FROM actor_movie a
FULL OUTER JOIN actor_tv b
ON a.actor_id = b.actor_id;