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: 304 Weeks Ago, 3 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 21 Dec 2017 My Price 10.00

Put SQL solutions below each problem statement

SQL assignments attached files below, plus the data dictionary for problems

  • /*
    Advanced SQL

    Put your SQL solutions below each problem statement.  When
    your solutions run without errors, run all of them via the
    "run script" option in SQL Developer.  Save the output to a
    file.

    Submit both your solution file and the output file online.

    */

    show user;
    select sysdate from dual;


    PROMPT  ***********************; 
    PROMPT 6.7.1;
    PROMPT;

    /*  Videos

    Type I

    In 2017 show which countries have watched all the videos
    in the SQL Advanced series. 

    Show the region, country ID, name (geography) and count
    of videos watched.

    Sort by region, and country name.

    Show the subquery code and output first then the whole query.


    */

    PROMPT subquery;
    PROMPT;

    --Determine how many videos there are
    --in the SQL advanced series.




    PROMPT full query;
    PROMPT;

    --Show which countries have watched all the
    --SQL Advanced videos in 2017.
    --You will need to use count(distinct ...) so each







    PROMPT  ***********************;
    PROMPT 6.7.2;
    PROMPT;
    /* 
    Views

    Make a view of the full query above.

    Show the content of that view using SELECT * ....

    Be sure to use CREATE OR REPLACE .... when creating the
    view.


    */


    PROMPT The view is created;
    PROMPT;


    PROMPT Show the view content;
    PROMPT;


Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 21 Dec 2017 07:12 AM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- 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----------- qu-----------ick-----------ly

Not Rated(0)