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: 305 Weeks Ago, 1 Day 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 08 Jan 2018 My Price 10.00

solution script in SQL Developer and save the

Using SQL Developer, please answer the following assignment (attached). Also attached is the data file where information for the solution script comes from in  SQL Developer

  • /*

    Enter you SQL below each problem statement.

    Run your solution script in SQL Developer and save the
    output as a TXT or SQL file. 

    Make sure your output file does not have errors. 

    Do NOTE remove the PROMPT commands because
    they identify output for each problem solution.

    Submit your solution file and output file on line.


    */

    set pagesize 50;
    set sqlformat ansiconsole;

    show user;
    select sysdate from dual;

    PROMPT *******************************
    PROMPT 6.2.1
    PROMPT

    /* VIDEOS

    Group by the video main topic and give a count of the videos in this
    topic, the maximum video length, the minimum video length, the
    average video length.

    Use column aliases for the aggregate functions (keep the column name
    short, such as "MAX" and NOT "Max Video Length").

    Sort by main topic.


    */





    PROMPT *******************************
    PROMPT 6.2.2
    PROMPT
    /*  Oracle OE

    Show how many orders each customer has made. 

    Show the customer's ID, first and last name along with
    the order count.

    Use a column alias for the order count.

    Sort by count in descending order and then by last name.

    */





    PROMPT *******************************
    PROMPT 6.2.3
    PROMPT
    /* 
    Oracle OE

    Count how many times a product has sold in February of
    any year.

    Show the product ID, name and and # of times sold.

    Sort by # of times sold in descending order and by
    product name.



    */






    PROMPT *******************************
    PROMPT 6.2.4
    PROMPT
    /* VIDEOS

    Show how many total views of each video in the SQL BASIC series on
    on November 15, 2016. 

    Note:  You can't just count the number of records in WATCH_DATA because
    that record has the count of views for a particular video on a particular
    day for a particular country (geography).  How will you get the total views?

    Show the video's short title, the date watched and the view total.

    Sort by short title.
    */








Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 08 Jan 2018 01:01 PM 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)