Dwijraj Pandey Pandeydwijraj

## Query the list of CITY names starting with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain duplicates.
SELECT DISTINCT CITY FROM STATION WHERE SUBSTR(CITY,1,1) IN('A','E','I','O','U');

## two cities in STATION with the shortest and longest CITY names
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY LIMIT 1;
SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1;

## Different city with IDs of even number
SELECT DISTINCT CITY FROM STATION
WHERE MOD(ID,2) = 0 ;

## ids of the companies that have more than 10000 employees in ascending order
SELECT ID
FROM COMPANY
WHERE employees > 10000
ORDER BY ID;

## country codes concatenated with their phone numbers- Solution
SELECT a.customer_id, a.name, concat("+", b.country_code, a.phone_number)
FROM customers as a
LEFT JOIN country_codes as b
ON a.country = b.country
ORDER BY a.customer_id;
	SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY), CITY LIMIT 1;
	SELECT CITY, LENGTH(CITY) FROM STATION ORDER BY LENGTH(CITY) DESC, CITY LIMIT 1;
	SELECT a.customer_id, a.name, concat("+", b.country_code, a.phone_number)
	FROM customers as a
	LEFT JOIN country_codes as b
	ON a.country = b.country
	ORDER BY a.customer_id;