Print to screen the ''below average''

Assignment Help Database Management System

Reference no: EM13168115

Print to screen the 'below average' if minimum unit_cost is <10 for product with prod_id = 145, and print 'above average' for if minimum unit_cost is >10 for the same product (use sh.costs table)

2- Create maxProds table as follow

CREATE TABLE maxProds

(ProdName VARCHAR(64),

MaxUnitPrice NUMBER(6,2),

TotQuantSold NUMBER(6));

Then insert into it Product name, the maximum Unit_Price, and the total Quantity_sold for the product with Prod_ID = 14. Use sh.Products, sh.Sales, and sh.Costs tables get the information

Reference no: EM13168115

Questions Cloud

Define different compounds of the hypothetical element x : Consider three different compounds of the hypothetical element X using the table of bond lenghts as a reference, rank the three compounds shown below in order of increasing

Design and implement a graphical user interface (gui) : Design and implement a graphical user interface (GUI) that lets a user draw geometric objects such as rectangles, circles or line segments. The geometric objects are two be "entered" with clicks of the mouse

Calculate the ph of distilled water : Calculate the pH of a 25 mL distilled water sample after the addition of 1mL, 2mL, 3mL, 4mL

Draw the mechanism for the reaction : draw the mechanism for the reaction between 3-chloroaniline and diethyl ethoxymethylenemalonate.

Print to screen the ''below average'' : Print to screen the 'below average' if minimum unit_cost is 10 for the same product (use sh.costs table)

Explain a compound has a c nmr spectrum with peaks : A compound has a C nmr spectrum with peaks at 7.4, 28.9, 36.4, and 208.8. The H nmr has peaks at 1.05 (t, .6), 2.13 (s, .58), 2.47 (q, .39). What is the compound?

Generate two files of 100 by 100 mazes : Write a C++ program that opens a file representing an encoded maze and reads it

Explain how many grams of sucrose must be dissolved in water : how many grams of sucrose (C12H22O11) must be dissolved in 200 g water to make a solution in which the mole fraction of sucrose is 0.1? answer in units of g.

Write a program displaying a text file that is in a text are : Write a program displaying a text file that is in a text area. The user enteres a file name in a text field and clicks the view button; the file is then displayed in the text area. Do not use BufferedInputStream.

User Account

All Pages