DBMS · OPPE

Books by publisher

OPPE 1 · · Python

Book age in years

OPPE 1 · · SQL

Books per Publisher

OPPE 1 · · Python

Book copies and their titles

OPPE 1 · · SQL

Count Students in a Department

OPPE 1 · · Python

Computer Science courses

OPPE 1 · · SQL

Course Catalog Lookup

OPPE 1 · · Python

Contact numbers of students and faculty

OPPE 1 · · SQL

Courses Offered by a Department

OPPE 1 · · Python

Copies held per book

OPPE 1 · · SQL

Courses Taught by a Department's Instructors

OPPE 1 · · Python

Courses mentioning machine (case-insensitive)

OPPE 1 · · SQL

Department Details by Name

OPPE 1 · · Python

Distinct home jersey colours

OPPE 1 · · SQL

Department Office Lookup

OPPE 1 · · Python

Every team appearance across matches

OPPE 1 · · SQL

Instructors of a Department by Salary

OPPE 1 · · Python

Highest host score in any match

OPPE 1 · · SQL

Roster of a Team

OPPE 1 · · Python

Home goals scored per host team

OPPE 1 · · SQL

Squad Roster by Jersey Number

OPPE 1 · · Python

Instructor monthly salary

OPPE 1 · · SQL

Squad size of a team

OPPE 1 · · Python

Instructor names in uppercase

OPPE 1 · · SQL

Team by home city

OPPE 1 · · Python

Instructors above the overall average salary

OPPE 1 · · SQL

Team jersey colors

OPPE 1 · · Python

Instructors and their department building

OPPE 1 · · SQL

Average Instructor Salary by Department

OPPE 1 · · Python

Instructors in Computer Science

OPPE 1 · · SQL

Books by an Author

OPPE 1 · · Python

Managers and the cities they manage in

OPPE 1 · · SQL

Building Classroom Capacity Summary

OPPE 1 · · Python

Match score difference

OPPE 1 · · SQL

Catalogue Snapshot for a Year

OPPE 1 · · Python

Member borrowing quotas

OPPE 1 · · SQL

Enrolments With a Given Grade

OPPE 1 · · Python

Newest books in the catalogue

OPPE 1 · · SQL

Home Matches of a City's Team

OPPE 1 · · Python

Non-PhD students

OPPE 1 · · SQL

Instructors Earning At Least a Threshold

OPPE 1 · · Python

Number of physical book copies

OPPE 1 · · SQL

Issues by Member Class

OPPE 1 · · Python

Players by jersey number

OPPE 1 · · SQL

Manager of a City's Team

OPPE 1 · · Python

Players from the Pune team

OPPE 1 · · SQL

Manager of the city's team

OPPE 1 · · Python

Players on each team

OPPE 1 · · SQL

Matches Hosted in a City

OPPE 1 · · Python

Players with their team

OPPE 1 · · SQL

Members of a given class with quota

OPPE 1 · · Python

Quotas allowing 4+ books

OPPE 1 · · SQL

Physical Copies by Publisher

OPPE 1 · · Python

Referees with a recorded birth date

OPPE 1 · · SQL

Players per team above a jersey number

OPPE 1 · · Python

Staff joining month

OPPE 1 · · SQL

Players Up To a Jersey Number

OPPE 1 · · Python

Students and their departments

OPPE 1 · · SQL

Publisher Catalogue Summary

OPPE 1 · · Python

Students per department

OPPE 1 · · SQL

Sections of a Course

OPPE 1 · · Python

Teams based in Nagpur

OPPE 1 · · SQL

Sections Scheduled in a Building

OPPE 1 · · Python

Teams in cities starting with P

OPPE 1 · · SQL

Students in a department

OPPE 1 · · Python

Teams outside Pune and Leh

OPPE 1 · · SQL

Total runs scored by a team

OPPE 1 · · Python

Ten earliest published books

OPPE 1 · · SQL

Borrowing Capacity by Member Class

OPPE 1 · · Python

