Question: SELECT b . UserName,SUM ( a . total ) FROM Transactions _ 3 NF a inner join Users _ 3 NF b on a .

SELECT b.UserName,SUM(a.total)
FROM Transactions_3NF a
inner join Users_3NF b
on a.UserID = b.UserID
where a.InvoiceDate like '2020%'
GROUP BY CartID
having count(*)=4
order by a.total desc
limit 1;

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 Databases Questions!

Q:

Needing some help with assignment 2 part of this assignment the data would all be used in SQL databae queries Users Table: CREATE TABLE Users ( user_id INT PRIMARY KEY, username VARCHAR(50) NOT NULL,...

Q:

Needing some help with assignment 1 part of this assignment the data would all be used in SQL queries Users Table: CREATE TABLE Users ( user_id INT PRIMARY KEY, username VARCHAR(50) NOT NULL,...

Q:

This uses microsoft SQL management Studio I. OBJECTIVES At the end of this activity, the students will be able to: 1. Create, Alter, and Drop SQL VIEWs. 2. Understand the use of WITH SCHEMABINDING....

Q:

You will develop an E-Commerce database used to maintain customers, products and sales information. You are required to 1) gather and analyze requirements 2) design logical structure of the database...

Q:

SIT103 Data and Information Management T2, 2023 Summative assessment task-2: A real-world database design and implementation project Due dates: Part-1: Project proposal, due date: Wednesday 10th May...

Q:

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...

Q:

The following captures are the 4 tables that were already done in the access file which will be used to answer the questions on the Word document. Questions: Could you please help me complete this...

Q:

This is what I have so far- select to_user_id, date_read from messages Inner join user_id on to_user_id.messages = user_id.users where date_read = NULL not sure how to account for more than 10...

Q:

A creative engineer suggests structuring the TLB so that not all the bits of the presented address need match to result in a hit. Suggest how this might be achieved, and what might be the costs and...

Q:

14. DROP TABLE SQL statement is used to: * (0.5 puncte) O Delete a database O Delete a table Modify the structure of a table Index a table B. Enter new 15. The forms created in a database allow users...

Q:

According to The Harris Poll, the proportion of all adults who live in households with rifles (29%), shotguns (29%), or pistols (23%) has not changed significantly. However, today more people live in...

Q:

Refer to Table in this chapter and answer the following questions: a. Which is more elastically demanded: cigarettes or pork? Does this make sense to you? Explain briefly. b. If the price of milk...

Q:

If an arbitrage opportunity exists because the Law of One Price is violated, then an investor will want to take a position that: Multiple choice question. depends on his or her wealth. depends on his...

Q:

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

Q:

The chapter notes that the rise in the U.S. trade deficit during the 1980s was due largely to the rise in the U.S. budget deficit. On the other hand, the popular press sometimes claims that the...

Q:

In 1998, the Russian government defaulted on its debt payments, leading investors worldwide to raise their preference for U.S. government bonds, which are considered very safe. What effect do you...

Q:

A case study in the chapter analyzed purchasing-power parity for several countries using the price of Big Macs. Here are data for a few more countries: Predicted Country Big Mac Rate Rate Indonesia...