Class 23 - Week 2 Exercises

[antonioalmeida]

Week 2 - Exercises

Please leave a comment below with your answers to Week 2's exercises.

How to share

Leave a comment below with the answers to all exercises.

For Exercises 1, 2

Upload your diagram as an image.

For Exercise 3 - Formula 1

1. Create a Gist here
2. Name it formula1.sql. Make sure it's public
3. Share the link to your Gist

For Exercise 4 - LinkedIn

Same as exercise 3, but name your file linkedin.sql

Remember: if you need to make changes, you can edit your Gist.

[antonioalmeida]

(example submission)

Exercise 1: Company

View solution


Exercise 2: Gardener

View solution


Exercise 3: Formula 1

https://gist.github.com/antonioalmeida/9990eeacfbc67eaea8a073fd918192d0

Exercise 4: LinkedIn

https://gist.github.com/antonioalmeida/23ba5300b973ee75ae60986e24819b3f

[sebdesalvador]

Solution 1: https://gist.github.com/sebdesalvador/e7fc35afbea7c9f15a0ba9fa5015bf5a

Solution 2: https://gist.github.com/sebdesalvador/b259ff1b6b2438483725130ae145515f

Solution 3: https://gist.github.com/sebdesalvador/5386f1d979cdf553bec4a5358be545a9

[nibishakajean]

All my answers are here: https://gist.github.com/nibishakajean/de35926c1fadfef5fac752c097d0ecac

• [X] _Done

[PolyannaMeira]

Exercise 1: Company

View solution


Exercise 2: Gardener

View solution


Exercise 3: Formula 1

https://gist.github.com/PolyannaMeira/3bf5659c504c4c41bf4992c03d67518a

Exercise 4: LinkedIn

View solution


https://gist.github.com/PolyannaMeira/170173f67ea403fd575c6cf6c090cafb

[Gemechis10]

Exercise 1 & 2 https://excalidraw.com/#json=wjwSDyQGf9Wn-hmpki5wS,50U17tuQufMI3YqKMnDGgA

EXERCISE 3 https://gist.github.com/Gemechis10/aa0759971eb8fe88d169df91fdc6e970

EXERCISE 4

[Smita81]

Exercise 1,2,3 & 4. https://gist.github.com/Smita81/8465e2f9e4535910ab730b4c3f565017

[stefan-000]

Exercise 1:

View Solution


Exercise 2:

View Solution


Exercise 3:

https://gist.github.com/stefan-000/953dec1bdccb7f8b0d75d05cfa53c473

Exercise 4:

https://gist.github.com/stefan-000/3606327423fcd74fb489907c1ec809b2

[juryp]

Exercise 3: Formula 1 https://gist.github.com/edinssa/34c7fa48924ddd7120707f0bfbd9c9ff

Exercise 4: Linkedin https://gist.github.com/juryp/1bda2b73f935a0685efe87cd1fa3e90c

[GKing3]

Exercise 1

Exercise 2

Exercise 3

https://gist.github.com/GKing3/93a5c944688b98541a6485c820f94fef