Skip to content

Instantly share code, notes, and snippets.

@thecodecafe
Last active December 4, 2019 14:55
Show Gist options
  • Save thecodecafe/3b99ab89fc7abdfb7761fe2f0d954771 to your computer and use it in GitHub Desktop.
Save thecodecafe/3b99ab89fc7abdfb7761fe2f0d954771 to your computer and use it in GitHub Desktop.

Revisions

  1. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    35 minutes sprint
    45 minutes sprint

    # Algorithm
    Question
  2. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    45 minutes sprint
    35 minutes sprint

    # Algorithm
    Question
  3. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -17,8 +17,10 @@ Calculate the row sums of this triangle from the row index (starting at index 1)
    **Solution should by written in PHP**

    E.g.
    ```
    rowSumOddNumbers(1); // 1
    rowSumOddNumbers(2); // 3 + 5 = 8
    ```


    # Database
  4. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 2 additions and 0 deletions.
    2 changes: 2 additions & 0 deletions QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -13,7 +13,9 @@ Given the triangle of consecutive odd numbers:
    ```

    Calculate the row sums of this triangle from the row index (starting at index 1).

    **Solution should by written in PHP**

    E.g.
    rowSumOddNumbers(1); // 1
    rowSumOddNumbers(2); // 3 + 5 = 8
  5. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -13,7 +13,7 @@ Given the triangle of consecutive odd numbers:
    ```

    Calculate the row sums of this triangle from the row index (starting at index 1).
    *Solution should by written in PHP*
    **Solution should by written in PHP**
    E.g.
    rowSumOddNumbers(1); // 1
    rowSumOddNumbers(2); // 3 + 5 = 8
  6. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -13,7 +13,7 @@ Given the triangle of consecutive odd numbers:
    ```

    Calculate the row sums of this triangle from the row index (starting at index 1).

    *Solution should by written in PHP*
    E.g.
    rowSumOddNumbers(1); // 1
    rowSumOddNumbers(2); // 3 + 5 = 8
  7. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 1 addition and 0 deletions.
    1 change: 1 addition & 0 deletions QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -42,6 +42,7 @@ Example Result.

    # Frontend
    Todo list app
    NB: Focus on functionality not, how good it looks.
    - Add Todo
    - Remove Todo
    - Toggle completed status
  8. thecodecafe renamed this gist Dec 4, 2019. 1 changed file with 4 additions and 4 deletions.
    8 changes: 4 additions & 4 deletions Questions.md → QuestionsEmmanuel.md
    Original file line number Diff line number Diff line change
    @@ -1,5 +1,6 @@
    # Algorithm
    45 minutes sprint

    # Algorithm
    Question

    Given the triangle of consecutive odd numbers:
    @@ -29,7 +30,7 @@ Given a table with the following.
    | 1 | Jon | [email protected] | 3 |
    | 1 | peter | [email protected] | 3 |

    Write an SQL query that selects distinc emails where role id is equal to 3 or 1.
    Write an SQL query that selects distinct emails where role_id is equal to 3 or 1.

    Example Result.

    @@ -40,8 +41,7 @@ Example Result.
    | [email protected] |

    # Frontend

    Todo list app with ReactJS
    Todo list app
    - Add Todo
    - Remove Todo
    - Toggle completed status
  9. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion Questions.md
    Original file line number Diff line number Diff line change
    @@ -22,7 +22,7 @@ rowSumOddNumbers(2); // 3 + 5 = 8
    Given a table with the following.

    | id | name | email | role_id |
    |--------------------------------------------|
    |----|---------|------------------|----------|
    | 1 | Jon | [email protected] | 1 |
    | 2 | Peter | [email protected] | 1 |
    | 3 | Stanley | [email protected] | 1 |
  10. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 1 addition and 2 deletions.
    3 changes: 1 addition & 2 deletions Questions.md
    Original file line number Diff line number Diff line change
    @@ -21,7 +21,6 @@ rowSumOddNumbers(2); // 3 + 5 = 8
    # Database
    Given a table with the following.

    ----------------------------------------------
    | id | name | email | role_id |
    |--------------------------------------------|
    | 1 | Jon | [email protected] | 1 |
    @@ -33,7 +32,7 @@ Given a table with the following.
    Write an SQL query that selects distinc emails where role id is equal to 3 or 1.

    Example Result.
    --------------------

    | email |
    |------------------|
    | [email protected] |
  11. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 2 additions and 10 deletions.
    12 changes: 2 additions & 10 deletions Questions.md
    Original file line number Diff line number Diff line change
    @@ -23,30 +23,22 @@ Given a table with the following.

    ----------------------------------------------
    | id | name | email | role_id |
    ----------------------------------------------
    |--------------------------------------------|
    | 1 | Jon | [email protected] | 1 |
    ----------------------------------------------
    | 2 | Peter | [email protected] | 1 |
    ----------------------------------------------
    | 3 | Stanley | [email protected] | 1 |
    ----------------------------------------------
    | 1 | Jon | [email protected] | 3 |
    ----------------------------------------------
    | 1 | peter | [email protected] | 3 |
    ----------------------------------------------

    Write an SQL query that selects distinc emails where role id is equal to 3 or 1.

    Example Result.
    --------------------
    | email |
    --------------------
    |------------------|
    | [email protected] |
    --------------------
    | [email protected] |
    --------------------
    | [email protected] |
    --------------------

    # Frontend

  12. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 2 additions and 2 deletions.
    4 changes: 2 additions & 2 deletions Questions.md
    Original file line number Diff line number Diff line change
    @@ -1,4 +1,4 @@
    #Algorithm
    # Algorithm

    Question

    @@ -18,7 +18,7 @@ rowSumOddNumbers(1); // 1
    rowSumOddNumbers(2); // 3 + 5 = 8


    #Database
    # Database
    Given a table with the following.

    ----------------------------------------------
  13. thecodecafe revised this gist Dec 4, 2019. 1 changed file with 2 additions and 1 deletion.
    3 changes: 2 additions & 1 deletion Questions.md
    Original file line number Diff line number Diff line change
    @@ -3,12 +3,13 @@
    Question

    Given the triangle of consecutive odd numbers:

    ```
    1
    3 5
    7 9 11
    13 15 17 19
    21 23 25 27 29
    ```

    Calculate the row sums of this triangle from the row index (starting at index 1).

  14. thecodecafe renamed this gist Dec 4, 2019. 1 changed file with 0 additions and 0 deletions.
    File renamed without changes.
  15. thecodecafe created this gist Dec 4, 2019.
    56 changes: 56 additions & 0 deletions Questions
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,56 @@
    #Algorithm

    Question

    Given the triangle of consecutive odd numbers:

    1
    3 5
    7 9 11
    13 15 17 19
    21 23 25 27 29

    Calculate the row sums of this triangle from the row index (starting at index 1).

    E.g.
    rowSumOddNumbers(1); // 1
    rowSumOddNumbers(2); // 3 + 5 = 8


    #Database
    Given a table with the following.

    ----------------------------------------------
    | id | name | email | role_id |
    ----------------------------------------------
    | 1 | Jon | [email protected] | 1 |
    ----------------------------------------------
    | 2 | Peter | [email protected] | 1 |
    ----------------------------------------------
    | 3 | Stanley | [email protected] | 1 |
    ----------------------------------------------
    | 1 | Jon | [email protected] | 3 |
    ----------------------------------------------
    | 1 | peter | [email protected] | 3 |
    ----------------------------------------------

    Write an SQL query that selects distinc emails where role id is equal to 3 or 1.

    Example Result.
    --------------------
    | email |
    --------------------
    | [email protected] |
    --------------------
    | [email protected] |
    --------------------
    | [email protected] |
    --------------------

    # Frontend

    Todo list app with ReactJS
    - Add Todo
    - Remove Todo
    - Toggle completed status
    - Change todo text