write query for all products reutrn product name with its amounts due, paid, canceled, and refunded, order the result by product name ascending

Answers

Answer 1

Answer:

SELECT product_name, amount_due, amount_paid,

              cancelled, amount_refunded

   FROM products

ORDER BY product_name ASC;

Explanation:

SQL (Structured Query Language ) was used above.

The SELECT command is used to list all the variables we want in our output.

The FROM command signifies the location.

ORDER BY command ensures that your result is ordered

ASC means Ascending Order.

; signifies the end of the query.

NOTE: Underscores were used because variables cannot be written with spaces between them


Related Questions

Jacob has a text file open, and he is typing on the keyboard. What is the best description of how the
changes are being implemented?
O The original file is temporarily changed; the changes become permanent when he clicks "save."
O The new version is kept in a special virtual space; the file is only changed when he clicks "save."
O The information is stored on the clipboard.
O A copy is created with a new filename, which will overwrite the old one when he clicks "save."

Answers

Answer:

The new version is kept in a special virtual space; the file is only changed when he clicks “save.”

Explanation:

I took the test and got it correct.

The best description of how the changes are being implemented is the new version is kept in a special virtual space; the file is only changed when he clicks "save." The correct option is b.

What is a keyboard?

Using a keyboard, you can input letters, words, and numbers into your computer. When you type, you press each key on the keyboard separately.

On the right side of the keyboard, you can also find the number keys that run across the top of the keyboard. The principal use of a keyboard is as an input device.

A person can type a document, use keystroke shortcuts, access menus, play games, and complete a number of other tasks with a keyboard.

Therefore, the correct option is b, The new version is kept in a special virtual space; the file is only changed when he clicks "save."

To learn more about keyboards, refer to the below link:

https://brainly.com/question/24921064

#SPJ2

Clay wants to print T-shirts and sell them online. What printing press would be the best for him to use?

Answers

Answer:

I think is screen printing press.

Explanation:

Screen printing requires you to go through a multi-step, back-breaking process to print your t-shirt.

Some programmers include scroll bars, title bars, buttons, and menus in a program simply by adding them to a layout through a process called ______________ programming.

Answers

Answer:

Visual.

Explanation:

Some programmers include scroll bars, title bars, buttons, and menus in a program simply by adding them to a layout through a process called visual programming.

A visual programming language is also commonly referred to as graphics user interface builder (GUI builder) and can be defined as a programming tool that avails programmers the ability to develop software programs (applications) using graphical elements and figures rather than texts alone.

Some examples of visual programming language are executable UML, Blockly, Kodu, Alice, Lego mindstorms, Gamemakers etc.

why do we need the system requirements for Adobe photoshop?

Answers

I’m sorry and I do not know I just need credits thank have a nice day

Your classmate constructs a simple computer that adds numbers. There are 5 wires for inputting the first
number, and the wires are currently "on","on", "off, "on", "off", or 11010 in binary.
What decimal number does that represent?

Answers

Answer:

26

Explanation:

education is better than money give point​

Answers

Answer:

yes education is better than money

Explanation:

money isn't everything

Which Tab contains the paragraph attributes?

A. Home
B. Insert
C. Review
D. View

PLs help
Award: 15pts

Answers

Answer:

Insert

Explanation:

1. Which of the following does NOT have Artificial Intelligence?

Siri/Alexa
driverless cars
Wireless Speakers
Face Recognition​

Answers

None of the above I think it is Siri I am sorry if it is a wrong

Answer:

wireless speakers

Explanation:

siri is a spin-off from a project originally developed by the SRI International Artificial Intelligence Center. Its speech recognition engine was provided by Nuance Communications, and Siri uses advanced machine learning technologies to function. alexa is the same. driverless cars when talking about autonomous cars, it is almost impossible not to discuss artificial intelligence. AI is used to enable the cars to navigate through the traffic and handle complex situations. Also, with a combined AI software and other Iot sensors, such as cameras, it becomes easier to ensure proper and safe driving.face recognition and AI can be discussed as different mechanisms and I do so occasionally to make clear that they are intertwined it is important to note that most any contemporary, powerful face recognition has certainly been developed using some aspect of AI so as it is clearly wireless speakers.

