File metadata and controls Code Blame 141 lines (107 loc) · 4.45 KB Raw #--------------CREATING TABLES AND PRACTICE Subquery-----------------------------# CREATE ...

AND Cover.song_name = Album.song_name); In the SQL code, I used fully qualified column names because I’m directly comparing the two tables, not merely using the result set as a passive resource.

Find only the orders that took place in the same month and year as the first order, and then pull the average for each type of paper 'qty' in this month. WITH first_order AS( SELECT EXTRACT(YEAR FROM ...