›Programming in Python
›Database Management Systems
›Programming, DS & Algorithms
›Programming in Java
›Programming in C
›System Commands

›Programming in Python
›Database Management Systems
›Programming, DS & Algorithms
›Programming in Java
›Programming in C
›System Commands

›Programming in Python
›Database Management Systems
›Programming, DS & Algorithms
›Programming in Java
›Programming in C
›System Commands

Leaderboard Contact us Privacy

Students per department — DBMS OPPE Question

Database Management Systems

All jersey colours in use
Book age in years
Book copies and their titles
Computer Science courses
Contact numbers of students and faculty
Copies held per book
Courses mentioning machine (case-insensitive)
Distinct home jersey colours
Every team appearance across matches
Highest host score in any match
Home goals scored per host team
Instructor monthly salary
Instructor names in uppercase
Instructors above the overall average salary
Instructors and their department building
Instructors in Computer Science
Managers and the cities they manage in
Match score difference
Member borrowing quotas
Newest books in the catalogue
Non-PhD students
Number of physical book copies
Players by jersey number
Players from the Pune team
Players on each team
Players with their team
Quotas allowing 4+ books
Referees with a recorded birth date
Staff joining month
Students and their departments
Students per department
Teams based in Nagpur
Teams in cities starting with P
Teams outside Pune and Leh
Ten earliest published books
Top five highest-paid instructors
Total number of players
Author full names
Average department budget
Buildings named by rooms or departments
Busy head referees
Catalogued titles that have copies
Count of home wins
Course titles containing 'in'
Courses offered in 2024
Departments with high average salary
Distinct publication years, newest first
Distinct publishers in the catalogue
Distinct semesters offered
Faculty joining year
Fall sections or any 2025 section
Five most senior staff
Head referee of each match
Highest combined-score matches
Instructor name lengths
Instructors who actually teach
Letter grade to grade points
Loan length category
Longest-serving manager
Match result label
Match scorelines with team names
Matches played in August
Matches scoring above the host average
Matches where both sides scored
Member linked reference
Members who never borrowed
Members with a generous book quota
Members with several books out
Most recent book issue date
Player first names
Players by mid-range jersey number
Publishers with multiple titles
Salary range of instructors
Sections offered each semester
Student class standing
Students and their advisors
Students by credits then name
Students enrolled in multiple courses
Students outside the best-funded department
Students with at least one enrolment
Teammate pairs
Teams and their away fixtures
Teams that both hosted and visited
Teams that have hosted a match
Teams with a full squad
Top-grade enrolments
Total credits offered
Total points scored in the season
Well-paid instructors
Who teaches which course
Above their department's average pay
Advanced courses by ID number
Average salary of high earners
Book return due date
Home points earned per team
Oldest player on each team
Player ages in whole years
Third to fifth oldest players
Took CS but never Maths
Total matches played by each team
User details
User names email addresses registered users
Total count products listed product inventory
Order IDs dates with names users placed
Total quantity sold per product orders
Names users made payments Credit Card method
Total amount paid by user
Product name alongside its category name
Order IDs user names orders placed 2022-02-18
Average rating per product user reviews
Street address city state country user with ID
Product details item with highest price
Count reviews written by user
Total amount spent by user with ID U0005
Names users not placed any orders
Product names available stock quantity
Count orders placed by user
Names users made at least one payment
Total monetary amount received through Credit Card
Names users submitted reviews products
Average price products within category
Total quantity products sold Electronics category
Names top 5 users spent most money
Names users live city New York
Product highest inventory quantity
Names users not made any payments
Total revenue generated orders Quantity Price
Names users placed orders more than one distinct
Name user placed highest number orders
Names users ratings products
Count products average product price per category
Top 5 best-selling products total quantity ordered
Detailed report per order containing order ID user
Total revenue generated month formatted YYYY-MM payment
Count orders total calculated spend quantity price average
Names products stock quantity strictly less than 10
Product with highest average rating including its category
Match date host team name host team score
Match number date host team name guest team
Goals GF Goals Against GA Goal Difference GD
Any instances where multiple players within same team
Names managers team names number years managing team
Names referees served main referee at least two
Count number teams located city
Names players born after January 1 2000 with
Match return match number result label HOST_WIN GUEST_WIN
Name manager managing team with highest Goal Difference
Names dates birth youngest oldest referees labeling
Per referee list name count times served main
Per team find player with highest jersey number
Book titles count physical copies available library
Per book title count how many distinct authors
Details issued copies including member number accession
Members issued more books than allowed quota
Roll number name date birth students birthday falls
Per department provide count students broken down by
Per current book issue calculate days elapsed since
Top 3 book titles issued most
First last names faculty members do not any
Average number books issued per student grouped by
Per book title list count physical copies number
Count number staff members grouped by gender year
Per department identify book title issued most by
Books title contains any words Data Database SQL
First names last names authors author's first name
Titles publishers books except ones published year 2015
First names last names students birthday May 2002
Count members UG with alias name column header
Female students by department code
Names date-of-births managers joined years 2019 2020
Names teams where last name team starts with
Name dept name salary instructors where department name
Names players start with S but does not
Count players playing team id T0001
Natural join between tables students departments
Details instructors Accounting department more salary than
Manager's date birth dob team Shlok plays
Match number match num played playground Emirates Stadium
Name player id date birth city players played
Name teams belong same city team Amigos
Name department Gita Das studying
Roll number male students department building Block_2
First name last name roll number students department
Details members not issued any books
Name courses taught both Fall semester Spring semester
Number students studied building 2005 till 2008 including
Dates when one more copies book title Learning
Let D set departments average salary more than
Number courses taught Fall semester but never Spring
Name id num count instructor s taught maximum
Names fourth referees fourth referee match number matches
Name oldest player team named Stars
Name manager team Stars
All team names
Titles books authored by author first name Joh
Titles books published by McGraw Hill Education
First name last name students student_fname student_lname
Names teams played more than 3 matches
Number book-titles issued 11th August 2021
Names faculty faculty_fname faculty_lname did not issue
Unique book titles issued PG students but not

Students per department

00:00

Using the student table, count how many students belong to each department. Return dept_name and the count as num_students, one row per department.

Order the result by num_students (highest first), then by dept_name.

Database schema


primary keyforeign keyarrow points to the referenced columndrag to pan

SQL

13

Unsolved