Provide an example where a company has demonetized a market or industry.

Answers

Companies are shut down if copyrighted

Why should you try to contact the technical support staff of a web hosting provider before you become one of its customers?

Answers

Answer: Contacting technical support can give you a general idea of the responsiveness of the web host provider to issues and problems. If the technical support staff is slow getting back to you at this point, don't be surprised if you get the same type of service when you have a problem and need immediate help. While not fail-safe, a quick response to a simple question at least gives the appearance of a well-organized, professional, and responsive technical support staff.

please tell fast plzzzzzz​

Answers

Answer:

heyyy

your answer is false

HOPE IT HELPS YOU OUT PLEASE MARK IT AS BRAINLIEST AND FOLLOW ME PROMISE YOU TO FOLLOW BACK ON BRAINLY.IN

Answer:

false..................

Protected members of a base class are like ________, but they may be accessed by derived classes. a. constructor functions.b. static members.c. private members.d. public members e. none of these.

Answers

Answer:

C). private members

Explanation:

These are options

a. constructor functions

b. static members

c. private members

d. public members

Protected members can be regarded as member that accessibility of them from outside the class is zero, they can only get accessibility from derived classes, though this is not applicable to private class. It should be noted that Protected members of a base class are like private but they may be accessed by derived classes.

Select the correct text in the passage.

Which statement in the paragraph indicates that a data storage problem exists with an enterprise system?

[Once implemented, enterprise systems have a lifespan of 10 to 20 years. After that, organizations can upgrade them or scale them up.] Although this seems like a long time, [data within organizations accumulates exponentially and may be too difficult to manage and store on a single software system.] [Data overflow and a subsequent slowdown in one department will have a ripple effect on other functions of an organization. ]This affects the performance of the entire system.

Answers

its C, sorry if im wrong but im pretty sure.

Explanation:

Answer:data within organizations accumulates exponentially and may be too difficult to manage and store on a single software system.

Explanation:

What framework uses CSS to access and manipulate HTML elements?

____ uses CSS to access and manipulate HTML elements

Answers

Answer:

The correct answer is JQuery

Explanation:

JQuery uses CSS to access and manipulate HTML elements.

Answer:

the answer is:

JQuery

Why is it important to turn your work in on time? How does submitting your work on time demonstrate academic integrity? How do you plan to ensure your academic success by turning your work in on time?

Answers

Answer:

It is important to turn the work on time for two fundamental reasons: first, because it allows the student to organize their time more efficiently, without delays in his presentations; and second, because it shows the responsibility of the student in front of his obligations, which gives a positive concept in front of teachers and managers.

In addition, the delivery of work in a timely manner is a clear sample of academic integrity: it shows that the student has his academic career as his main priority, over other alternatives such as work or leisure. That is, it realizes that the student is applied and integral when considering his academic responsibilities.

In my case, I seek to ensure my academic success by submitting my work in advance, which gives me time to receive corrections from the teachers and to be able to modify my mistakes.

Which of these is NOT a benefit of being connected 24/7?
A. You can find information using search engines.
B. You can use weather apps to help plan outdoor activities.
C. You can feel like you have to respond to a message right away, even if you don’t want to.
D. You can use music apps to create, share, and listen to playlists.

Answers

Answer:

c

Explanation:

answering messages is a more of a choice than a benifit.

The binary constraint must cover indicates that ________.
A)a specific binary relationship must be included in a ternary relationship
B)a binary relationship includes a set of value combinations that must all occur in a ternary relationship
C)a table includes values that must occur in a binary relationship
D)a table includes values that must occur in a ternary relationship

Answers

Answer:

B

Explanation:

binary relationship includes a set of value combinations that must all occur in a ternary relationship

