1. CREATE DATABASE MyDB;

2. CREATE TABLE Students
(
	StudentID VARCHAR(8) PRIMARY KEY,
	FirstName VARCHAR(20),
	LastName VARCHAR(20),
	HoursEnrolled INT,
	GPA FLOAT,
	Major VARCHAR(20),
	DOG DATE
);

3. CREATE TABLE Faculty
(
	FacultyID VARCHAR(8) PRIMARY KEY,
	FirstName VARCHAR(20),
	LastName VARCHAR(20),
	Department VARCHAR(20),
	yearsEmployed INT
);

4. CREATE TABLE Course
(
	CourseID VARCHAR(8) PRIMARY KEY,
	CourseName VARCHAR(30),
	TaughtBy VARCHAR(8) REFERENCES Faculty(FacultyID),
	year INT,
	NoEnrolled INT
);

5. INSERT INTO Faculty VALUES ('sjx55', 'Sharanya', 'Jayaraman',  'Computer Science', 4); 

6. INSERT INTO Course VALUES ('cgs3066', 'Web Programming', 'sjx55', 2014, 33); 

7. ALTER TABLE Course ADD Term VARCHAR(10);

8. SELECT * FROM Students WHERE GPA > 3.0 ORDER BY StudentID DESC;

9. SELECT * FROM Course WHERE TaughtBy IN (SELECT FacultyID FROM Faculty WHERE Department = 'Chemistry');

10. SELECT COUNT (StudentID) FROM Students WHERE Major='Math' AND HoursEnrolled < 60;

11. SELECT * FROM Students WHERE DOG > '2015-04-15';

12. SELECT AVG(GPA) FROM Students WHERE Major = 'Physics';

13. SELECT * FROM Faculty WHERE (Department = 'Anthropology' OR Department = 'Archeology') AND yearsEmployed > 15;

14. SELECT Major FROM Students GROUP BY Major HAVING AVG(GPA) > 2.75 ORDER  BY Major;

15. SELECT * FROM Faculty WHERE FacultyID IN (SELECT TaughtBy FROM Course WHERE NoEnrolled > 100 ) ORDER BY LastName, FirstName;

16. DELETE FROM Students WHERE HoursEnrolled > 150;

17. DELETE FROM Course;
    DROP TABLE Course;