Sign In
Not register? Register Now!
Essay Available:
You are here: HomeCourseworkIT & Computer Science
Pages:
9 pages/≈2475 words
Sources:
No Sources
Level:
Other
Subject:
IT & Computer Science
Type:
Coursework
Language:
English (U.S.)
Document:
MS Word
Date:
Total cost:
$ 65.61
Topic:

SQL IT & Computer Science Coursework Research Paper (Coursework Sample)

Instructions:

THE PAPER IS ABOUT CREATING A MYSQL DATABASE FROM GIVEN DATA AND GENERATING SQL QUERIES

source..
Content:


Databases - SQL
Student’s Name
Institution Affiliation
Question 1
* [Nested query without JOIN] List the unique names of instructors whose name’s the second character is ‘o’ and who have a higher salary than some instructor in the ‘EE’ department.
SELECT instructor.name FROM instructor WHERE instructor.name LIKE '_O%' AND instructor.salary > ( SELECT instructor.salary FROM instructor WHERE instructor.dept_name='EE');
* [single SELECT with JOIN] List the department name (in descending order), and total number of the department’s unique instructors who teach at least one course in the Spring 2018 semester.
SELECT instructor.dept_name,instructor.name,COUNT(instructor.ID) AS TOTAL FROM instructor INNER JOIN teaches ON instructor.ID=teaches.ID WHERE teaches.semester='Spring' AND teaches.year='2018' GROUP BY instructor.dept_name ORDER BY instructor.dept_name DESC;
* [single SELECT with JOIN] For course sections with more than 1 student in some semester in 2018, list the course title (in descending order), section id, semester, and number of students
SELECT course.title,section.sec_id,section.semester,course.credits as Number_of_students FROM course INNER JOIN section ON course.course_id=section.course_id WHERE section.year='2018' ORDER BY course.title DESC

...
Get the Whole Paper!
Not exactly what you need?
Do you need a custom essay? Order right now:

Other Topics:

  • Implementation Procedures For An Educational Typology Known As xACME
    Description: The paper sets out to present implementation guidelines to help xACME educational typology meet user requirements. The project will focus on; Springfield Device and STP Configurations; Worchester Subnetting Configurations and Boston Site Protocol, Route Summarization, and Topology Improvement....
    7 pages/≈1925 words| 11 Sources | Other | IT & Computer Science | Coursework |
  • Software Engineering With Objects Coursework Assignment
    Description: Software engineering assignment which answers questions based on the provided scenarios. it includes functional and non-functional requirements of system...
    1 page/≈275 words| No Sources | Other | IT & Computer Science | Coursework |
  • C++ Code Creates Class Of List Needed To Be Updated
    Description: C++ code IT & Computer Science Coursework: C++ Code Creates Class Of List Needed To Be Updated...
    1 page/≈275 words| No Sources | Other | IT & Computer Science | Coursework |
Need a Custom Essay Written?
First time 15% Discount!