Write and Execute SELECT statements to get the following information(Please prin

Question

Write and Execute SELECT statements to get the following information(Please print out and turn in all the SQL code that you wrote to get the answers to these questions or problems, you do not need to turn in the answers, just SQL code).

See handout in blackboard, under “Week #3”, for help in using SQL in MS Access.

Problems:

Courses Table :

List of all courses with CourseNo, Name and CreditHours.

List of courses, all columns, with only 3 credit hours.

List of courses, name and credit hours only, with credit hours > 3.

Instructors Table :

List of Instructors, only fname and lname, from Georgia.

List of all instructors not from Georgia.

List of instructors, just name and office and email from Florida.

List all instructors, id, lname and email with headings “ID#”, “Name “and “E-Mail Address”.

Sections Table :

List of Sections with CRN, timedays for instructor 3.

Does roomNo F1149 have any scheduling conflicts?

Does instructor 6 have any scheduling conflicts?

Students Table :

List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to 2.99).

List of students from Georgia or Colorado.

Which students have a B avg from Ga(3.0 to 3.99)?

Give me a list of all the Larry’s that are students (just give first and last names).

Explanation / Answer

Answer)

List of all courses with CourseNo, Name and CreditHours.

select CourseNo, Name, CreditHours from Courses;

List of courses, all columns, with only 3 credit hours.

select * from Courses where CreditHours = 3;

List of courses, name and credit hours only, with credit hours > 3.

select CourseNo, Name, CreditHours where CreditHours > 3;

List of Instructors, only fname and lname, from Georgia.

select fname, lname from Instructors where country = 'Georgia';

List of all instructors not from Georgia.

select fname, lname from Instructors where country != 'Georgia';

List of instructors, just name and office and email from Florida.

select fname, lname, office, email from Instructors where location = 'Florida';

List all instructors, id, lname and email with headings “ID#”, “Name “and “E-Mail Address”

select id as ID#, lname as Name, email as E-Mail_Address from Instructors;

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.