Appendix A: Database to be used for SQL select problemsSTUDENTNameStudent_numberClassMajorCSSmith171Brown8CSCOURSECourse_nameCourse numberCredit hoursDepartmentIntro to Computer ScienceCS13104CSData StructuresCS33204CSDiscrete MathematicsMATH24103MATHDatabaseCS33803CSSECTIONSection_identifier Course_numberSemesterYearInstructor85MATH2410Fall07King92CS1310Fall07Anderson102CS3320Spring08Knuth112MATH2410Fall08Chang119CS1310Fall08Anderson135CS3380Fall08StoneGRADE REPORTStudent_numberSection_identifierGrade1711217119C858.9281028135APREREQUISITECourse_numberPrerequisite_numberCS3380CS3320CS3380MATH2410CS3320CS1310Ex 5) Write SQL statement to retrieve the names of all students who took both sections 112 and119. Show the result of this query applied to the given DB state.ANSWER:Ex 6) Write SQL statement to retrieve the names of all freshman students majoring in computerscience. (Freshman students have class = 1).ANSWER:

A query is a question or inquiry about a set of data.

Answered: Ex 5) Write SQL statement to retrieve…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

i.Write an SQL query to fetch “FIRST_NAME” from Worker table using the alias name as <WORKER_NAME>. ii.Write an SQL query to fetch unique values of DEPARTMENT from Worker table.
Create an anonymous block in PL/SQL to list all the countries from Country table where Currency contain keyword ‘Dollar’. Perform following steps: Create user define type with name of the country, currency.Type should contain datatype for name and currency using %type only.Display should include Name of the country, currency code using user defined type. Filter for the data : All the countries from Country table where Currency contain keyword ‘Dollar’.
Is this statement true of false? In SQL, the SELECT statement, the HAVING clause, and the WHERE clause all correspond to a single operator in relational algebra.
QUESTION 12 Fill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program declare employeeRecord employee%TYPE: ename varchar2; begin fetch ename, salary inside employeeRecord from employee where enum= 'ES: DBMS OUTPUT.PUT_LINE(employee.ename" | employee.Salary): end:
Convert the following statements into SQL queries. 1) i want to retrieve all records from a table student. 2) i want to retrieve all record from a table "student" who have marks greater than 80. 3) i want to delete all records from a table "student"
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
Write an SQL statement to add a CHECK constraint to the PET table so that the weight data recorded in the PetWeight column you added to the table in either question 3.47 or 3.49 is less than 250.
Use SQL Developer.
q5) Examine the EMPLOYEES table and the given SQL statement: EID Name Dept Salary 1001 Aminah IT 600 1002 Zainab Admin 400 1003 Tafal IT SELECT Name, Dept, SalaryFROM employeesWHERE name LIKE ‘_a%’ AND salary IS NULL; Which of the following will be the output after executing the statement? a. Name Dept Salary Tafal IT b. Name Dept Salary Zainab Admin 400 c. Name Dept Salary Aminah IT 600 d. Name Dept Salary Aminah IT 600 Zainab Admin 400
Schema: Frequents(kid, store) Sells(store, candy) Likes(kid, candy) d) Use SQL to list the names of all the candies that are liked by at least one kid, along with the names of the stores that sell them. Sort the result in alphabetical order by candy name.
Write the appropriate SQL query for each of the following questions: 1) Display details of ALL the clubs running by the college 2) Display the details of the IT club (IT is the name of the club)
Hi really need help with this assignment Oracle 12c: SQL Chapter 8 Question 6 6. List the title and publish date of any computer book published in 2005. Perform the task of searching for the publish date by using three different methods: a) a range operator b a logical operator, and c) a search pattern operation. Submit three different queries.

SEE MORE QUESTIONS

Recommended textbooks for you

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

Database System Concepts

Computer Science

ISBN:

9780078022159

Author:

Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:

McGraw-Hill Education

Starting Out with Python (4th Edition)

Computer Science

ISBN:

9780134444321

Author:

Tony Gaddis

Publisher:

PEARSON

Digital Fundamentals (11th Edition)

Computer Science

ISBN:

9780132737968

Author:

Thomas L. Floyd

Publisher:

PEARSON

C How to Program (8th Edition)

Computer Science

ISBN:

9780133976892

Author:

Paul J. Deitel, Harvey Deitel

Publisher:

PEARSON

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781337627900

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

Programmable Logic Controllers

Computer Science

ISBN:

9780073373843

Author:

Frank D. Petruzella

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS