#SQL
#SQL Leetcode SQL 50 #23: 2356:
Write a solution to calculate the number of unique subjects each teacher teaches in the university.
We will be solving all the questions from LeetCode SQL 50 one by one. These questions range from easy to hard.
**SQL scripts you can use to create and populate the table:
-- Create the Teacher table
CREATE TABLE Teacher (
teacher_id INT,
subject_id INT,
dept_id INT
);
-- Insert data into the table (add more rows to it)
INSERT INTO Teacher (teacher_id, subject_id, dept_id)
VALUES
(1, 2, 3),
(1, 2, 4);
#datascience #coding #programming #mssql #databasemanagement #leetcode #leetcode2356 #leetcodesolution
👉SQL Tutorials Playlist:
• SQL Tutorials
👉SQL Shorts Playlist:
• SQL Shorts
👉Python Shorts Playlist:
• Python Shorts
👉Python Tutorials Playlist:
• Python Tutorials
👉Excel Shorts Playlist:
• Excel Shorts
