Skip to content
Permalink

Comparing changes

Choose two branches to see what’s changed or to start a new pull request. If you need to, you can also or learn more about diff comparisons.

Open a pull request

Create a new pull request by comparing changes across two branches. If you need to, you can also . Learn more about diff comparisons here.
base repository: shawlu95/Beyond-LeetCode-SQL
Failed to load repositories. Confirm that selected base ref is valid, then try again.
Loading
base: fix-leetcode-185
Choose a base ref
...
head repository: shawlu95/Beyond-LeetCode-SQL
Failed to load repositories. Confirm that selected head ref is valid, then try again.
Loading
compare: master
Choose a head ref
Checking mergeability… Don’t worry, you can still create the pull request.
  • 19 commits
  • 12 files changed
  • 6 contributors

Commits on May 3, 2020

  1. - Fix column name typo: song_id -> song 

    - Fix links to 'the last one' and 'the same dataset'
    @wctjerry
    wctjerry committed May 3, 2020
    Configuration menu
    Copy the full SHA
    3cdbfd5 View commit details
    Browse the repository at this point in the history

Commits on May 4, 2020

  1. Pre-filter duplicates before applying window functions to find out co… 

    …nsecutive active users.
    @wctjerry
    wctjerry committed May 4, 2020
    Configuration menu
    Copy the full SHA
    0c325d9 View commit details
    Browse the repository at this point in the history

  2. Fix a bug to get 7 consecutive days instead of 8.

    @wctjerry
    wctjerry committed May 4, 2020
    Configuration menu
    Copy the full SHA
    afc2b5e View commit details
    Browse the repository at this point in the history

Commits on May 5, 2020

  1. Remove a semicolon that blocks loading the last row in the dataset. 

    Fix the link to Interview 15 problem set.
    @wctjerry
    wctjerry committed May 5, 2020
    Configuration menu
    Copy the full SHA
    fe2d8dc View commit details
    Browse the repository at this point in the history

  2. Fix a bug that may miss user_id due to one-way friendship binding.

    @wctjerry
    wctjerry committed May 5, 2020
    Configuration menu
    Copy the full SHA
    00cde5d View commit details
    Browse the repository at this point in the history

Commits on May 12, 2020

  1. Modify the database to align with the walkthrough in this problem set

    @wctjerry
    wctjerry committed May 12, 2020
    Configuration menu
    Copy the full SHA
    e3d7cad View commit details
    Browse the repository at this point in the history

  2. Add a missing file that stores the solution to the problem set

    @wctjerry
    wctjerry committed May 12, 2020
    Configuration menu
    Copy the full SHA
    5d108cf View commit details
    Browse the repository at this point in the history

  3. Rename README.MD to README.md 

    Rename the extension to fix the link redirection from `Beyond-LeetCode-SQL/README.md`.
    @wctjerry
    wctjerry authored May 12, 2020
    Configuration menu
    Copy the full SHA
    a1082e2 View commit details
    Browse the repository at this point in the history

Commits on Jun 8, 2020

  1. Update mysql.sql 

    Added a Mysql Solution using CTE
    @SinKasula
    SinKasula authored Jun 8, 2020
    Configuration menu
    Copy the full SHA
    5a331d8 View commit details
    Browse the repository at this point in the history

Commits on Jul 21, 2020

  1. another solution for 618_Students_Report_by_Geography

    @sgsfak
    sgsfak committed Jul 21, 2020
    Configuration menu
    Copy the full SHA
    5caa334 View commit details
    Browse the repository at this point in the history

Commits on Jan 31, 2021

  1. fix Leetcode 615 problem link, and some typo fixes

    @saeedesmaili
    saeedesmaili authored Jan 31, 2021
    Configuration menu
    Copy the full SHA
    a4a1abf View commit details
    Browse the repository at this point in the history

Commits on Nov 17, 2021

  1. Merge pull request #7 from shawlu95/fix-interview-11 

    Fix typos on Interview 11
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    eb132a7 View commit details
    Browse the repository at this point in the history

  2. Merge pull request #8 from shawlu95/fix-interview-09 

    Fix typos on interview 09
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    62dbf0b View commit details
    Browse the repository at this point in the history

  3. Merge pull request #9 from shawlu95/fix-interview-14-15 

    Fix on interview 14 & 15
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    2d7bf43 View commit details
    Browse the repository at this point in the history

  4. Merge pull request #10 from shawlu95/fix-leetcode-185 

    Fix on Leetcode 185
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    a8dd3a1 View commit details
    Browse the repository at this point in the history

  5. Merge pull request #11 from shawlu95/fix-on-leetcode-615 

    Fix on leetcode 615
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    9e36a90 View commit details
    Browse the repository at this point in the history

  6. Merge pull request #12 from SinKasula/patch-1 

    Update mysql.sql
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    79d7a70 View commit details
    Browse the repository at this point in the history

  7. Merge pull request #13 from sgsfak/master 

    another solution for 618_Students_Report_by_Geography
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    76b45cd View commit details
    Browse the repository at this point in the history

  8. Merge pull request #14 from saeedesmaili/patch-1 

    fix Leetcode 615 problem link, and some typo fixes
    @shawlu95
    shawlu95 authored Nov 17, 2021
    Configuration menu
    Copy the full SHA
    8ab7f0a View commit details
    Browse the repository at this point in the history
Loading