Question: Can you help me make this into a SQL innerjoin statement INNER JOIN: retrieve LastName, FirstName from DimCustomer table, total ExtendedAmount from FactInternetSales with CustomerRevenue

Can you help me make this into a SQL innerjoin statement

Can you help me make this into a SQL innerjoin

INNER JOIN: retrieve LastName, FirstName from DimCustomer table, total ExtendedAmount from FactInternetSales with CustomerRevenue as the column name in the result window (this requires an inner join between the two tables with the column Customerkey as the joining column from each table), group the results by LastName, FirstName and order the results by CustomerRevenue. The first 15 results are shown below: 12345671 8 69 10 11 12 13 14 15 Last Name Collins Bennett Taylor Morgan Peterson Bryant Moms Kumar Sanders Miller Rivera She Lopez Sherman Richardson First Name CustomerRevenue Alex Abigail Dylan Marcus Melanie Natalie Abigail Brad Cody Hunter Natalie Michele Monica Megan Julia 2.29 2.29 2.29 2.29 2.29 2.29 2.29 2.29 2.29 2.29 2.29 3.99 3.99 3.99 3.99

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

How would i go and create and SQL Query statements for these f. g. INNER JOIN: retrieve LastName, FirstName from DimCustomer table, total Extended Amount from FactInternetSales with CustomerRevenue...

1. Your company uses 2 tables to store product information named LocalProducs and InternationalProducts. You also use a table named Orders that stores open order information. You must retrieve the ID...

here are rhe six inquiry queries the six examples queries the following questions need to be answered: what is each query requesting from the database give a description of the following SQL keywords...

The assignment is designed to be done on your own. The assignment must be your own work, not copied from others or any other course, textbook, or website. If plagiarism is detected, appropriate...

THIS IS A TUTORIAL, THE QUESTIONS ARE AT THE BOTTOM OF THE PAGE. The Martian database we will explore has 5 tables: martian, base, visitor, inventory, and supply. Today we are going to generate...

Need help with these questions to understand. Chapter 3 How to retrieve data from a single table Exercises Enter and run your own SELECT statements In these exercises, youll enter and run your own...

Overview: Database management plays an integral role in nearly every area of business. Databases house customer, accounting, and employee data, and these different data sets must all be efficiently...

Please help answer 16 and 17 or 18 and 20 if you can. This is all the information I was given below. As per the instructions you cannot use JOIN statements or subqueries. Here are the other questions...

PLEASE ONLY ANSWER IF YOU WILL ANSWER ALL QUESTIONS. ALL QUESTIONS ARE TOGETHER AND CANNOT BE SPLIT. [Q.3] Design and create a MusicStore" database for developing application for selling music files...

IVY TECH COMMUNITY COLLEGE DBMS110 M06 Lab Assignment (19 questions; 40 points total) There are 19 questions listed below. Based on the content in the M06 Readings, answer each question. After...

A superheterodyne receiver must me receiver must cover the range from 220 to 224 MHz. The first IF is 10.7 MHz; the second is 1.5 MHz. Determine a. the local oscillator tuning range. b. the frequency...

Newcomb Vending Company manages soft drink dispensing machines in western Tennessee for several of the major bottling companies in the area. When a machine malfunctions the company sends out a repair...

1 . The date on which I am granted a right to purchase a company s stock in the future under an option agreement is called the _ _ _ _ _ _ _ _ _ _ _ _ _ _ date, whereas the price I pay to purchase...

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...