Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sections Table: CIST 1220: SQL - Assign #3 8.) List of Sections with CRN, timedays for instructor 3 . 9.) Does roomNo F1149 have any

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

Sections Table: CIST 1220: SQL - Assign \#3 8.) List of Sections with CRN, timedays for instructor 3 . 9.) Does roomNo F1149 have any scheduling conflicts? (40 Points) 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. 13.) Which students have a B avg from Ga(3.0 to Using the database provided(Access Database is in Blackboard under 3.99)? "Lessons/Week \#3"). Write and Execute SELECT statements to get 14.) Give me a list of all the Larry's that are students the following information(Please print out and turn in all the SQL (just give first and last names). code that you wrote to get the answers to these questions or problems, 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, lname and email with headings "ID\#", "Name "and "E-Mail Address". Courses Create External Data Database Tools Help Table Fields Table O Tell me what you want to do K Microsoft has blocked macros from running because the source of this file is untrusted. Learn More Instructors Sections Kicrosoft has blocked macros from running because the source of this file is untrusted. Learn More Students StudentSchedule StudentSchedule Micheal Anderson Chapter 3 . docx Comments 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Expert Performance Indexing In SQL Server

Authors: Jason Strate, Grant Fritchey

2nd Edition

1484211189, 9781484211182

More Books

Students also viewed these Databases questions