Commits

Branch selector

master

User selector

All users

All time

Commit history

Commits on Sep 5, 2021

• Update README.md

  NIteshx2

  authored
  54f400aView commit details

  Copy full SHA for 54f400a

  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

• Create 1148_Article_Views_I.sql

  shawlu95

  authored
  4a9b811View commit details

  Copy full SHA for 4a9b811

  Browse repository at this point

• Create 1142_User_Activity_for_the_Past_30_Days_II.sql

  shawlu95

  authored
  c3612ceView commit details

  Copy full SHA for c3612ce

  Browse repository at this point

• Create 1141_User_Activity_for_the_Past_30_Days_I.sql

  shawlu95

  authored
  54f4303View commit details

  Copy full SHA for 54f4303

  Browse repository at this point

• Create 1132_Reported_Posts_II.sql

  shawlu95

  authored
  0e98eb2View commit details

  Copy full SHA for 0e98eb2

  Browse repository at this point

• Create 1127_User_Purchase_Platform.sql

  shawlu95

  authored
  1547190View commit details

  Copy full SHA for 1547190

  Browse repository at this point

• Create 1126_Active_Businesses.sql

  shawlu95

  authored
  ecd099fView commit details

  Copy full SHA for ecd099f

  Browse repository at this point

• Create 1113_Reported_Posts.sql

  shawlu95

  authored
  a8d06e0View commit details

  Copy full SHA for a8d06e0

  Browse repository at this point

• Create 1112_Highest_Grade_For_Each_Student.sql

  shawlu95

  authored
  95478e5View commit details

  Copy full SHA for 95478e5

  Browse repository at this point

• Create 1107_New_Users_Daily_Count.sql

  shawlu95

  authored
  5013ea3View commit details

  Copy full SHA for 5013ea3

  Browse repository at this point

• Create 1098_Unpopular_Books.sql

  shawlu95

  authored
  13179ebView commit details

  Copy full SHA for 13179eb

  Browse repository at this point

• Create 1097_Game_Play_Analysis_V.sql

  shawlu95

  authored
  a753ae4View commit details

  Copy full SHA for a753ae4

  Browse repository at this point

• Create 1084_Sales_Analysis_III.sql

  shawlu95

  authored
  0dcb2f7View commit details

  Copy full SHA for 0dcb2f7

  Browse repository at this point

• Create 1083_Sales_Analysis_II.sql

  shawlu95

  authored
  8646537View commit details

  Copy full SHA for 8646537

  Browse repository at this point

• Create 1082_Sales_Analysis_I.sql

  shawlu95

  authored
  5f4d7eaView commit details

  Copy full SHA for 5f4d7ea

  Browse repository at this point

• Create 1077_Project_Employees_III.sql

  shawlu95

  authored
  ec9b63fView commit details

  Copy full SHA for ec9b63f

  Browse repository at this point

• Create 1076_Project_Employees_II.sql

  shawlu95

  authored
  59311bcView commit details

  Copy full SHA for 59311bc

  Browse repository at this point

• Create 1075_Project_Employees_I.sql

  shawlu95

  authored
  1c3c646View commit details

  Copy full SHA for 1c3c646

  Browse repository at this point

• Create 1070_Product_Sales_Analysis_III.sql

  shawlu95

  authored
  7898860View commit details

  Copy full SHA for 7898860

  Browse repository at this point

• Rename 1068_Product_Sales_Analysis_II.sql to 1069_Product_Sales_Analysis_II.sql

  shawlu95

  authored
  0a5989eView commit details

  Copy full SHA for 0a5989e

  Browse repository at this point