Consider and to be two points on a 2D plane. happens to equal the minimum value in Northern Latitude (LAT_N in STATION). happens to equal the minimum value in Western Longitude (LONG_W in STATION). happens to equal the maximum value in Northern Latitude (LAT_N in STATION). happens to equal the maximum value in Western Longitude (LONG_W in STATION).Query the Manhattan Distance between points and and round it to a scale of decimal places.Input FormatThe STATION table is described as follows:

Table point_2d holds the coordinates (x,y) of some unique points (more than two) in a plane.Write a query to find the shortest distance between these points rounded to 2 decimals.xy-1-100-1-2The shortest distance is 1.00 from point (-1,-1) to (-1,2). So the output should be:shortest1.00Note: The longest distance among all the points are less than 10000.Optionsselect round(min(dist), 2) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) as dist from point_2d as a, point_2d as b) as d;select round(dist) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) + power(a.y - b.y, 2))) as dist from point_2d as a, point_2d as b) as d;select round(min(dist), 2) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) + power(a.y - b.y, 2))) as dist) as d;select round(min(dist), 2) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) + power(a.y - b.y, 2))) as dist from point_2d as a, point_2d as b) as d;

Write a query to retrieve the longitude (rounded to four decimal places) of the station with the minimum latitude greater than 38.7780.Table: STATION

Shortest Distance in a PlaneTable point_2d holds the coordinates (x,y) of some unique points (more than two) in a plane.Write a query to find the shortest distance between these points rounded to 2 decimals.xy-1-100-1-2The shortest distance is 1.00 from point (-1,-1) to (-1,2). So the output should be:shortest1.00Note: The longest distance among all the points are less than 10000.Optionsselect round(min(dist), 2) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) + power(a.y - b.y, 2))) as dist from point_2d as a, point_2d as b) as d;select round(min(dist), 2) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) as dist from point_2d as a, point_2d as b) as d;select round(dist) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) + power(a.y - b.y, 2))) as dist from point_2d as a, point_2d as b) as d;select round(min(dist), 2) as shortestfrom ( select if(a.x = b.x and a.y = b.y, 10000, sqrt(power(a.x - b.x, 2) + power(a.y - b.y, 2))) as dist) as d;

Question 6The Euclidean distance between two points will always be shorter than the Manhattan distance:1 pointTrueFalse

Write an SQL query to calculate the sum of all values in the columns LAT_N and LONG_W from the STATION table. Round the sums to a scale of 2 decimal places.