Scribd
Upload
12 views10 pages

SQL Exercises by Murat Kantarcioglu

This document provides examples of SQL queries to retrieve information from tables representing classes, students, and faculty. The tables are created and sample queries demonstrate how to find student enrollments, faculty assignments, and other data relationships across the tables.

Uploaded by

Gunasekaran
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
12 views10 pages

SQL Exercises by Murat Kantarcioglu

This document provides examples of SQL queries to retrieve information from tables representing classes, students, and faculty. The tables are created and sample queries demonstrate how to find student enrollments, faculty assignments, and other data relationships across the tables.

Uploaded by

Gunasekaran
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

SQL Examples

Murat Kantarcioglu
Exercise 5.1
Create Tables
create table class(
create table student( name varchar(40) primary key,
snum numeric(9,0) primary key, meets_at varchar(20),
sname varchar(30), room varchar(10),
fid numeric(9,0),
major varchar(25), foreign key (fid) references faculty(fid)
standing varchar(2), );
age numeric(3,0)
create table enrolled(
); snum numeric(9,0),
create table faculty( cname varchar(40),
fid numeric(9,0) primary key, primary key(snum,cname),
foreign key (snum) references
fname varchar(30), student(snum),
deptid numeric(2,0) foreign key (cname) references
); class(name)
);
Exercise 5.1

4) Find the names of all students who are enrolled in two classes that meet at the
same time.
Exercise 5.1

5) Find the names of faculty members who teach in every room in which some class
is taught.
Exercise 5.1

6) Find the names of faculty members for whom the combined enrollment of the
courses that they teach is less than five.
Exercise 5.1

9) For each faculty member that has taught classes only in room R128, print the
faculty member’s name and the total number of classes she or he has taught.
Exercise 5.1

11) Find the names of students not enrolled in any class.


Exercise 5.1

12) For each age value that appears in Students, find the level value
that appears most often. For example, if there are more FR level
students aged 18 than SR, JR, or SO students aged 18,
you should print the pair (18, FR).
Exercise 5.1

You might also like