Database Systems Concepts 7th Edition Solutions is a highly recommended book for people interested in databases. The free version of this book can be downloaded from HERE.
3.1 Write the following queries in SQL, using the university schema. (We suggest you actually run these queries on a database, using the sample data that we provide on the web site of the book, db-book.com. Instructions for setting up a database, and loading sample data, are provided on the above web site.)
a. Find the titles of courses in the Comp. Sci. department that have 3 credits.
Selects title of courses which matches with Com.Sci and the credits it has equals to 3.
b. Find the IDs of all students who were taught by an instructor named Einstein; make sure there are no duplicates in the result.
Selects No Duplicate (Distinct) IDs on all the Students who Einstein taught
c. Find the highest salary of any instructor (there may be more than one Instructor earning the highest salary).
Selects Max Salary of Instructor Table.
d. Find all instructors earning the highest salary (there may be more than one with the same salary).
e. Find the enrollment of each section that was offered in Fall 2017.
f. Find the maximum enrollment, across all sections, in Fall 2017.
g. Find the sections that had the maximum enrollment in Fall 2017.
Other Questions Related to Database Systems Concepts 7th Edition Solutions – Chapter 3 are going to be Posted Sooner.
Data Structures related posts visit HERE
Python-related posts Visit HERE
C/C++ related posts Visit HERE
Databases related posts Visit HERE
Algorithms related posts visit HERE
Data Science related posts visit HERE