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.
Published onSeptember 9, 2019Internet Protocol SuiteNetworkprotocols used in the internet and similar computer networks.
Published onSeptember 6, 2019[LeetCode 196] Delete Duplicate EmailsMySQLWrite a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.
Published onSeptember 5, 2019[LeetCode 181] Employees Earning More Than Their ManagersMySQLThe `Employee` table holds all employees including their managers.