1) List all products with their highest unit price, i.e. not discounted.2) List the average unit price for each product category andthe average unit price without discounts COMP214F21_009_P_16.ORDERDETAILSCOMP214F21_009_P_16.PRODUCTSCOMP214F21_009_P_16.CATEGORIESPF ORDERIDPF" PRODUCTID* UNITPRICENUMBERIPPRODUCTIDNUMBERP CATEGORYIDNUMBER* PRODUCTNAME* CATEGORYNAMEVARCHAR2 (15 BYTE)VARCHAR2 (300 BYTE)NUMBERVARCHAR2 (40 BYTE)NUMBERSUPPLIERIDNUMBERDESCRIPTIONQUANTITYNUMBERCATEGORYIDNUMBERPICTURELONG RAW* DISCOUNTNUMBERQUANTITYPERUNITVARCHAR2 (20 BYTE)- PK_CATEGORIES (CATEGORYID)UNITPRICENUMBER- PK_ORDER_DETAILS (ORDERID, PRODUCTID)COMP214F21_009_P_16.SHIPPERSUNITSINSTOCKNUMBERO PK_CATEGORIES (CATEGORYID)FK_ORDERDETAILS_ORDERS (ORDERID)FK_ORDERDETAILS_PRODUCTS (PRODUCTID)P SHIPPERIDNUMBERUNITSONORDERNUMBERCOMPΑΝΥΝΑMΕREORDERLEVELNUMBERVARCHAR2 (40 BYTE)VARCHAR2 (24 BYTE)PHONEO PK_ORDER_DETAILS (ORDERID, PRODUCTID)DISCONTINUEDNUMBER (1)- PK_SHIPPERS (SHIPPERID)- PK_PRODUCTS (PRODUCTID)O PK_SHIPPERS (SHIPPERID)FK_PRODUCTS_CATEGORIES (CATEGORYID)FK_PRODUCTS_SUPPLIERS (SUPPLIERID)COMP214F21_009_P_16.ORDERSCOMP214F21_009_P_16.SUPPLIERSO PK_PRODUCTS (PRODUCTID)P SUPPLIERID* COMPANYNAMEP ORDERIDNUMBERNUMBERVARCHAR2 (40 BYTE)VARCHAR2 (30 BYTE)VARCHAR2 (30 BYTE)VARCHAR2 (60 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (10 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (24 BYTE)VARCHAR2 (24 BYTE)VARCHAR2 (200 BYTE)CUSTOMERIDCHAR (5 BYTE)COMP214 F21_009_P_16.EMPLOYEESFEMPLOYEEIDNUMBERCONTACTNAMETERRITORYIDVARCHAR2 (20 BYTE)CONTACTTITLEP ΕMPLOYE D* LASTNAME* FIRSTNAMENUMBERORDERDATEDATEDATEADDRESSVARCHAR2 (20 BYTE)VARCHAR2 (10 BYTE)VARCHAR2 (30 BYTE)VARCHAR2 (25 BYTE)REQUIREDDATECITYSHIPPEDDATEDATECOMP214F21_009_P_16.CUSTOMERSREGIONTITLESHIPVIANUMBERPOSTALCODEP CUSTOMERID* COMPANYNAMECHAR (5 BYTE)VARCHAR2 (40 BYTE)VARCHAR2 (30 BYTE)VARCHAR2 (30 BYTE)VARCHAR2 (60 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (15 BYTE)TITLEOFCOURTESYFREIGHTNUMBERCOUNTRYBIRTHDATEDATESHIPNAMEPHONEVARCHAR2 (40 BYTE)VARCHAR2 (60 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (15 BYTE)HIREDATEDATECONTACTNAMESHIPADDRESSFAXVARCHAR2 (60 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (10 BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (24 BYTE)VARCHAR2 (4 BYTE)ADDRESSCONTACTTITLESHIPCITYНОМЕРАGECITYADDRESSSHIPREGIONCITYREGION- PK_SUPPLIERS (SUPPLIERID)REGIONSHIPPOSTALCODEVARCHAR2 (10 BYTE)VARCHAR2 (15 BYTE)POSTALCODESHIPCOUNTRYO PK_SUPPLIERS (SUPPLIERID)COUNTRYPOSTALCODEVARCHAR2 (10o BYTE)VARCHAR2 (15 BYTE)VARCHAR2 (24 BYTE)HOMEPHONE- PK_ORDERS (ORDERID)COUNTRYEXTENSIONPHONEE FK_ORDERS_CUSTOMERS (CUSTOMERID)FK_ORDERS_EMPLOYEES (EMPLOYEEID)FK_ORDERS_SHIPPERS (SHIPVIA)FK_ORDERS_TERRITORIES (TERRITORYID)РHOTOLONG RAWFAXVARCHAR2 (24 BYTE)NOTESVARCHAR2 (600 BYTE)- PK_CUSTOMERS (CUSTOMERID)FREPORTSTONUMBERРHOTOPATHVARCHAR2 (255 BYTE)O PK_CUSTOMERS (CUSTOMERID)O PK_ORDERS (ORDERID)- PK_EMPLOYEES (EMPLOYEEID)FK_EMPLOYEES_EMPLOYEES (REPORTSTO)O PK_EMPLOYEES (EMPLOYEEID)COMP214F21_009_P_16.CUSTOMERCUSTOMERDEMOPF CUSTOMERIDPF CUSTOMERTYPEIDCHAR (5 BYTE)CHAR (10 BYTE)COMP214F21_009_P_16.TERRITORIESP. TERRITORYID* TERRITORYDESCRIPTIONF REGIONIDVARCHAR2 (20 BYTE)- PK_CUSTOMERDEMO (CUSTOMERID, CUSTOMERTYPEID)B FK_CUSTOMERDEMO (CUSTOMERTYPEID)FK CUSTOMERDEMO_CUSTOMERS (CUSTOMERID)O PK_CUSTOMERDEMO (CUSTOMERID, CUSTOMERTYPEID)CHAR (50 BYTE)NUMBERCOMP214F21_009_P_16.EMPLOYEETERRITORIES- PK_TERRITORIES (TERRITORYID)PF" EMPLOYEEIDPF TERRITORYIDNUMBERVARCHAR2 (20 BYTE)FK TERRITORIES_REGION (REGIONID)O PK_TERRITORIES (TERRITORYID)- PK_EMPTERRITORIES (EMPLOYEEID, TERRITORYID)* FK_EMPTERRI_EMPLOYEES (EMPLOYEEID)FK_EMPTERRI_TERRITORIES (TERRITORYID)COMP214F21_009_P_16.CUSTOMERDEMOGRAPHICSO PK_EMPTERRITORIES (EMPLOYEEID, TERRITORYID)P CUSTOMERTYPEIDCHAR (10 BYTE)COMP214F21_009_P_16.REGIONCUSTOMERDESCLONGP REGIONIDNUMBER- PK_CUSTOMERDEMOGRAPHICS (CUSTOMERTYPEID)* REGIONDESCRIPTIONCHAR (50 BYTE)O PK_CUSTOMERDEMOGRAPHICS (CUSTOMERTYPEID)PK_REGION (REGIONID)O PK_REGION (REGIONID)

