Skip to content

Instantly share code, notes, and snippets.

@QuocCao-dev

QuocCao-dev/SQL-Assessment-1.md

Created November 27, 2022 04:08
Show Gist options
  • Save QuocCao-dev/575bded0a1b6ccbcb4b85d2233a26f29 to your computer and use it in GitHub Desktop.
Save QuocCao-dev/575bded0a1b6ccbcb4b85d2233a26f29 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
SQL-Assessment-1.md

COMPLETE THE FOLLOWING TASKS!

  1. Return the customer IDs of customers who have spent at least $110 with the staff member who has an ID of 2. The answer should be customers 187 and 148.

  2. How many films begin with the letter J? The answer should be 20.

  3. What customer has the highest customer ID number whose name starts with an 'E' and has an address ID lower than 500? The answer is Eddie Tomlin

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment