Courses Table: SELECT CourseID, CourseName,CreditHours FROM Courses; SELECT * FROM Courses WHERE CreditHours=3; SELECT CourseName, CreditHours FROM Courses WHERE CreditHours >3; Instructors Table: SELECT fname, Iname FROM Instructors WHERE place=-Georgia; SELECT * FROM Instructors WHERE place!=Georgia; SELECT name,office,email FROM Instructors WHERE place=Florida; SELECT id,lname,email FROM Instructors; Sections Table: SELECT CRN,timedays FROM Sections WHERE instructor=3; SELECT * FROM Sections WHERE roomNo=F1149 IS NOT NULL; SELECT * FROM Sections WHERE instructor=6 IS NOT NULL; Students Table: SELECT FirstName,LastName,gpa AS C FROM Students WHERE avg(gpa) BETWEEN 2 AND 2.99; SELECT * FROM Students WHERE place=-Georgia OR place=Colorado; SELECT * FROM Students WHERE avg(gpa) BETWEEN 3.0 and 3.99; SELECT FirstName,LastName FROM Students WHERE place=Larry; Feedback to Learner 1/31/23 1:03 PM \#4 ( 3 points) Where state = 'GA' need single quotes here. #5 ( 3 points) Where state ' GA ' \#6 ( 3 points) Where state = 'FL' \#7 ( 3 ponts) SELECT ID as [ID \#], LastName as [Name], Email as [Email Address] FROM instructors #9 where roomNo = 'F1149' ( 3 points) \#11 (-3 points) where gps between 2.0 and 2.99 #12 where state in ('GA', 'CO') ( 3 points) \#14 (-3 points) Where firstName = 'Larry' CIST 1220: SQL - Assign \#3 Sections Table: (40 Points) 8.) List of Sections with CRN, timedays for instructor 3 . 9.) Does roomNo F1149 have any scheduling conflicts? 10.) Does instructor 6 have any scheduling conflicts? [Simple SELECT Statements - Chap 3] Students Table : 11.) List of all Students, just FirstName, LastName and gpa, with a C avg(2.0 to 2.99). 12.) List of students from Georgia or Colorado. Using the database provided(Access Database is in Blackboard under 13.) Which students have a B avg from Ga(3.0 to "Lessons/Week \#3"). Write and Execute SELECT statements to get the following information(Please print out and turn in all the SQL 3.99) ? code that you wrote to get the answers to these questions or problems, 14.) Give me a list of all the Larry's that are students you do not need to tum in the answers, just SQL code). See handout in blackboard, under "Week \#3", for help in using SQL in MS Access. Problems: Courses Table : 1.) List of all courses with CourseNo, Name and CreditHours. 2.) List of courses, all columns, with only 3 credit hours. 3.) List of courses, name and credit hours only, with credit hours >3. Instructors Table : 4.) List of Instructors, only fname and Iname, from Georgia. 5.) List of all instructors not from Georgia. 6.) List of instructors, just name and office and email from Florida. 7.) List all instructors, id, Iname and email with headings "ID\#", "Name "and "E-Mail Address". Home Create External Data Database Tools Help Table Fields Table ECURITY RISK Microsoft has blocked macros from running because the source of this file is untrusted. Learn More m