Transcription of Introduction to SQL - Yale University
{{id}} {{{paragraph}}}
Example: biology
Introduction to SQL - Yale University
C H A P T E R3 Introduction to the following queries inSQL, using the University schema. (We sug-gest you actually run these queries on a database, using the sample datathat we provide on the Web site of the book, Instructions forsetting up a database, and loading sample data, are providedon the aboveWeb site.)a. Find the titles of courses in the comp . Sci. department that have Find theIDs of all students who were taught by an instructor namedEinstein; make sure there are no duplicates in the Find the highest salary of any Find all instructors earning the highest salary (there may be morethan one with the same salary).e. Find the enrollment of each section that was offered in Autumn Find the maximum enrollment, across all sections, in Autumn Find the sections that had the maximum enrollment in Autumn :a.
Introduction to SQL Exercises ... Increase the salary of each instructor in the Comp. Sci. department by 10%. b. Delete all courses that have never been offered ...
Loading..
Tags:
Information
Domain:
Source:
Link to this page:
Please notify us if you found a problem with this document: