Question: How would i write this in an SQL Query List all product names (ProductName) from the DimProduct table no matter if a product has been

How would i write this in an SQL Query

How would i write this in an SQL Query List all

List all product names (ProductName) from the DimProduct table no matter if a product has been purchased by customers or not as well as the total sales (sum of the SalesAmount in the FactOnlineSales table) from the product. ProductKey is the joining column for the two tables. If a product has been purchased by customers, The ProductTotalSales column shows the total sales from the product. If a product has not been purchased by any customer, The ProductTotalSales column just shows NULL. Order the result by ProductTotalSales in descending order (desc)

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!

Questions Advanced Queries: Can you help me how to write these question in SQL 1. List the names of customers and how many distinct products they have ordered where that customer has ordered 40 or...

I need assistance with the following SQL queries. Northwind SQL Queries I need assistance with questions 20 through 32. I was able to get started on this assignment but now I'm stuck. Please help! /*...

Northwind SQL Queries I need help with questions 20 through 32. I was able to get started on this assignment but now I'm stuck. Please help! /* DB Design & SQL Northwind SQL Lab Write the SQL queries...

For part 2 of this project you will use the mongoDB classicmodels database you just loaded to answer the following questions . How many products are in the products collection? Place the result in a...

1. What is the total amount of purchases made in 2015 made by each employee who made purchases in 2015? Include EmployeeID, First and Last names and total amount. (Use a join with a select subquery...

Using the SQLEX database used for class exercises on querying, write queries for the following: (copy-paste your query from SQL server below relevant question) Queries 1 through 3: 2 points each...

SQL Query (answer #3 - #7) CUST This is a table with information about customers of DU Corp. The attributes are: C# Customer # NAME Customer Name CITY City (where the Customer Score (number C SCORE...

i have to answer these questions with sql query Retrieving Data Provide the SQL commands needed to answer the questions below using the information in the Human Resources and Order Entry databases....

Problem: Northwind Traders is a leading international supplier of food and beverages. They have an extensive network of suppliers around the world and customers spread across different countries....

Part 3: On your own Profile the following table in the Northwind Traders Database. The first two have been done for you in the previous part. Table Type Row Business Key One Row is Count Employees...

What should the future corporate strategy be? (And how essential is Richard Branson himself to that strategy?)

Ranger Corp. is exchanging a piece of land not currently being used for some trucks needed to meet increasing delivery demands. The land has a fair value of $250,000 and a book value of $170,000. The...

What is the purpose of an elevator speech during the employment process? A . To engage the listener, to inform and to be memorable. B . To persuade the listener to buy your product or service after...

Question 3 (20 marks). Mary's utility function is U ( x, y ) = x 1/2 +1/2y (a) Obtain the MRS. Draw the indifffference curves for U = 1and U = 2. Make sure to identify the intersections with each of...