Write and Execute SELECT statements to getthe following information(Please print out and tum in all the SQL codethat you wrote to get the answers to these questions or problems, youdo not need to tun in the answers, just SQL code).Problems:Courses Table :• List of all courses with CourseNo, Name andCreditHours.• List of courses, all columns, with only 3 credit hours.• List of courses, name and credit hours only, withcredit hours > 3.Instructors Table :• List of Instructors, only fname and Iname, fromGeorgia.• List of all instructors not from Georgia.• List of instructors, just name and office and emailfrom Florida.• List all instructors, id, Iname and email with headings"D#", "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 andgpa, 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 (justgive first and last names).

ANSWER: Student Table: Syntax of SQL Table Statement

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).

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).

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Classify students according to the total number of hours they have completed. (Less than30=freshman, 30 to 59 is sophomore, 60 to 89 is junior, 90+ senior)
Find the staff name who has the maximum salary for each city.
The Colombia City office of StayWell indicated that there is a new tenant by the name of Yigit Yilmaz staying at the property with an ID of 13. You need to include this new resident in the RESIDENTS table.
use sql please List only the movies that have a value for gross (not NULL values). Include all columns in the result set.
Below are some rows of the PROVIDERS table for a factory: PCODE 10192 98411 0489035 NAME Hans, Inc. Tools and More Motors Inc. PHONE 231 - 3092 231-1029 993 - 1821 All providers from the factory zone of the city start with 231. You want to get the providers that are in the factory zone of the city. Which of the following is more appropriate? O a. O b. SELECT * FROM PROVIDERS WHERE PHONE LIKE '% 231' O C. O d. SELECT * FROM PROVIDERS WHERE PHONE LIKE $231%' SELECT * FROM PROVIDERS WHERE PHONE LIKE 231 SELECT * FROM PROVIDERS WHERE PHONE LIKE '%231%'
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Find the number of staff for each city. Find the staff name who has the minimum salary for each city.
Order of tuples in a table is irrelevant, true or false?
Some rows of the table STUDENT are shown below: CODE NAME DEPARTMENT GPA YEAR 291 ALEX PSI 3.1 1992 938 MICHELE PHY 2.3 1992 931 JHON MD 3.3 2001 182 JOE MD 3.4 2002 190 REY PHY 2.0 2001 330 RON PSI 3.9 2001 You want the name all departments that have a department GPA average of 2004 greater than the global GPA average. Which query gives you the desired result? a. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT); b. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 AND AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT) GROUP BY DEPARTMENT; c. SELECT DEPARTMENT FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT GPA FROM STUDENT GROUP BY DEPARTMENT); d. SELECT * FROM STUDENT WHERE YEAR = 2004 GROUP BY DEPARTMENT HAVING AVG(GPA) > (SELECT AVG(GPA) FROM STUDENT);
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Update table product to set the value of column productType equal to the corresponding id value in the table productType. This requires a SELECT * FROM productType: to see what the id value is for each type. For example, in my database a. 1|meat b. 2| seafood c. 3| vegetable d. 4 grain and rice e. 5 bakery
Instructorld 1 • Courseld CourseCode 9630 MATH109 Course CourseName Linear Algebra Capacity 175 4964 PHILAT Intro to Philosophy 50 4253 MATH19 Number Theory 150 1896 HIST66 American History 25 8048 HIST58 World History 125 2133 Instructor Instructorld InstructorName Rank Department Del Day Associate Professor Math Rob Ruiz Associate Professor Philosophy Aya Diaz Associate Professor History Note: Both tables may not be necessary to complete this level. Select the rows returned by the query below. SELECT CourseName, Capacity, InstructorId FROM Course C WHERE Capacity > (SELECT AVG (Capacity) FROM Course WHERE InstructorId = c.InstructorId); CourseName Linear Algebra Capacity Instructorld 175 1 Intro to Philosophy 50 2 150 Number Theory American History 25 World History 125 2133