Hackerrank-Code

Hackerrank-Code copied to clipboard

Nndna9

the query before did not give the correct output as it was searching for all vowels, but this corrected query searches for all the vowel-starting cities and distinct as we...

Arnav1505

picklo111

Please put parentheses for the result, otherwise, it won't work. Thanks.

QuinnFeng

weather observation 20

3

select round(s.lat_n,4) from station s where (select round(count(s.id)/2)-1 from station) = (select count(s1.id) from station s1 where s1.lat_n > s.lat_n); correct code is this

ritwikdalmia

select round(sqrt(pow(min(lat_n)-max(lat_n),2)+ pow(min(long_w)-max(long_w),2)),4) from station; it is a correct solution

ritwikdalmia

select round(abs(min(lat_n)-max(lat_n))+abs(min(long_w)-max(long_w)),4) from station;

ritwikdalmia

**Change to this ->** ``` SELECT DISTINCT city FROM station WHERE LEFT(city, 1) IN ('A', 'E', 'I', 'O', 'U') ``` > LEFT(string, char_count) function lets you get the character(s) of...

NuranTerlan