Dr Nick

(3)

$14/per page/Negotiable

About Dr Nick

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

Expertise:
Art & Design,Computer Science See all
Art & Design,Computer Science,Engineering,Information Systems,Programming Hide all
Teaching Since: May 2017
Last Sign in: 245 Weeks Ago, 6 Days Ago
Questions Answered: 19234
Tutorials Posted: 19224

Education

  • MBA (IT), PHD
    Kaplan University
    Apr-2009 - Mar-2014

Experience

  • Professor
    University of Santo Tomas
    Aug-2006 - Present

Category > Information Systems Posted 02 Aug 2017 My Price 15.00

classes are in the English department

 

Provide select statements to satisfy the following data requests:

List all active male students assigned to Advisors 1 or 3 (Fred Stone or Jack Simpson).

Provide a list of all students without a biography.

What classes are in the English department?

Create a list of all students and their advisors. Sort by the advisor’s name and then the student’s name. Include the student’s birth date, gender, and GPA.

How many students were born in the 1980s?

Write a query to show the average GPA by gender.

Provide a list of all advisors and the number of active students assigned to each. Filter out any advisors with more than 1 student.

Copy and paste the work into your Key Assignment document and include screen shots of each step, describe what you did for each step and paste in the actual SQL text used to perform each step. 

Answers

Dr Nick
(3)
Status NEW Posted 02 Aug 2017 05:08 PM My Price 15.00

Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------you----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------.Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m ----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill-----------

Not Rated(0)