Query the two cities in STATION with the shortest and longest CITY names, as well as their respective lengths (i.e.: number of characters in the name). If there is more than one smallest or largest city, choose the one that comes first when ordered alphabetically. The STATION table is described as follows:

Problem Difficulty Level : Hard

Data Structure

• ID
• City
• State
• Lattitude
• Longitude

Data for station table

In CSV Format

Sample Input

For example, CITY has four entries: DEF, ABC, PQRS and WXY.

Sample Output

ABC 3
PQRS 4

In Spark we will solve this problem using two ways

1. Using PySpark Functions
2. Using Spark SQL

Use below notebook for solution

Problem Solution First Part

In Postgre SQL We will load data from CSV using PostgreSQL Import functionality. And then we will solve this problem.

Output Query

Problem Solution

Please also follow below blog for understanding this problem