1. Insert the following classes\' records Name Description his course introduces
ID: 3686272 • Letter: 1
Question
1. Insert the following classes' records Name Description his course introduces accounting concepts and explores the accounting environment It covers the basic structure of accounting, how to maintain accounts, use account balances to prepare financial statements, and complete the accounting cycle. It also introduces the concept of internal control and how to account for assets CCT306 ccounting 1 Structured Query Language for This course gives complete coverage of SQL, with an emphasis on storage, retrieval S362 ata Management and manipulation of data In this course, students focus on developing writing skills through practice and revision. Students will examine expository, critical, and persuasive essay techni ENG115 FIN322 2. Insert the following advisors' records English Composition This course focuses on investments and investment strategies. Various investment ehicles such as stocks, bonds, and commodities are examined. Students will explore he principles of sec nvestments analysis and valuation Email Name Fred Stone Bob Gordon college.edu co edu ack Simpsonliack@coll 3. Insert the following students' records Name Birthdate ender StartDate GPA sActive Bio dvisorlD rai 1970-03-15 Male 2010-05-30 3.10 ranklin Harriet Smith 1982-04-15 Female 2010-05-30 3.22 es rge avi 1984-11-05 Male 2010-10-01 0.00 The student has gone on emporary leave to pursue other opportunities but plans on returning in 1 year en 1976-09-25 Male 2009-02-21 1.80 Jefferson 4. Delete the course named Investments from the system 5. Change Harriet Smith's birthdate to April 25, 1982 and her GPA to 3.25Explanation / Answer
insert into Classes (ClassCode,ClassName,Description)
values('ACCT306','Accounting 1','This course introduces accounting concepts and explores theaccounting environment.
insert into Classes (ClassCode,ClassName,Description)
values('CS362','Structured Query Language for Data Management',
insert into Classes (ClassCode,ClassName,Description)
values('ENG115','English Composition',' In this course, students focus on developing writingskills through practice and revision. Students will examine expository, critical, and persuasiveessay techniques.')
insert into Classes (ClassCode,ClassName,Description)
values('FIN322','Investments',' This course focuses on investments and investment strategies.
Insert Statement command classes table
insert into Advisors (FirstName,LastName,EmailAddr)
values ('Fred','Stone','XXXXX@XXXXXX.XXX')
insert into Advisors (FirstName,LastName,EmailAddr)
values ('Bob','Gordon','XXXXX@XXXXXX.XXX')
insert into Advisors (FirstName,LastName,EmailAddr)
values ('Jack','Simpson','XXXXX@XXXXXX.XXX')
Insert statement command Advisors table
Insert into Students (FirstName,LastName,BirthDate,Gender,StartDate,GPA,IsActive,AdvisorID)
values ('Craig','Franklin','1970-03-15','M','2010-05-30','3.10','Y','3');
Insert into Students (FirstName,LastName,BirthDate,Gender,StartDate,GPA,IsActive,AdvisorID)
values ('Harriet','Smith','1982-04-15','F','2010-05-30','3.22','Y','1');
Insert into Students (FirstName,LastName,BirthDate,Gender,StartDate,GPA,IsActive,AdvisorID)
values ('George ','David','1984-11-05','M','2010-10-01','0.00','Y','3');
Insert into Students(FirstName,LastName,BirthDate,Gender,StartDate,GPA,IsActive,Bio,AdvisorID)
values ('Ben','Jefferson','1976-09-25','M','2009-02-21','1.80','N','the student has gone ontemporaryleave to pursue other opportunities but plans on returning in 1 year.','3');
update Students SET BirthDate='1982-4-25' , GPA=3.25 where FirstName='Harriet'
Some idea to solve the Question you mentioned,
1.List all active male students assigned to Advisors 1 or 3 (Fred Stone or JackSimpson).
In this statement the select*from students selected all of the rows in the students table.The where describes the requirements shown such as AdvisorID in (1,3) and the andand gender=’M’ statements shows only the Male students displayed.
2.Provide a list of all students without a biography.
This one was a little tricky because when I did my queries for the Students table for IP2.The students that didn’t have bios I just left it blank. When I tried to write a nullstatement nothing showed in the columns. I went back and typed “null” in those areas.
3.What classes are in the English department?
Start by writing the select statement select * from classes to select the classes table.Then write the statement where classcode like “Eng___” to list the class that had ENGin the beginning but may have different numbers.
4.Create a list of all students and their advisors. Sort by the advisor’s name andthen the student’s name. Include the student’s birth date, gender, and GPA.
For this question write the table a period then the row wanted the data listed from also the birthdate, gender, and gpa. The next statement shows that everything listedafter select * is coming from the students and advisors table. Where shows the AdvisorsIDs from the Students and Advisors Table. And order by shows the advisors and students last names in descending order.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.