Top five highest-paid instructors

OPPE 1 · · SQL

Loans by Member Class

OPPE 1 · · Python

Total number of players

OPPE 1 · · SQL

Matches From a Given Date Onward

OPPE 1 · · Python

Author full names

OPPE 1 · · SQL

Referee Assignments for a Host Team

OPPE 1 · · Python

Average department budget

OPPE 1 · · SQL

Wins of the team based in a city

OPPE 1 · · Python

Buildings named by rooms or departments

OPPE 1 · · SQL

Youngest player of a team

OPPE 1 · · Python

Busy head referees

OPPE 1 · · SQL

Catalogued titles that have copies

OPPE 1 · · SQL

Count of home wins

OPPE 1 · · SQL

Course titles containing 'in'

OPPE 1 · · SQL

Courses offered in 2024

OPPE 1 · · SQL

Departments with high average salary

OPPE 1 · · SQL

Distinct publication years, newest first

OPPE 1 · · SQL

Distinct publishers in the catalogue

OPPE 1 · · SQL

Distinct semesters offered

OPPE 1 · · SQL

Faculty joining year

OPPE 1 · · SQL

Fall sections or any 2025 section

OPPE 1 · · SQL

Five most senior staff

OPPE 1 · · SQL

Head referee of each match

OPPE 1 · · SQL

Highest combined-score matches

OPPE 1 · · SQL

Instructor name lengths

OPPE 1 · · SQL

Instructors who actually teach

OPPE 1 · · SQL

Letter grade to grade points

OPPE 1 · · SQL

Loan length category

OPPE 1 · · SQL

Longest-serving manager

OPPE 1 · · SQL

100

Match result label

OPPE 1 · · SQL

101

Match scorelines with team names

OPPE 1 · · SQL

102

Matches played in August

OPPE 1 · · SQL

103

Matches scoring above the host average

OPPE 1 · · SQL

104

Matches where both sides scored

OPPE 1 · · SQL

105

Member linked reference

OPPE 1 · · SQL

106

Members who never borrowed

OPPE 1 · · SQL

107

Members with a generous book quota

OPPE 1 · · SQL

108

Members with several books out

OPPE 1 · · SQL

109

Most recent book issue date

OPPE 1 · · SQL

110

Player first names

OPPE 1 · · SQL

111

Players by mid-range jersey number

OPPE 1 · · SQL

112

Publishers with multiple titles

OPPE 1 · · SQL

113

Salary range of instructors

OPPE 1 · · SQL

114

Sections offered each semester

OPPE 1 · · SQL

115

Student class standing

OPPE 1 · · SQL

116

Students and their advisors

OPPE 1 · · SQL

117

Students by credits then name

OPPE 1 · · SQL

118

Students enrolled in multiple courses

OPPE 1 · · SQL

119

Students outside the best-funded department

OPPE 1 · · SQL

120

Students with at least one enrolment

OPPE 1 · · SQL

121

Teammate pairs

OPPE 1 · · SQL

122

Teams and their away fixtures

OPPE 1 · · SQL

123

Teams that both hosted and visited

OPPE 1 · · SQL

124

Teams that have hosted a match

OPPE 1 · · SQL

125

Teams with a full squad

OPPE 1 · · SQL

126

Top-grade enrolments

OPPE 1 · · SQL

127

Total credits offered

OPPE 1 · · SQL

128

Total points scored in the season

OPPE 1 · · SQL

129

Well-paid instructors

OPPE 1 · · SQL

130

Who teaches which course

OPPE 1 · · SQL

131

Above their department's average pay

OPPE 1 · · SQL

132

Advanced courses by ID number

OPPE 1 · · SQL

133

Average salary of high earners

OPPE 1 · · SQL

134

Book return due date

OPPE 1 · · SQL

135

Home points earned per team

OPPE 1 · · SQL

136

Oldest player on each team

OPPE 1 · · SQL

137

Player ages in whole years

OPPE 1 · · SQL

138

Third to fifth oldest players

