Problem Statement:
The United Nations Organization released an official document regarding the most important events from the beginning of time (dated 00-00-0000) with a brief description of the events. The date of all the events is mentioned in the 'DD-MM-YYYY' format.
Find the total number of distinct years referenced in the document.
Input Specification:
Output Specification:
Example 1:
Input: input1: UN was established on 24-10-1945. India got freedom on 15-08-1947.
Output: 2
Explanation:
2 distinct years, 1945 and 1947 have been referenced.
Problem Statement:
An array has a special integer if that integer can be formed by calculating the sum of a number and its reverse.
Find how many integers are special in an array.
Note: Trailing zeros from the reverse of a number formed need to be removed if they exist.
Input Specification:
Output Specification:
Example 1:
Input:
input1: {22, 121}
input2: 2
Output:
2
Problem Statement:
Write a MySQL query to find:
The count (use alias count) of express trains that start from New Delhi (NDLS) and go to Mumbai (BCT) or Bhopal (BHP).
Your output should have 1 column as given below: