Commits

Breadcrumbs

History for

onmaster

User selector

All users

All time

Commit history

Commits on Nov 17, 2021

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

  Show description for 2d7bf43
  shawlu95

  authored
  2d7bf43View commit details

  Copy full SHA for 2d7bf43

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse 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

  View code at this pointBrowse repository at this point

Commits on Mar 28, 2019

• Formatted sql.

  

  Shaw

  committed
  35af9bdView commit details

  Copy full SHA for 35af9bd

  View code at this pointBrowse repository at this point

Commits on Mar 26, 2019

• Formatted.

  

  Shaw

  committed
  37ff000View commit details

  Copy full SHA for 37ff000

  View code at this pointBrowse repository at this point

• formatted.

  

  Shaw

  committed
  d567129View commit details

  Copy full SHA for d567129

  View code at this pointBrowse repository at this point

• Formatted.

  

  Shaw

  committed
  dac3fecView commit details

  Copy full SHA for dac3fec

  View code at this pointBrowse repository at this point

• Update README.md

  

  Shaw

  committed
  c21b905View commit details

  Copy full SHA for c21b905

  View code at this pointBrowse repository at this point

Commits on Mar 23, 2019

• Formattibg.

  

  Shaw

  committed
  251b8a4View commit details

  Copy full SHA for 251b8a4

  View code at this pointBrowse repository at this point

• Minor change.

  

  Shaw

  committed
  4e86074View commit details

  Copy full SHA for 4e86074

  View code at this pointBrowse repository at this point

• Added Instagram common follower problem.

  

  Shaw

  committed
  fba2540View commit details

  Copy full SHA for fba2540

  View code at this pointBrowse repository at this point

• Renamed problem.

  

  Shaw

  committed
  1834f73View commit details

  Copy full SHA for 1834f73

  View code at this pointBrowse repository at this point

• Added People You May Know.

  

  Shaw

  committed
  87f662eView commit details

  Copy full SHA for 87f662e

  View code at this pointBrowse repository at this point

• Update README.md

  

  Shaw

  committed
  e855717View commit details

  Copy full SHA for e855717

  View code at this pointBrowse repository at this point

• Added Common Friend problem.

  

  Shaw

  committed
  11ff0c0View commit details

  Copy full SHA for 11ff0c0

  View code at this pointBrowse repository at this point

Commits on Mar 21, 2019

• Added more problems 14, 15, 16.

  

  Shaw

  committed
  8d07cf1View commit details

  Copy full SHA for 8d07cf1

  View code at this pointBrowse repository at this point

Commits on Mar 18, 2019

• Minor formatting.

  

  Shaw

  committed
  6e6695fView commit details

  Copy full SHA for 6e6695f

  View code at this pointBrowse repository at this point

• Added interview problem 13.

  

  Shaw

  committed
  45e8693View commit details

  Copy full SHA for 45e8693

  View code at this pointBrowse repository at this point

• Added interview problem 12.

  

  Shaw

  committed
  51d45fbView commit details

  Copy full SHA for 51d45fb

  View code at this pointBrowse repository at this point

• Added interview problem 11.

  

  Shaw

  committed
  2f34cbcView commit details

  Copy full SHA for 2f34cbc

  View code at this pointBrowse repository at this point

• Added sample databases.

  

  Shaw

  committed
  ecf11f8View commit details

  Copy full SHA for ecf11f8

  View code at this pointBrowse repository at this point

• Added interview problem 10.

  

  Shaw

  committed
  4b7dec4View commit details

  Copy full SHA for 4b7dec4

  View code at this pointBrowse repository at this point

• Added 06_Hacking_Aggregation.

  

  Shaw

  committed
  f83ae47View commit details

  Copy full SHA for f83ae47

  View code at this pointBrowse repository at this point

Commits on Mar 17, 2019

• Added interview Q9.

  

  Shaw

  committed
  5f1fb20View commit details

  Copy full SHA for 5f1fb20

  View code at this pointBrowse repository at this point

• Added a few more use cases.

  

  Shaw

  committed
  1f51e9fView commit details

  Copy full SHA for 1f51e9f

  View code at this pointBrowse repository at this point