This is an interview quiz that I submitted. The spreadsheet contains the prompts (3 total), my answers, and the 3 tables as separate sheets in the workbook. Are my answers good?
Example code to fit the requirement
SELECT ACCOUNT_ID as "Account ID", HANDLE as Handle, LATEST_SUBSCRIPTION_LENGTH as "Subscription Length" FROM dim_acct INNER JOIN acct_subscription ON ACCOUNT_ID = SUBSCRIBER_ACCOUNT_ID WHERE AUTORENEW_FLAG = 1 AND SUBSCRIPTION_PROGRAMME = 'PlayStation Plus'