Streaming Codealong Practices - Daniel version

select *
from amazon

select *
from disney

select *
from netflix

select *, 'amazon' AS service
from amazon
UNION
select *, 'hulu' AS service
from hulu
UNION
select *, 'netflix' AS service
from netflix
UNION
select *, 'disney' AS service
from disney

WITH service_data AS (
    select *, 'amazon' AS service
    from amazon
    UNION
    select *, 'hulu' AS service
    from hulu
    UNION
    select *, 'netflix' AS service
    from netflix
    UNION
    select *, 'disney' AS service
    from disney
)

select *
from service_data as sd
left join genres as g
	on sd.title = g.film