Answered step by step
Verified Expert Solution
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 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 conceptualphysical model. All required is the SQL code AND two screenshots of outputs of these two queries in Oracle SQL Developer, one for Querya and one for Queryb 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:
a 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.
b 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.

Step by Step Solution
There are 3 Steps involved in it
Step: 1

Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2

Step: 3

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