Published onSeptember 26, 2019[LeetCode 626] Exchange SeatsMySQLMary is a teacher in a middle school and she has a table seat storing students' names and their corresponding seat ids.
Published onSeptember 23, 2019Construct Binary Tree from Preorder and Inorder TraversalTreeGiven preorder and inorder traversal of a tree, construct the binary tree.
Published onSeptember 21, 2019[LeetCode 176] Second Highest SalaryMySQLWrite a SQL query to get the second highest salary from the Employee table.
Published onSeptember 20, 2019[LeetCode 197] Rising TemperatureMySQLGiven a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates.
Published onSeptember 11, 2019TCP Connection Establishment and TerminationNetworkTo establish a connection, TCP uses a three-way handshake.