Use the w3schools orders database and develop sql statements. you should test you sql statements that have been thoroughly tested in w3schools.

correct response to any of the three questions will give you full credit. if you submit correct responses for all 4 questions, you will get 1 point bonus credit.

1) suppose that you want reward the customers with $2 for each order they placed. develop an sql statement that shows the names of the customers along with the total reward that they would receive.
2) develop an sql statement to show the total order value during the year 1996. (hint: the following statement gives order value for the order with orderid = 10248 select sum(o. quantity*p. price) from orderdetails o, products p where o. productid = p. productid and orderid=10248 )
3) suppose that you want reward the customers with 2% of their total order value for all their orders placed in the year 1997. develop an sql statement that shows the names of the customers along with the total reward that they would receive.
4) develop a query to show average number of units (average quantity) sold for each product. your query should show the product name, average quantity for each product sold.

We as humans write math expression in infix notation, e.g. 5 + 2 (the operators are written in-between the operands). in a computer’s language, however, it is preferred to have the operators on the right side of the operands, i.e. 5 2 +. for more complex expressions that include parenthesis and multiple operators, a compiler has to convert the expression into postfix first and then evaluate the resulting postfix.write a program that takes an “infix” expression as input, uses stacks to convert it into postfix expression, and finally evaluates it. it must support the following operations: + - / * ^ % (example infix expression: (7 - 3) / (2 + 2)postfix expression: 7 3 - 2 2 + /result: 1guidelines: 1. you will need to use stacks in three placesa. one for the parenthesis check [char stack]b. one during infix to postfix [char stack]c. one during evaluation [int stack]for a and b above, you can use same array and same push, pop method as both ofthem are char. but for evaluation you have int stack and you might consider to createanother push pop method to handle it. maybe push_int, pop_int, etc. or find otherstrategy to utilize existing push pop method2. you can create a function for obtaining operator priority. that function should take anoperator as input and return its priority as an integer. this function will you a lot andreduce repeated code3. during evaluation you will need to convert char into integer. example for single digit: char c = '5'; int x = c - '0';

Which best describes the role or restriction enzymes in the analysis of edna a. to break dna into fragments that vary in size so they can be sorted and analyzed b. to amplify small amounts of dna and generate large amounts of dna for analysis c. to purify samples of dna obtained from the environment so they can be analyzed d. to sort different sizes of dna fragments into a banding pattern that can be analyzed

Select the correct answer. a company is currently focusing on creating specific management goals for itself. which level of maturity is the company demonstrating under the sse_ccm framework? a. performed informally b. planned and tracked c. quantitatively controlled d. well-defined e. continuously improving