Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

[ PLSS , I NEED THE ANSWERS IN 2 HOURS ; JUST THE SQL CORRECT CODE; AND PLS DON'T MAKE THE CODE TOO COMPLICATED AS

[PLSS, I NEED THE ANSWERS IN 2 HOURS ; JUST THE SQL CORRECT CODE; AND PLS DON'T MAKE THE CODE TOO COMPLICATED AS I AM A BACHELOR STUDENT TAKING DBMS COURSE] First, look at the conceptual/physical model. All required is the SQL code AND two screenshots of outputs of these two queries in Oracle SQL Developer, one for Query1a) and one for Query1b), but since I couldn't send the data of these tables, I just want you to write the SQL code and see all the screenshots and my descriptions in this text. Please, read carefully and make sure the queries are correct and executable:
1a) You need to create dimension with the following levels: Country, Manufacturer Name, Car Model; and calculate summary of rental cost for every level of dimension including grand total from all levels.
Sort results by county, then by manufacturer name, then by car model.
1b) Calculate average values of rentals cost in every month, every year and average across all periods, in one query.
Sort results by year, then by month.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine M Ricardo, Susan D Urban

3rd Edition

1284056945, 9781284056945

More Books

Students also viewed these Databases questions