The array elements are always stored in__________memory locations. Write the word consecutive or random in the blank appropriately.

Answers

Answer:

contiguous.

Explanation:

An array can be defined as a set of memory locations (data structure) that comprises of a group of elements with each memory location sharing the same name. Therefore, the elements contained in array are all of the same data type e.g strings or integers.

Basically, in computer programming, arrays are typically used by software developers to organize data, in order to search or sort them.

Binary search is an efficient algorithm used to find an item from a sorted list of items by using the run-time complexity of Ο(log n), where n is total number of elements.

Binary search applies the principles of divide and conquer.

In order to do a binary search on an array, the array must first be sorted in an ascending order.

The array elements are always stored in contiguous memory locations.

It should be be noted that the array elements are always stored in contiguous memory locations.

According to the question, we are to discuss the array elements and how they are been always stored  .

As a result if this we can see that array elements are always stored in contiguous memory locations so as to enable the retrieval of the information.

Therefore, array elements are always stored in contiguous memory locations.

Learn More about array elements at;

https://brainly.com/question/3735128

Why do people create web pages?

Answers

Answer:

To grab peoples attention

Explanation:

Answer:

People create web pages to share their passion for whatever they do. People create them to sell buisness products too.

Explanation:

I hoped this helped.

Program that take 3 number and display them in ascending order c++

Answers

Answer:

#include <iostream>     // std::cout

#include <algorithm>    // std::sort

#include <vector>       // std::vector

using namespace std;

int main()

{

   vector<int> myvector{ 8, 1, 3 };

   std::sort(myvector.begin(), myvector.end());

   for (int x : myvector)

       cout << x << " ";

}

Explanation:

Use STL libraries where you can to keep your code robust!

Corey set up his presentation for delivery to his team.

Answers

Answer:

If Corey wants to control the pacing of his presentation, he should adjust his playback settings. In the playback settings, he should select the default setting under "type;" this will allow him to change slides anytime. He should also click the check box under "options" that says "Change slides manually" so he can simply click on the slide whenever he is ready to move on to another slide.

Explanation:

If you don't like that answer, here's another one:

Corey knew he would need a lot of time to explain each point and that his team members would have lots of comments and questions. The best way that Corey should set up his slide show would be to make sure that he has an outline. Also, there should only be one thought per slide (never mix it). It has to be taken into account that he should have fewer words and more images/graphs.

Which button in the Sort & Filter gallery of the Data tab would alphabetize from A to Z quickly?
Sort
AZ down arrow
AZ up arrow
Filter

Answers

Answer:

B AZ down arrow

Explanation:

got it right

Answer:

B. AZ down arrow

Explanation:

I'ts right on Edge

Have a good day!!!

Suppose datagrams are limited to 1,500 bytes (including header) between source Host Aand destination Host B. Assuming a 20-byte IPheader, how many datagrams would be required to send an MP3 consisting of 5 million bytes? Explain how you computed your answer.

Answers

Answer:

3424 datagrams would be required

Explanation:

Mp3 file size = 5 million bytes

assuming the data is carried in TCP segments with each TCP segment have 20 bytes of header

Therefore each datagram can carry at least : ( 1500 - 40 ) = 1460 bytes

Therefore the number of datagrams required = [tex][\frac{5*10^6}{1460} ][/tex]    =  3424

The MP3 file to be transmitted does have a size of 5 million bytes or [tex]5 \times 10^6\ \ bytes[/tex]. Suppose that information is moved via TCP segments with a TCP header size of 20 bytes.

Each IP header is 20 bytes long, and the TCP header is also 20 bytes long. Therefore, we use 40 bytes out of a total of 1500 bytes for IP and TCP headers. Then, in each datagram, we can send [tex]1500-40 = 1460[/tex] bytes of MP3 files. So, overall number of data packets necessary:

         [tex]= \frac{\text{Total MP3 Size}}{\text{ MP3 Size}}[/tex]

