SQL: 100th Element Query | Dataford Interview Questions

Akamai engineers need to validate a generated sequence of service positions against metadata for Akamai delivery products. Write a PostgreSQL query that generates the first 120 elements, joins each element to its corresponding product, and returns only the 100th element.

Requirements

Generate integer positions from 1 through 120 using PostgreSQL generate_series.
Map positions cyclically to service IDs 1 through 4 and join them to akamai_products.
Return the 100th position, its service ID, product name, and product family.
Preserve the requested position explicitly with an ORDER BY clause.

Schema

akamai_products

Column	Type	Description
service_idPK	INTEGER	Unique Akamai product service identifier
product_name	VARCHAR(100)	Akamai product name
product_family	VARCHAR(100)	Product family
region_code	VARCHAR(10)	Primary deployment region

edge_service_registry

Column	Type	Description
service_idPK	INTEGER	Registered service identifier
service_status	VARCHAR(20)	Current service status
owner_team	VARCHAR(100)	Responsible Akamai team

Your question is SQL: 100th Element Query. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem