SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 206 Weeks Ago, 2 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 26 Mar 2018 My Price 10.00

Advanced SQL techniques to writing queries

I just need this done in word like the assignment says. Let me know if there are any questions.

 

 
Homework #6
 
This homework assignment is about applying Advanced SQL techniques to writing queries. A table with sample data is provided to you. Part 1 requires you to determine the results of a query using advanced SQL. Part 2 requires you to write a query that will produce the desired results. Submit your homework in a Microsoft Word document to UNM Learn.
 
Class Table and Data
The Class table contains information about students, classes and grades. In this example, we are not concerned with normalizations. The goal is the use the data provided and write SQL statements to view the desired output. The score attribute is a number data type, the DOB attribute is a date data type and all other attributes are string data types. 
 
Class
classID fName lName DOB className Score Grade
MGMT329 Aaron French 04/04/1950 Database 98 A
MGMT329 Jessica McMurphy 05/29/1990 Database 85 B
MGMT329 Michael Johnson 07/02/1989 Database 92 A
MGMT329 Lebron West 07/21/1992 Database 74 C
MGMT329 Steven McGiver 03/13/1989 Database 79 C
MGMT329 Amanda Stephenson 04/19/1992 Database 88 B
MGMT329 Jeremy Jones 07/15/1991 Database 90 A
MGMT450 Amanda Stephenson 04/19/1992 Computer Based IS 83 B
MGMT450 Samantha Givens 09/11/1988 Computer Based IS 86 B
MGMT450 Leslie McRoberts 05/30/1989 Computer Based IS 94 A
MGMT450 Jeremy Jones 07/15/1991 Computer Based IS 75 C
MGMT450 Brittany Davidson 12/24/1990 Computer Based IS 91 A
MGMT450 William O’Connell 01/07/1992 Computer Based IS 97 A
MGMT450 Aaron French 04/04/1950 Computer Based IS 83 B
 
Part 1 – Results of a Query
A series of queries are provided to you. Use the Class table above to determine the output that would result from each query.
 
1. SELECT count(*) from class;
 
 
2. SELECT Distinct Ucase(className) from class;
 
 
3. SELECT className, avg(score) 
    FROM class 
    WHERE grade=’A’
    GROUP BY className;
 
 
Part 2 – Writing Advanced Queries
You will be provided the results of a query from the class table. Your task is to write the query that would produce those results.
 
1. Display the number of students from each class who got an A or B in the course.
 
className grade count(grade)
Database A 3
Database B 2
Computer Based IS A 3
Computer Based IS B 3
 
 
 
2. Display the className, grade and how many students got an A, B or C in the class. Filter the data to only display the class and grades where there is a count less than 3.
 
className grade count(grade)
Database B 2
Database C 2
Computer Based IS C 1
 
 
 
3. Display the last name of all students who have more than 8 characters in their name. The query results should only display unique values (no duplicate results). The results should appear in descending alphabetical order.
 
lName Lenth
Stephenson 10
O’Connell 9
McRoberts 9
 
 
 
 
Grading
Upload a Microsoft Word document containing your answer to UNM Learn.

 

 

Attachments:

Answers

(5)
Status NEW Posted 26 Mar 2018 09:03 AM My Price 10.00

  ----------- He-----------llo----------- Si-----------r/M-----------ada-----------m -----------  ----------- 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-----------

Not Rated(0)