Skip to content

Instantly share code, notes, and snippets.

@HyunwooMoon-developer

HyunwooMoon-developer/Relationship and schema design

Created January 11, 2021 04:50
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save HyunwooMoon-developer/91a104bb95a7027833e37c1386cc9b06 to your computer and use it in GitHub Desktop.
Save HyunwooMoon-developer/91a104bb95a7027833e37c1386cc9b06 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Relationship and schema design
How many people work in the Sales department?
A) 4
List the names of all employees assigned to the 'Plan Christmas party' project.
A) 'Toby Flenderson'
List the names of employees from the Warehouse department that are assigned to the 'Watch paint dry' project.
A) N/A
Which projects are the Sales department employees assigned to?
A) 'Watch paint dry'
List only the managers that are assigned to the 'Watch paint dry' project.
A) 'Jin Halpert'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment