LEARN MORE...

Access Millions of academic & study documents

6 Find all New York and New Jersey students Display student ID, la

Content type
User Generated
Showing Page:
1/2
6. Find all New York and New Jersey students. Display
student ID, last name, first name, and state. 7. For each
course ID, display the maximum count in descending
order. 8. Display all instructors and how many sections
they teach. 9. Show the total enrollment for course CIS253
in a column named TOTAL ENROLLED. 10. Display course
title, total capacity and number of sections in each course,
where there is more than 1 section. 11. Create a view
CSinstructors, showing all information about instructors
from the Computer Science department. 12. Find students
who are born in the month of October.
Solution
let us assume the table name as COLLEGE
6. SELECT student_id,last_name,first_name,state from
COLLEGE WHERE (state=\'New York\' OR state=\'New
Jersey\');
7. SELECT course_id,MAX(maxcount) AS MaximumCount
from COLLEGE GROUP BY course_id ORDER BY
MaximumCount desc;
8. SELECT instructors,COUNT(course_id) from COLLEGE;
9. SELECT COUNT(student_id) from COLLEGE WHERE
course_id=\'CIS253\';
10. SELECT title,total_students,no_sections from

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/2

Sign up to view the full document!

lock_open Sign Up
Unformatted Attachment Preview
6. Find all New York and New Jersey students. Display student ID, last name, first name, and state. 7. For each course ID, display the maximum count in descending order. 8. Display all instructors and how many sections they teach. 9. Show the total enrollment for course CIS253 in a column named TOTAL ENROLLED. 10. Display course title, total capacity and number of sections in each course, where there is more than 1 section. 11. Create a view CSinstructors, showing all information about instructors from the Computer Science department. 12. Find students who are born in the month of October. So ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4

Similar Documents

Academic Letter for English Writing 1A
At the start of a new class, it is wise to consider why you are taking a class, what your previous experience is with the ...
helpp.......................................................
who is the president of india?...
Help with English, please
I need help with writing something. My teacher showed us a short clip of "dead poet society." In the clip, the teacher tel...
University of Toronto Monitoring Kids’ Social Media Accounts Paper
This assignment is designed to offer the opportunity to practice the skills that we discussed in Chapter one and two. The ...
Identification of Flaws in Research Methodology in A News Article Discussion
please write out at least 3 sentences to answer the questions belowBad research leads to bad decision making for businesse...
PSU Primary Genre Choice of The Genre & Translation Reflection Discussion
help me to modify the document 1(it's already 800 words), make it into 900-1000 words(4-5page) based on the original text ...
Diab retinopathy
...
134 bus fpx3040 assessment4 1 docx
When hiring new employees, base pay or salary can be a determining factor in whether a potential new hire accepts a positi...
Past Board Exam Problems in Strength of Materials
An iron column of annular crosssection has an outer diameter of 200 A steel tie rod on a bridge must be...