DBMS · Practice

01

Authors with single-character first name

PPA · · SQL

Easy Unsolved

02

Book titles except 2015 and 2017

PPA · · SQL

Easy Unsolved

03

Students born in May 2002 or May 2003

PPA · · SQL

Easy Unsolved

04

Total UG members

PPA · · SQL

Easy Unsolved

05

Female students per department

PPA · · SQL

Easy Unsolved

06

Managers who joined in 2019 or 2020

PPA · · SQL

Easy Unsolved

07

Teams whose last word starts with S

PPA · · SQL

Medium Unsolved

08

Instructors sorted by dept and salary

PPA · · SQL

Easy Unsolved

09

Players starting with S but not ending with n

PPA · · SQL

Medium Unsolved

10

Players in team T0001

PPA · · SQL

Easy Unsolved

11

Natural join of students and departments

PPA · · SQL

Easy Unsolved

12

Accounting instructors earning more than some Psychology instructors

PPA · · SQL

Medium Unsolved

13

Manager DOB for Shlok's team

PPA · · SQL

Medium Unsolved

14

Matches at Emirates Stadium

PPA · · SQL

Medium Unsolved

15

Players who played for Rainbow

PPA · · SQL

Easy Unsolved

16

Teams in the same city as Amigos

PPA · · SQL

Medium Unsolved

17

Department of Gita Das

PPA · · SQL

Easy Unsolved

18

Male students in Block 2 departments

PPA · · SQL

Easy Unsolved

19

Students in Block 1 departments

PPA · · SQL

Easy Unsolved

20

Members who never issued a book

PPA · · SQL

Medium Unsolved

21

Courses taught in Fall and Spring

PPA · · SQL

Medium Unsolved

22

Distinct students per building (2005–2008)

PPA · · SQL

Hard Unsolved

23

Issue dates for Learning with Python

PPA · · SQL

Medium Unsolved

24

Top-paid instructors in high-average departments

PPA · · SQL

Hard Unsolved

25

Courses taught in Fall but never Spring

PPA · · SQL

Medium Unsolved

26

Instructors with most Wednesday classes

PPA · · SQL

Hard Unsolved

27

Fourth referees on 2020-05-19

PPA · · SQL

Medium Unsolved

28

Research scholars who never issued books

PPA · · SQL

Hard Unsolved

29

Oldest player from All Stars

PPA · · SQL

Medium Unsolved

30

Books issued to PG but not UG students

PPA · · SQL

Hard Unsolved