Maurice Tutor

(5)

$15/per page/Negotiable

About Maurice Tutor

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

Expertise:
Algebra,Applied Sciences See all
Algebra,Applied Sciences,Biology,Calculus,Chemistry,Economics,English,Essay writing,Geography,Geology,Health & Medical,Physics,Science Hide all
Teaching Since: May 2017
Last Sign in: 399 Weeks Ago, 1 Day Ago
Questions Answered: 66690
Tutorials Posted: 66688

Education

  • MCS,PHD
    Argosy University/ Phoniex University/
    Nov-2005 - Oct-2011

Experience

  • Professor
    Phoniex University
    Oct-2001 - Nov-2016

Category > Computer Science Posted 15 Sep 2017 My Price 9.00

SQL statement to display Students

Name

Task

Query1

Write a SQL statement to display Students' First and Last Name.

Query2

Write a SQL statement to display the Major of students with no duplications. Do not display student names.

Query3

Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888.

Query4

Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 and have the major of Biology.

Query5

Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 or 88808. Do not use IN.

Query6

Write a SQL statement to display the First and Last Name of students who have the major of Biology or Math. Use the SQL command IN.

Query7

Write a SQL statement to display the First and Last Name of students who have the Status greater than 1 and less than 10. Use the SQL command BETWEEN.

Query8

Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.

Query9

Write a SQL statement to display the First and Last Name of students having an a in the second position in their first names.

Query10

Write a SQL expression to display the Status and a sum of the Status of each Status value as SumOfStatus. Group by Status and display the results in descending order of SumOfStatus.

 

Student_ID

Last_Name

First_Name

Address

Zip

Major

Class

1

Smith

James

555 Ohio Road

88888

Business

5

2

Doe

Jane

32 3rd Ave

88888

Biology

10

3

Miller

Mark

511 Easy streer

88808

Math

5

4

Smith

Ty

54 Main Street

88808

Math

3

 

Answers

Maurice Tutor
(5)
Status NEW Posted 15 Sep 2017 10:09 PM My Price 9.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll

Not Rated(0)