Search ⌘K
LinkedIn
LinkedIn

Foundations Track · Easy · 15 min

Trainer Certification Coverage

The operations team needs trainers who can cover every required warehouse course. Return the trainer_id values for trainers who hold all three certifications...

Foundations Track
Easy
15 min
query basics
aggregation
filtering

Company labels are directional practice context, not official interview guidance.

Timer 00:00
Back to practice

Objective

Practice query basics through a LinkedIn-tagged business scenario.

Approach

Use this track to lock in clean query structure, basic filtering logic, and confidence with grouped output.

Company context

Company labels are directional practice context, not official interview guidance.

Prereq: query basics
Prereq: filtering

The operations team needs trainers who can cover every required warehouse course. Return the trainer_id values for trainers who hold all three certifications: Forklift, Hazmat, and Refrigerated Storage. Sort by trainer_id.

trainer_certifications
trainer_id INT
certification VARCHAR(40
trainer_idcertification
11Forklift
11Hazmat
11Refrigerated Storage
12Forklift
12Hazmat
13Forklift
13Hazmat
13Refrigerated Storage
13Safety Basics
14Refrigerated Storage
Editor
SQL workspace

Run queries against the protected question data, then submit once the result shape looks right.

Sign in to run SQL

Create a free account or sign in before running queries against protected question data.