calculating the each datagram that is capable of transporting:

                 [tex]\to \frac{5000000}{ 1460} \\\\ \to 3424.65753425 \\\\\to 3425 \ \ Datagrams.[/tex]

Except for the last one, all datagrams would be 1500 bytes in size. Your final datagram will be 1000 bytes long, i.e,

   [tex]\to 1460 \times 0.65753425 \\\\ \to 960 + 40 \ \text{(Bytes of Header)} \\\\ \to 1000 \ Bytes\\[/tex]

Learn more:

brainly.com/question/16666220

Which button in the Sort & Filter gallery of the Data tab would alphabetize from A to Z quickly?

Answers

Answer:

the answer is B (AZ down arrow)

Explanation:

To create an SSL connection, a Web server requires a ________, which is an electronic document that confirms the identity of a website or server and verifies that a public key belongs to a trustworthy individual or company.

a. DSL Degree
b. SSL Degree
c. SSL Certificate
d. DSL Certificate

Answers

Answer:

c. SSL Certificate

Explanation:

The full form of SSL is Secure Sockets Layer. It is the standard security technology which establishes the encrypted link between a client and the server—typically a web server (which is the website) and the browser, or the mail server along with a mail client (for e.g., Outlook).

In the context, in order to develop an SSL connection, an SSL Certificate is required by the Web server.

Explain the three schemes via which the binding of instructions and data to memory addresses can be done. In each scheme, how the logical address can be converted to physical address?

Answers

Answer:

Compile time

Load time

Execution time

Explanation:

The binding of instructions can be done in three steps, which are:

Compile time

Load time

Execution time

• Compile time In compile time, absolute code is usually generated when the compile time where the process resides in the memory is known

• Load time - in contrary to compile time, if it is not known at compile time where the process will reside in memory, then the compiler has to generate a relocatable code. In this scenario, the final binding is usually delayed until load time.

• Execution time - if the process is able to be moved during its execution from a particular memory segment to another segment, then binding is delayed until run time.

Which of the following features can be found on the LMS home page?
(Select all that apply.)
A. Log in to the LMS
B. Review the FTI calendar
C. Acces the FAQs
D. Watch videos
E. Follow FTI social media

Answers

A b c d e so yes it need 20 words for this lol

this is my pc it had glowing rams but we changed them​

Answers

Answer:

nice how many fps

Explanation:

wow very nice I love it I think it looks great

A. Write a class that declares a variable named inches that holds a length in inches,
and assign a value. Display the value in feet and inches; for example, 86 inches
becomes 7 feet and 2 inches. Be sure to use a named constant where appropriate.
Save the class as InchesToFeet.java.
B. Write an interactive version of the InchesToFeet class that accepts the inches
value from a user. Save the class as InchesToFeetInteractive.java.

Answers

Answer:

A.

public class Main{

public static void main(String[] args) {

 final int divisor = 12;

 int inches = 86 ,feet;

 feet =inches/divisor;

 inches = inches%divisor;

 System.out.print(feet+" feets "+inches+" inches");

}

}

B.

import java.util.*;

public class InchesToFeetInteractive{

public static void main(String[] args) {

 Scanner input = new Scanner(System.in);

 final int divisor = 12;

 int inches,feet;

 System.out.print("Measurement in Inches: ");

 inches = input.nextInt();

 feet =inches/divisor;

 inches = inches%divisor;

 System.out.print(feet+" feets "+inches+" inches");

}

}

Explanation:

Both classes use the same algorithm; however, the slight difference is that

(A) assumes a values of inch measure while (B) prompts user for input

That is show in the differences below

A)

int inches = 86 ,feet; ---> This initializes inches to 86;

B)

This prompts user for measurement in Inches

 System.out.print("Measurement in Inches: ");

This gets the measurement

 inches = input.nextInt();

The next lines are common in both classes

This declares and initializes a constant which is used in the conversion

 final int divisor = 12;

