Nilhar technology

  Query the list of   CITY   names ending with vowels (a, e, i, o, u) from   STATION . Your result   cannot   contain duplicates. Input Format The  STATION  table is described as follows: where  LAT_N  is the northern latitude and  LONG_W  is the western longitude. Notes :  SUBSTR() The SUBSTR() function extracts a substring from a string (starting at any position). Note:  The SUBSTR() and  MID()  functions equals to the  SUBSTRING()  function. Syntax SUBSTR( string ,  start ,  length ) Parameter Values Parameter Description string Required. The string to extract from start Required. The start position. Can be both a positive or negative number. If it is a positive number, this function extracts from the beginning of the string. If it is a negative number, this function extracts from the end of the string length Optional. The number of characters to extract. If omitted, the whole string w...

Problem :  Picking Numbers [https://www.hackerrank.com/challenges/picking-numbers/problem] G iven an array of integers, find the longest subarray where the absolute difference between any two elements is less than or equal to   . Example There are two subarrays meeting the criterion:   and  . The maximum length subarray has   elements. Function Description Complete the  pickingNumbers  function in the editor below. pickingNumbers has the following parameter(s): int a[n]:  an array of integers Returns int:  the length of the longest subarray that meets the criterion Input Format The first line contains a single integer  , the size of the array  . The second line contains   space-separated integers, each an  . Constraints The answer will be  . Sample Input 0 6 4 6 5 3 3 1 Sample Output 0 3 Explanation 0 We choose the following multiset of integers from the array:  . Each pair in the multiset has a...