List all product sales for which the units sold is greater than the average units sold -- for that product. to the previous query, add a correlated in-line sub-query to list the average units sold per product. list all customers (customer code and customer name) who purchased products 13-q2/p2 and 23109-hb. list all products with a product cost greater than all individual product costs of products provided by vendors in florida. list the difference between each product’s price and the average product price. list all vendors (vendor code and vendor name) that sell products with a quantity on hand < = double p_min. (double-2 times- the minimum price) create this query as a stored procedure.(use exists in this query).

What computer network component allows data transfers from one computer to another through a telephone line?

What are the three parts to physical security standards for various types of army equipment and the risk level

Consider the following statements: struct nametype{string first; string last; }; struct coursetype{string name; int callnum; int credits; char grade; }; struct studenttype{nametype name; double gpa; coursetype course; }; studenttype student; studenttype classlist[100]; coursetype course; nametype name; mark the following statements as valid or invalid. if a statement is invalid, explain why.a.) student.course.callnum = "csc230"; b.) cin > > student.name; c.) classlist[0] = name; d.) classlist[1].gpa = 3.45; e.) name = classlist[15].name; f.) student.name = name; g.) cout < < classlist[10] < < endl; h.) for (int j = 0; j < 100; j++)classlist[j].name = name; i.) classlist.course.credits = 3; j.) course = studenttype.course;