SQL Algorithm to Compute Shortest Distance in a Plane
Given the following SQL Schema, CREATE TABLE If Not Exists point_2d (x INT NOT NULL, y INT NOT NULL) Truncate table point_2d insert into point_2d (x, y) values ('-1', …
How to Count Univalue Subtrees in a Binary Tree?
Given a binary tree, count the number of uni-value subtrees. A Uni-value subtree means all nodes of the subtree have the same value. Example : Input: root = 5 …
The Secure Shell (SSH) Chrome Extension developed by Google
Speaking about SSH tools, we often use the PuTTY or Termius, which are heavy weight desktop applications (users are required to download and install, and maybe upgrade manually). The …
The Valid Mountain Array Algorithm
Given an array A of integers, return true if and only if it is a valid mountain array. Recall that A is a mountain array if and only if: …
Recovery Models in SQL Server
When we talk stuff related to SQL Server and database, Recovery is an imperative objective that one shouldn’t underestimate. With Microsoft SQL Server, there are three different Recovery Models …
SQL Inner Join Tutorial with Example: Managers with at Least 5 Direct Reports
Given the following SQL Schema: Create table If Not Exists Employee (Id int, Name varchar(255), Department varchar(255), ManagerId int) Truncate table Employee insert into Employee (Id, Name, Department, ManagerId) …