Both Ends of the Pipe

A medium SQL interview practice problem on DataDriven. Write and execute real sql code with instant feedback.

Domain

SQL

Difficulty

medium

Seniority

L4

Problem

The release engineering team wants the authors who carry a build all the way from dev into production, treating the same environment name in different casing as one. List each qualifying author with how many of those two environments they deployed to, alphabetically.

Summary

Dev and prod, both touched by the same hand. Who are they?

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and checks it automatically.