There are following aggregate functions used in the SQL queries: To find the highest unit price,…

Answered: 1) List all products with their highest…

1) List all products with their highest unit price, i.e. not discounted. 2) List the average unit price for each product category and the average unit price without discounts

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Do all the sub parts
List the names of all Staff members who hold a faculty position and have a salary of $45,000 or less. Show their names as their first name, followed by a space, and then their last name but sort the list alphabetically by last name and then first name. Hint: Check out the Position column in the Staff table. All staff members who do not hold a faculty position will get a bonus this year equal to 5% of their salary. List the names, current salary, and bonus amount for each Staff member (non-faculty) who is due a bonus. Show your list in order with the person receiving the highest bonus first.
Show the employees who were in the engineering department as of Jan. 1, 2005 (using SQL)
have data base with following information: customer table with filed(cid,cname,city,country) order table with filed(cid ,oid,total amount) Q: List all orders with customer information.
Say you have a table called Exercise with two fields: Type_of_Exercise and Calories_Burned. How would you calculate the total calories for each exercise performed for this report? (table not given. the table should be explained theoretically)
How many customers have balance that exceeds their credit limit
1. List the book title and retail price for all books with a retail price lower than the averageretail price of all books sold by JustLee Books.
3. Which books aren’t in the Fitness category? List each book title and category.
write following queries
A retailer of computers maintains a record containing the following information for every individual computer sold. • Manufacturer name • Model number • Physical memory size • Processor name • Date of sale • Price sold for Using only the database, which of the following CANNOT be determined? The most popular model of computer sold by the retailer Which models of computer stocked by the retailer have not had a single sale The average price of a computer was sold by the retailer In which months less than 100 computers were sold
Find the total revenue generated by each product in the past quarter (last 3 months), you would need the following tables and their respective columns: Orders table: order_id (Primary key) order_date Order_details table: order_id (Foreign key) product_id (Foreign key) quantity price per unit Products table: product_id (Primary key) product_name