Commits

Branch selector

master

User selector

All users

All time

Commit history

Commits on Nov 17, 2021

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

  Show description for 8ab7f0a
  shawlu95

  authored
  8ab7f0aView commit details

  Copy full SHA for 8ab7f0a

  Browse repository at this point

• Merge pull request #13 from sgsfak/master

  Show description for 76b45cd
  shawlu95

  authored
  76b45cdView commit details

  Copy full SHA for 76b45cd

  Browse repository at this point

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

  Show description for 79d7a70
  shawlu95

  authored
  79d7a70View commit details

  Copy full SHA for 79d7a70

  Browse repository at this point

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

  Show description for 9e36a90
  shawlu95

  authored
  9e36a90View commit details

  Copy full SHA for 9e36a90

  Browse repository at this point

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

  Show description for a8dd3a1
  shawlu95

  authored
  a8dd3a1View commit details

  Copy full SHA for a8dd3a1

  Browse repository at this point

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

  Show description for 2d7bf43
  shawlu95

  authored
  2d7bf43View commit details

  Copy full SHA for 2d7bf43

  Browse repository at this point

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

  Show description for 62dbf0b
  shawlu95

  authored
  62dbf0bView commit details

  Copy full SHA for 62dbf0b

  Browse repository at this point

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

  Show description for eb132a7
  shawlu95

  authored
  eb132a7View commit details

  Copy full SHA for eb132a7

  Browse repository at this point

Commits on Jan 31, 2021

• fix Leetcode 615 problem link, and some typo fixes

  saeedesmaili

  authored
  a4a1abfView commit details

  Copy full SHA for a4a1abf

  Browse repository at this point

Commits on Jul 21, 2020

• another solution for 618_Students_Report_by_Geography

  sgsfak

  committed
  5caa334View commit details

  Copy full SHA for 5caa334

  Browse repository at this point

Commits on Jun 8, 2020

• Update mysql.sql

  Show description for 5a331d8
  SinKasula

  authored
  5a331d8View commit details

  Copy full SHA for 5a331d8

  Browse repository at this point

Commits on May 12, 2020

• Rename README.MD to README.md

  Show description for a1082e2
  wctjerry

  authored
  a1082e2View commit details

  Copy full SHA for a1082e2

  Browse repository at this point

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

  wctjerry

  committed
  5d108cfView commit details

  Copy full SHA for 5d108cf

  Browse repository at this point

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

  wctjerry

  committed
  e3d7cadView commit details

  Copy full SHA for e3d7cad

  Browse repository at this point

Commits on May 7, 2020

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

  wctjerry

  committed
  74f67bfView commit details

  Copy full SHA for 74f67bf

  Browse repository at this point

Commits on May 5, 2020

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

  wctjerry

  committed
  00cde5dView commit details

  Copy full SHA for 00cde5d

  Browse repository at this point

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

  Show description for fe2d8dc
  wctjerry

  committed
  fe2d8dcView commit details

  Copy full SHA for fe2d8dc

  Browse repository at this point

Commits on May 4, 2020

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

  wctjerry

  committed
  afc2b5eView commit details

  Copy full SHA for afc2b5e

  Browse repository at this point

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

  wctjerry

  committed
  0c325d9View commit details

  Copy full SHA for 0c325d9

  Browse repository at this point

Commits on May 3, 2020

• - Fix column name typo: song_id -> song

  Show description for 3cdbfd5
  wctjerry

  committed
  3cdbfd5View commit details

  Copy full SHA for 3cdbfd5

  Browse repository at this point

Commits on Apr 26, 2020

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

  Show description for a625941
  shawlu95

  authored
  a625941View commit details

  Copy full SHA for a625941

  Browse repository at this point

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

  Show description for d1d2dbd
  shawlu95

  authored
  d1d2dbdView commit details

  Copy full SHA for d1d2dbd

  Browse repository at this point

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

  Show description for 4d9fb6c
  shawlu95

  authored
  4d9fb6cView commit details

  Copy full SHA for 4d9fb6c

  Browse repository at this point

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

  wctjerry

  committed
  f1ece54View commit details

  Copy full SHA for f1ece54

  Browse repository at this point

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
  6ea7f7dView commit details

  Copy full SHA for 6ea7f7d

  Browse repository at this point

Commits on Apr 24, 2020

• Fix a few typos:

  Show description for 7e56042
  wctjerry

  committed
  7e56042View commit details

  Copy full SHA for 7e56042

  Browse repository at this point

Commits on Apr 22, 2020

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

  Show description for e6bb777
  shawlu95

  authored
  e6bb777View commit details

  Copy full SHA for e6bb777

  Browse repository at this point

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
  5e5ca8bView commit details

  Copy full SHA for 5e5ca8b

  Browse repository at this point

Commits on Sep 16, 2019

• Create 1179_Reformat_Department_Table.sql

  shawlu95

  authored
  b7bcee4View commit details

  Copy full SHA for b7bcee4

  Browse repository at this point

• Create 1174_Immediate_Food_Delivery_II.sql

  shawlu95

  authored
  15dfb9cView commit details

  Copy full SHA for 15dfb9c

  Browse repository at this point

• Create 1173_Immediate_Food_Delivery_I.sql

  shawlu95

  authored
  d4c7d08View commit details

  Copy full SHA for d4c7d08

  Browse repository at this point

• Create 1164_Product_Price_at_a_Given_Date.sql

  shawlu95

  authored
  2cfc235View commit details

  Copy full SHA for 2cfc235

  Browse repository at this point

• Create 1159_Market_Analysis_II.sql

  shawlu95

  authored
  69b128eView commit details

  Copy full SHA for 69b128e

  Browse repository at this point

• Create 1158_Market_Analysis_I.sql

  shawlu95

  authored
  394b8c1View commit details

  Copy full SHA for 394b8c1

  Browse repository at this point

• Create 1149_Article_Views_II.sql

  shawlu95

  authored
  284a83eView commit details

  Copy full SHA for 284a83e

  Browse repository at this point