Commits

Branch selector

 master

User selector

All users

Datepicker

All time

Commit History

Commits on Nov 17, 2021

• Merge pull request #14 from saeedesmaili/patch-1

  Show description for 8ab7f0a
  shawlu95

  authored
  8ab7f0a

  Copy full SHA for 8ab7f0a

• Merge pull request #13 from sgsfak/master

  Show description for 76b45cd
  shawlu95

  authored
  76b45cd

  Copy full SHA for 76b45cd

• Merge pull request #12 from SinKasula/patch-1

  Show description for 79d7a70
  shawlu95

  authored
  79d7a70

  Copy full SHA for 79d7a70

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

  Show description for 9e36a90
  shawlu95

  authored
  9e36a90

  Copy full SHA for 9e36a90

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

  Show description for a8dd3a1
  shawlu95

  authored
  a8dd3a1

  Copy full SHA for a8dd3a1

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

  Show description for 2d7bf43
  shawlu95

  authored
  2d7bf43

  Copy full SHA for 2d7bf43

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

  Show description for 62dbf0b
  shawlu95

  authored
  62dbf0b

  Copy full SHA for 62dbf0b

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

  Show description for eb132a7
  shawlu95

  authored
  eb132a7

  Copy full SHA for eb132a7

Commits on Jan 31, 2021

• fix Leetcode 615 problem link, and some typo fixes

  saeedesmaili

  authored
  a4a1abf

  Copy full SHA for a4a1abf

Commits on Jul 21, 2020

• another solution for 618_Students_Report_by_Geography

  sgsfak

  committed
  5caa334

  Copy full SHA for 5caa334

Commits on Jun 8, 2020

• Update mysql.sql

  Show description for 5a331d8
  SinKasula

  authored
  5a331d8

  Copy full SHA for 5a331d8

Commits on May 12, 2020

• Rename README.MD to README.md

  Show description for a1082e2
  wctjerry

  authored
  a1082e2

  Copy full SHA for a1082e2

• Add a missing file that stores the solution to the problem set

  wctjerry

  committed
  5d108cf

  Copy full SHA for 5d108cf

• Modify the database to align with the walkthrough in this problem set

  wctjerry

  committed
  e3d7cad

  Copy full SHA for e3d7cad

Commits on May 7, 2020

• Add two lines of data which are missing compared to the walkthrough.

  wctjerry

  committed
  74f67bf

  Copy full SHA for 74f67bf

Commits on May 5, 2020

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

  wctjerry

  committed
  00cde5d

  Copy full SHA for 00cde5d

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

  Show description for fe2d8dc
  wctjerry

  committed
  fe2d8dc

  Copy full SHA for fe2d8dc

Commits on May 4, 2020

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

  wctjerry

  committed
  afc2b5e

  Copy full SHA for afc2b5e

• Pre-filter duplicates before applying window functions to find out consecutive active users.

  wctjerry

  committed
  0c325d9

  Copy full SHA for 0c325d9

Commits on May 3, 2020

• - Fix column name typo: song_id -> song

  Show description for 3cdbfd5
  wctjerry

  committed
  3cdbfd5

  Copy full SHA for 3cdbfd5

Commits on Apr 26, 2020

• Merge pull request #6 from shawlu95/fix-interview-08

  Show description for a625941
  shawlu95

  authored
  a625941

  Copy full SHA for a625941

• Merge pull request #5 from shawlu95/fix-on-interview-07

  Show description for d1d2dbd
  shawlu95

  authored
  d1d2dbd

  Copy full SHA for d1d2dbd

• Merge pull request #4 from shawlu95/fix-typo-interview-05-06

  Show description for 4d9fb6c
  shawlu95

  authored
  4d9fb6c

  Copy full SHA for 4d9fb6c

• Add a link to the database used and guidance to load it.

  wctjerry

  committed
  f1ece54

  Copy full SHA for f1ece54

Commits on Apr 25, 2020

• In pivot_table.sql, add a statement to switch to `Grocery` Database, which blocks creating the `expenses_pivoted` Table. Also guide followers to switch to corresponding database when testing sample…

  Show description for 6ea7f7d
  wctjerry

  committed
  6ea7f7d

  Copy full SHA for 6ea7f7d

Commits on Apr 24, 2020

• Fix a few typos:

  Show description for 7e56042
  wctjerry

  committed
  7e56042

  Copy full SHA for 7e56042

Commits on Apr 22, 2020

• Merge pull request #3 from wctjerry/fix-typo-interview-01

  Show description for e6bb777
  shawlu95

  authored
  e6bb777

  Copy full SHA for e6bb777

Commits on Apr 21, 2020

• Fixed a column name typo that blocks establishing the database inside `db.sql` : paid_amount/paid.

  Show description for 5e5ca8b
  wctjerry

  committed
  5e5ca8b

  Copy full SHA for 5e5ca8b

Commits on Sep 16, 2019

• Create 1179_Reformat_Department_Table.sql

  shawlu95

  authored
  b7bcee4

  Copy full SHA for b7bcee4

• Create 1174_Immediate_Food_Delivery_II.sql

  shawlu95

  authored
  15dfb9c

  Copy full SHA for 15dfb9c

• Create 1173_Immediate_Food_Delivery_I.sql

  shawlu95

  authored
  d4c7d08

  Copy full SHA for d4c7d08

• Create 1164_Product_Price_at_a_Given_Date.sql

  shawlu95

  authored
  2cfc235

  Copy full SHA for 2cfc235

• Create 1159_Market_Analysis_II.sql

  shawlu95

  authored
  69b128e

  Copy full SHA for 69b128e

• Create 1158_Market_Analysis_I.sql

  shawlu95

  authored
  394b8c1

  Copy full SHA for 394b8c1

• Create 1149_Article_Views_II.sql

  shawlu95

  authored
  284a83e

  Copy full SHA for 284a83e

Pagination

Previous

Next