Write an SQL statement to show the sum of SubTotal for each customer. List CustomerID, LastName, FirstName, Phone, and the calcu

Question

german

2 years ago

10

Write an SQL statement to show the sum of SubTotal for each customer. List CustomerID, LastName, FirstName, Phone, and the calcu

lated result. Name the sum of SubTotal as SumOfSubTotal and sort the results by CustomerID, in descending order.

Computers and Technology

1 answer:

Karolina [17] · Answer 1 · 2023-11-07T06:36:58+03:00

An SQL statement to show the sum of SubTotal for each customer Using the SELECT Statement in SQL. The SQL "SELECT" declaration is the expression used to retrieve facts from the database.

<h3>What is an instance of an SQL declaration?</h3>

An SQL SELECT declaration retrieves information from a database desk in line with clauses (for instance, FROM and WHERE ) that designate criteria.

SELECT column1, column2 FROM table1, table2 WHERE column2='value';
Start your question with the choose declaration. choose [all | distinct] .
Add area names you need to display. field1 [,field2, 3, 4, etc.] ...
Add your declaration clause(s) or choice criteria. Required: ...
Review your chosen declaration. Here's a pattern declaration
You can retrieve facts from simply one desk or several. To get started, it is satisfactory to retrieve facts from one desk and discover ways to be a part of tables later.