Skip to content

Navigation Menu

Explore
By company size
By use case
By industry
View all solutions
Topics
- AI
- DevOps
- Security
- Software Development
- View all
Explore
- GitHub Sponsors
  Fund open source developers
- The ReadME Project
  GitHub community articles
Repositories
- Enterprise platform
  AI-powered developer platform
Available add-ons
Pricing

Search code, repositories, users, issues, pull requests...

Search

Clear

Search syntax tips

Provide feedback

We read every piece of feedback, and take your input very seriously.

Include my email address so I can be contacted

Saved searches

Use saved searches to filter your results more quickly

Name

Query

To see all available qualifiers, see our documentation.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Dismiss alert

shivamBasak / SQL-50 Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

Code
Issues
Pull requests
Actions
Projects
Security
Insights

Additional navigation options

Code
Issues
Pull requests
Actions
Projects
Security
Insights

Breadcrumbs

SQL-50

/

2356. Number of Unique Subjects Taught by Each Teacher.sql

Copy path

Latest commit

History

6 lines (4 loc) · 136 Bytes

Breadcrumbs

SQL-50

/

2356. Number of Unique Subjects Taught by Each Teacher.sql

File metadata and controls

6 lines (4 loc) · 136 Bytes

1

2

3

4

5

6

# Write your MySQL query statement below

SELECT teacher_id , COUNT(DISTINCT(subject_id)) AS cnt

FROM Teacher

GROUP BY teacher_id

Footer

© 2025 GitHub, Inc.

Footer navigation

Terms
Privacy
Security
Status
Docs
Contact

You can’t perform that action at this time.