Off-by-one on range boundaries
Wrong move: Loop endpoints miss first/last candidate.
Usually fails on: Fails on minimal arrays and exact-boundary answers.
Fix: Re-derive loops from inclusive/exclusive ranges before coding.
Build confidence with an intuition-first walkthrough focused on core interview patterns fundamentals.
Table: Teacher
+-------------+------+ | Column Name | Type | +-------------+------+ | teacher_id | int | | subject_id | int | | dept_id | int | +-------------+------+ (subject_id, dept_id) is the primary key (combinations of columns with unique values) of this table. Each row in this table indicates that the teacher with teacher_id teaches the subject subject_id in the department dept_id.
Write a solution to calculate the number of unique subjects each teacher teaches in the university.
Return the result table in any order.
The result format is shown in the following example.
Example 1:
Input: Teacher table: +------------+------------+---------+ | teacher_id | subject_id | dept_id | +------------+------------+---------+ | 1 | 2 | 3 | | 1 | 2 | 4 | | 1 | 3 | 3 | | 2 | 1 | 1 | | 2 | 2 | 1 | | 2 | 3 | 1 | | 2 | 4 | 1 | +------------+------------+---------+ Output: +------------+-----+ | teacher_id | cnt | +------------+-----+ | 1 | 2 | | 2 | 4 | +------------+-----+ Explanation: Teacher 1: - They teach subject 2 in departments 3 and 4. - They teach subject 3 in department 3. Teacher 2: - They teach subject 1 in department 1. - They teach subject 2 in department 1. - They teach subject 3 in department 1. - They teach subject 4 in department 1.
Problem summary: Table: Teacher +-------------+------+ | Column Name | Type | +-------------+------+ | teacher_id | int | | subject_id | int | | dept_id | int | +-------------+------+ (subject_id, dept_id) is the primary key (combinations of columns with unique values) of this table. Each row in this table indicates that the teacher with teacher_id teaches the subject subject_id in the department dept_id. Write a solution to calculate the number of unique subjects each teacher teaches in the university. Return the result table in any order. The result format is shown in the following example.
Start with the most direct exhaustive search. That gives a correctness anchor before optimizing.
Pattern signal: General problem-solving
{"headers":{"Teacher":["teacher_id","subject_id","dept_id"]},"rows":{"Teacher":[[1,2,3],[1,2,4],[1,3,3],[2,1,1],[2,2,1],[2,3,1],[2,4,1]]}}Source-backed implementations are provided below for direct study and interview prep.
// Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// Auto-generated Java example from rust.
class Solution {
public void exampleSolution() {
}
}
// Reference (rust):
// // Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// pub fn sql_example() -> &'static str {
// r#"
// -- Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// # Write your MySQL query statement below
// SELECT teacher_id, COUNT(DISTINCT subject_id) AS cnt
// FROM Teacher
// GROUP BY 1;
// "#
// }
// Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// Auto-generated Go example from rust.
func exampleSolution() {
}
// Reference (rust):
// // Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// pub fn sql_example() -> &'static str {
// r#"
// -- Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// # Write your MySQL query statement below
// SELECT teacher_id, COUNT(DISTINCT subject_id) AS cnt
// FROM Teacher
// GROUP BY 1;
// "#
// }
# Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
# Auto-generated Python example from rust.
def example_solution() -> None:
return
# Reference (rust):
# // Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
# pub fn sql_example() -> &'static str {
# r#"
# -- Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
# # Write your MySQL query statement below
# SELECT teacher_id, COUNT(DISTINCT subject_id) AS cnt
# FROM Teacher
# GROUP BY 1;
# "#
# }
// Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
pub fn sql_example() -> &'static str {
r#"
-- Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
# Write your MySQL query statement below
SELECT teacher_id, COUNT(DISTINCT subject_id) AS cnt
FROM Teacher
GROUP BY 1;
"#
}
// Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// Auto-generated TypeScript example from rust.
function exampleSolution(): void {
}
// Reference (rust):
// // Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// pub fn sql_example() -> &'static str {
// r#"
// -- Accepted solution for LeetCode #2356: Number of Unique Subjects Taught by Each Teacher
// # Write your MySQL query statement below
// SELECT teacher_id, COUNT(DISTINCT subject_id) AS cnt
// FROM Teacher
// GROUP BY 1;
// "#
// }
Use this to step through a reusable interview workflow for this problem.
Two nested loops check every pair or subarray. The outer loop fixes a starting point, the inner loop extends or searches. For n elements this gives up to n²/2 operations. No extra space, but the quadratic time is prohibitive for large inputs.
Most array problems have an O(n²) brute force (nested loops) and an O(n) optimal (single pass with clever state tracking). The key is identifying what information to maintain as you scan: a running max, a prefix sum, a hash map of seen values, or two pointers.
Review these before coding to avoid predictable interview regressions.
Wrong move: Loop endpoints miss first/last candidate.
Usually fails on: Fails on minimal arrays and exact-boundary answers.
Fix: Re-derive loops from inclusive/exclusive ranges before coding.