1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Urgent, please help in sql queries

Discussion in 'SQL PL/SQL' started by akriti, Dec 8, 2015.

  1. akriti

    akriti Starter

    Likes Received:
    Trophy Points:
    Hi all,

    Please help me in the following SQL queries:

    Scenario: The database “Cellphones Information” contains details on cell phone sales or transactions.

    Details stored are: Dim_Manufacturer, Dim_Model, Dim_Customer, Dim_Location and Fact_Transactions. The first four store entries for the respective elements and Fact_Transactions stores all the information about sales of specific cellphones.


    Need queries for following:

    1. What state in the US is buying more 'Samsung' cell phones? Display state and number of cell phone transactions, sort by state.

    Keep in mind that some manufacturers can be stored in this format: “Name of Manufacturer - Country Code” (e.g. Samsung – Chile, Samsung – Peru, Motorola – Brazil). Also, some of them can be stored in uppercase or lowercase.

    2. Show the number of transactions for each model per zip code per state. Display manufacturer, model name, state and zip code, even if there are no transactions for a model. Sort by manufacturer name.

    3. Find out the average price for each model in the top 5 manufacturers in terms of sales quantity, and order by average price;

    4. List if there is any model that was in the top 5 in terms of quantity, simultaneously in 2008, 2009 and 2010;

    5. List the names of the customers and the average amount spent in 2009, where the average is higher than 500.00;

    6. List all the states in which we have customers who have bought cellphones from 2005 till today;

    7. Show the manufacturers that sold cell phones in 2010 but didn’t in 2009.

    It is urgent, I am very thankful if you respond immediately with the answers.

    Thanks a lot!
  2. zargon

    zargon Community Moderator Forum Guru

    Likes Received:
    Trophy Points:
    Aurora, CO
    This is a free-will help forum, not paid Oracle support so nothing is 'urgent' here. If this is that critical contact Oracle support for help, and, honestly, they won't help you by doing your homework. Neither will we. The great thing about taking a course on this is you get an instructor so you can immediately ask questions and get timely responses, you get a text to read to reinforce the classroom instruction and you get to take notes so you can refer to them later.

    If you honestly want help, and not someone to just do your work so YOU can get credit for doing NOTHING, then show what YOU have done to answer these questions. We can then see where you may have gone 'wrong' in your work and offer suggestions and assistance.