OPPE 1 · · SQL

139

Took CS but never Maths

OPPE 1 · · SQL

140

Total matches played by each team

OPPE 1 · · SQL

141

User details

OPPE 1 · · SQL

142

User names email addresses registered users

OPPE 1 · · SQL

143

Total count products listed product inventory

OPPE 1 · · SQL

144

Order IDs dates with names users placed

OPPE 1 · · SQL

145

Total quantity sold per product orders

OPPE 1 · · SQL

146

Names users made payments Credit Card method

OPPE 1 · · SQL

147

Total amount paid by user

OPPE 1 · · SQL

148

Product name alongside its category name

OPPE 1 · · SQL

149

Order IDs user names orders placed 2022-02-18

OPPE 1 · · SQL

150

Average rating per product user reviews

OPPE 1 · · SQL

151

Street address city state country user with ID

OPPE 1 · · SQL

152

Product details item with highest price

OPPE 1 · · SQL

153

Count reviews written by user

OPPE 1 · · SQL

154

Total amount spent by user with ID U0005

OPPE 1 · · SQL

155

Names users not placed any orders

OPPE 1 · · SQL

156

Product names available stock quantity

OPPE 1 · · SQL

157

Count orders placed by user

OPPE 1 · · SQL

158

Names users made at least one payment

OPPE 1 · · SQL

159

Total monetary amount received through Credit Card

OPPE 1 · · SQL

160

Names users submitted reviews products

OPPE 1 · · SQL

161

Average price products within category

OPPE 1 · · SQL

162

Total quantity products sold Electronics category

OPPE 1 · · SQL

163

Names top 5 users spent most money

OPPE 1 · · SQL

164

Names users live city New York

OPPE 1 · · SQL

165

Product highest inventory quantity

OPPE 1 · · SQL

166

Names users not made any payments

OPPE 1 · · SQL

167

Total revenue generated orders Quantity Price

OPPE 1 · · SQL

168

Names users placed orders more than one distinct

OPPE 1 · · SQL

169

Name user placed highest number orders

OPPE 1 · · SQL

170

Names users ratings products

OPPE 1 · · SQL

171

Count products average product price per category

OPPE 1 · · SQL

172

Top 5 best-selling products total quantity ordered

OPPE 1 · · SQL

173

Detailed report per order containing order ID user

OPPE 1 · · SQL

174

Total revenue generated month formatted YYYY-MM payment

OPPE 1 · · SQL

175

Count orders total calculated spend quantity price average

OPPE 1 · · SQL

176

Names products stock quantity strictly less than 10

OPPE 1 · · SQL

177

Product with highest average rating including its category

OPPE 1 · · SQL

178

Match date host team name host team score

OPPE 1 · · SQL

179

Match number date host team name guest team

OPPE 1 · · SQL

180

Goals GF Goals Against GA Goal Difference GD

OPPE 1 · · SQL

181

Any instances where multiple players within same team

OPPE 1 · · SQL

182

Names managers team names number years managing team

OPPE 1 · · SQL

183

Names referees served main referee at least two

OPPE 1 · · SQL

184

Count number teams located city

OPPE 1 · · SQL

185

Names players born after January 1 2000 with

OPPE 1 · · SQL

186

Match return match number result label HOST_WIN GUEST_WIN

OPPE 1 · · SQL

187

Name manager managing team with highest Goal Difference

OPPE 1 · · SQL

188

Names dates birth youngest oldest referees labeling

OPPE 1 · · SQL

189

Per referee list name count times served main

OPPE 1 · · SQL

190

Per team find player with highest jersey number

OPPE 1 · · SQL

191

Book titles count physical copies available library

OPPE 1 · · SQL

192

Per book title count how many distinct authors

OPPE 1 · · SQL

193

Details issued copies including member number accession

OPPE 1 · · SQL

194

Members issued more books than allowed quota

OPPE 1 · · SQL

195

Roll number name date birth students birthday falls

OPPE 1 · · SQL

196

Per department provide count students broken down by

