Display student id, student first name, student last name, the students’ faculty advisor id, advisor last name, advisor location and phone number. You will join uc_student and uc_faculty

 

Write a SELECT statement that will return the faculty last name, faculty first name and the room for faculty whose offices are located in the ‘BUS’ building.

 

Display data from the uc_course_section table by performing a Three Table Join with the uc_course_section, uc_location and uc_course. The SELECT statement will display the course section id (c_sec_id), the course name, number of credits, maximum number of enrollments in a course section, building and room where the class meets and the capacity of the room … and only for courses for term_id 5.

 

 

Write a select statement that will display student id, student last name and the number of courses a student has been enrolled. You will need to join two table, use a COUNT aggregate and a GROUP BY clause in your SELECT statement.

 

Create a SELECT statement that would provide data for a faculty directory. Display should include faculty id, first name, middle initial, last name, office location (building and room), rank and phone number. The display should be sorted by last name ascending. Concatenate first name, middle initial and last name to look like ‘ James E. Smith’. Concatenate building and room to look like ‘ENG102’. Override the column labels with meaningful descriptions.

 

 

IST210 --- World CampusLab # 5 Demonstration of JOINS1.Provide a listing of courses being offered.Include course identification, course name,section identification, term identification and maximum enrollment.selectuc_course.course_id,course_name,c_sec_id,term_id,max_enrlFROMuc_course,uc_course_sectionWHEREuc_course_section.course_id=uc_course.course_id2.For situation in # 1,only display the courses if the course meets onMonday/Wednesday/Fridayselectuc_course.course_id,course_name,c_sec_id,term_id,max_enrlFROMuc_course,uc_course_sectionWHEREuc_course_section.course_id=uc_course.course_idandc_sec_day='MWF'3.Display the grades sorted by term include student identification, student last name, termidentification, course identification and section identification (c_sec_id) and grade.Donot select if no grade exists.selectuc_student.s_id,s_last,course_id,uc_enrollment.c_sec_id,gradeFROMuc_student,uc_course_section,uc_enrollmentWHEREuc_student.s_id=uc_enrollment.s_idANDuc_enrollment.c_sec_id=uc_course_section.c_sec_idANDgradeISNOTNULL4. Display the number of sections that each faculty teaches.Displayfacutly identification,faculty last name and number of coursesections.selectuc_faculty.f_id,f_last,COUNT(*)asNumSectionsFROMuc_faculty,uc_course_sectionWHEREuc_faculty.f_id=uc_course_section.f_idGROUPBYuc_faculty.f_id,f_last5. Display student id and student entire name formatted ‘Smith, James’ withthe labels ‘S#’ and ‘Name’selects_idASS#,s_last+', '+s_firstASNameFROMuc_student

• 1496715132-WC_IST210_LAB_05_demo 1.docx

ComputerScienceExpert

(11)

Status NEW Posted 06 Jun 2017 02:06 AM My Price 9.00

-----------

Attachments

file 1496715135-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer