-3
\$\begingroup\$

https://docs.google.com/spreadsheets/d/1en6LbysQeo0Yq1_3fVIJaUcwbKn8mKwN/edit#gid=698199102

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'
New contributor
Nicholas Hansen-Feruch is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.
\$\endgroup\$
1
  • 2
    \$\begingroup\$ Welcome to Code Review! Per Site policy please edit to include all of the prompts and SQL queries so they can be reviewed. Links to code hosted on third-party sites are permissible, but the most relevant excerpts must be embedded in the question itself. A stack snippet could also be used to embed the code. \$\endgroup\$ Aug 5 at 21:34

0

Browse other questions tagged or ask your own question.