OPPE 1 · · SQL

197

Per current book issue calculate days elapsed since

OPPE 1 · · SQL

198

Top 3 book titles issued most

OPPE 1 · · SQL

199

First last names faculty members do not any

OPPE 1 · · SQL

200

Average number books issued per student grouped by

OPPE 1 · · SQL

201

Per book title list count physical copies number

OPPE 1 · · SQL

202

Count number staff members grouped by gender year

OPPE 1 · · SQL

203

Per department identify book title issued most by

OPPE 1 · · SQL

204

Books title contains any words Data Database SQL

OPPE 1 · · SQL

205

User name by ID

OPPE 1 · · Python

206

Player manager and leap-year check

OPPE 1 · · Python

207

User mobile number by ID

OPPE 1 · · Python

208

Student department and birth-year parity

OPPE 1 · · Python

209

Referee name by ID

OPPE 1 · · Python

210

Players with prime jersey numbers

OPPE 1 · · Python

211

Encoded team IDs by jersey colour

OPPE 1 · · Python

212

Player jersey number

OPPE 1 · · Python

213

Student roll number

OPPE 1 · · Python

214

First names last names authors author's first name

OPPE 1 · · SQL

215

Titles publishers books except ones published year 2015

OPPE 1 · · SQL

216

First names last names students birthday May 2002

OPPE 1 · · SQL

217

Count members UG with alias name column header

OPPE 1 · · SQL

218

Female students by department code

OPPE 1 · · SQL

219

Names date-of-births managers joined years 2019 2020

OPPE 1 · · SQL

220

Names teams where last name team starts with

OPPE 1 · · SQL

221

Name dept name salary instructors where department name

OPPE 1 · · SQL

222

Names players start with S but does not

OPPE 1 · · SQL

223

Count players playing team id T0001

OPPE 1 · · SQL

224

Natural join between tables students departments

OPPE 1 · · SQL

225

Details instructors Accounting department more salary than

OPPE 1 · · SQL

226

Manager's date birth dob team Shlok plays

OPPE 1 · · SQL

227

Match number match num played playground Emirates Stadium

OPPE 1 · · SQL

228

Name player id date birth city players played

OPPE 1 · · SQL

229

Name teams belong same city team Amigos

OPPE 1 · · SQL

230

Name department Gita Das studying

OPPE 1 · · SQL

231

Roll number male students department building Block_2

OPPE 1 · · SQL

232

First name last name roll number students department

OPPE 1 · · SQL

233

Details members not issued any books

OPPE 1 · · SQL

234

Name courses taught both Fall semester Spring semester

OPPE 1 · · SQL

235

Number students studied building 2005 till 2008 including

OPPE 1 · · SQL

236

Dates when one more copies book title Learning

OPPE 1 · · SQL

237

Let D set departments average salary more than

OPPE 1 · · SQL

238

Number courses taught Fall semester but never Spring

OPPE 1 · · SQL

239

Name id num count instructor s taught maximum

OPPE 1 · · SQL

240

Names fourth referees fourth referee match number matches

OPPE 1 · · SQL

241

Name oldest player team named Stars

OPPE 1 · · SQL

242

Name manager team Stars

OPPE 1 · · SQL

243

All team names

OPPE 1 · · SQL

244

Titles books authored by author first name Joh

OPPE 1 · · SQL

245

Titles books published by McGraw Hill Education

OPPE 1 · · SQL

246

First name last name students student_fname student_lname

OPPE 1 · · SQL

247

Names teams played more than 3 matches

OPPE 1 · · SQL

248

Number book-titles issued 11th August 2021

OPPE 1 · · SQL

249

Names faculty faculty_fname faculty_lname did not issue

OPPE 1 · · SQL

250

Unique book titles issued PG students but not

OPPE 1 · · SQL

251

Players with prime jersey numbers (2)

OPPE 1 · · Python

252

Student roll number (2)

OPPE 1 · · Python

253

Team playground by ID

OPPE 1 · · Python