SQL for Birthday Matching

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL for Birthday Matching. Start with the requirements and the two tables on the right.

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

You need to log in / sign up to run or submit.

Problem

PharmaACE wants to support employee birthday reporting in its internal analytics tools. Given your PharmaACE employee ID, identify how many other employees have the same calendar birthday, regardless of birth year.

Write a PostgreSQL query that uses the employee profile record to obtain the target birthday and compares it with the birthdays of all employees.

Requirements

Use the employee ID supplied as PostgreSQL parameter \$1.
Compare only the month and day portions of birth_date, ignoring the year.
Exclude the target employee from the count and ignore employees with missing birth dates.
Return one row with the alias people_with_same_birthday.

Schema

pharmaace_employees

Column	Type	Description
employee_idPK	INT	Unique PharmaACE employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(80)	Employee's department
birth_date	DATE	Employee's date of birth

pharmaace_employee_profiles

Column	Type	Description
employee_idPK	INT	Employee identifier associated with the profile
profile_status	VARCHAR(20)	Current profile status

Tablespharmaace_employeespharmaace_employee_profiles

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results