This calculates the number of feet in the user input

 feet =inches/divisor;

This gets the remainder inches, if any. It uses % to calculate the remainder

 inches = inches%divisor;

This prints the required output

 System.out.print(feet+" feets "+inches+" inches");

ANIMATION QUESTION

In the you tube animation "The Heavy Is Ded" the Heavy is supposedly "Ded" but throughout the video, he clearly isn't ded, can anyone explain how on earth this is possible, because this should be impossible since the Heavy is ded

Answers

Answer:

I think my old acc got deleted again..........

Explanation:

I love u here is a meme

Other Questions
Greenspan Supply does not segregate sales and sales taxes at the time of sale. The register total for March 16 is $10,920. All sales are subject to a 4% sales tax. Which statement correctly compares the slopes of the two functions? OA Function fhas a slope of which makes it steeper than function g. O B. Function g has a slope of , which makes it steeper than function f. Function ghas a slope of 2, which makes it steeper than function f. O c. OD Function f has a slope of 3, which makes it steeper than function g Question 20 of 20Civilizations developed along rivers about 10,000 years ago, during theRevolution.A. Cro-MagnonB. IronC. Guns and SteelD. NeolithicNeed some help dont get it Brainelst if correct Which of the following statements is logically equivalent to: "If he studies, he will pass the course."(A) He passed the course; therefore, he studied.(B) He did not study; therefore, he will not pass the course.(C) He did not pass the course; therefore he did not study.(D) He will pass the course only if he studies.(E) None of the above. Which risk of using alcohol or drugs is mental?having heart failurehaving an inability to meet friendsgetting brain damagehaving seizures - - Reshma is making a necklace using green beads and purple beads in a ratio represented on the following double number line. Fill in the missing values on the diagram.What is the ratio value of green beads to purple beads. [Type your answer as a fraction in simplest form. Use / for the fraction bar and do not use spaces.]Ratio Value: _____________ Why do you think Mesopotamia was a good location for the growth of civilization? Drag the missing punctuation into the sentence.Her breathtakingly cruel callous actions led to herimmediate resignation. Which statement about the meaning of words is correct?Context clues help only with words that have one meaning.A dictionary is the only way to determine the meaning of a word.Context clues are never helpful for determining a words meaning.A way to determine a words meaning is to study what surrounds it. Please HelpA 1774 print depicted the tarring and feathering of Boston Commissioner of Customs John Malcolm. Tarring and feathering was a ritual of humiliation and public warning that (usually) stopped just short of serious injury.1: Do you think this was made by a British or colonial artist? Why?2: Do you think this a proper way to protest against government action? Explain. Please help I need these answers Which best explains why online retailers keep data about their customers? to ensure customers leave good reviews to prevent customers from shopping elsewhere to sell customer information to others to maintain records of customers buying habits Avery needs a total of $12.75 in quarters atthe local laundromat. She has already saved$3.25. Which equation and solution processcan be used to determine q, the number ofadditional quarters Avery needs to wash herlaundry?A) 12.75 = 5 + 3.25Subtract 3.25 from both sides and multiplythe difference by 25.B)3.25 -0.259 = 12.75Subtract 3.25 from both sides and dividethe difference by -0.25.IC)12.75 = 0.259 + 3.25Subtract 3.25 from both sides and dividethe difference by 0.25.D) 259 + 3.25 = 12.75.Subtract 3.25 from both sides and dividethe difference by 25. A. The mutation did not affect the child.3. A child is diagnosed with sickle cell disease, agenetic blood disorder. Which of the following istrue about the mutation that occurred?B. The mutation produced a beneficial effect.C. The mutation is due to the environmentD. The mutation produced a harmful effect. Which practice was the top priority for New England settlers during the early colonial era?O shipbuildingOfarmingOfishingO sewing Help for a cookie!:D HELPP ME PLZZZZZ ZMZNSNMSMSMS Write a balanced chemical equation for the reaction that occurs when Mg(s) reacts with Cl2(g).