00:01
So for the answer here, first is for manufacturing, manufacturer in new year stated supplies at least 10 products.
00:11
What is the average list price of products from that manufacturer? name the column average price round to two decimal places and show the manufacturer name and round average price to two decimal places.
00:27
So for the table inverse, select manufacturer name, round average list price, f average price for the product where manufacturer stated new year.
01:32
I, manufacturer, name, n, last, heavy, product id, less than, more than, equals, less than.
02:15
That's it for the first part.
02:18
Next question is what are the largest amount for a sales item? sales price multiplied by quantity made to each customer, first and last name.
02:27
If you are the only customer who have bought a sales item over 225, so inverse, select, first, name, last name, s name, max, sales, sales price, multiplied, quantity, s maximum.
03:20
For each customer, where sales price multiplied quantity is more than 225, included by customer, customer id, name, last name.
04:23
That's for the second part...
