Common Table Expressions vs Subqueries vs Views vs Temp Tables for data engineers

The data for today's video is available here: https://github.com/EcZachly/video-game-training-sql Common Table Expression and subquery is a very common debate! The temporary table crowd is pretty loud too! Don't forget the materialized view crowd ! Check out https://dataexpert.io for my DataExpert community!