Hello, this is for SQL. Can I get some help with J-R?

Thank you!

Caci name only ONCE WIIU have all " U lar e Product Number eo product list eact J. Write an SQL statement to list the FirstName, LastName, Phone, Product and Product Description for customers who have purchased a video product 11 combination of name and product only once.) Sort the results by LastName scending order, then by FirstName in descending order, and then by Product Nun in descending order. (Hint: Video products have a Product Number that starte VK.) K. Write an SQL statement to show all Heather Sweeney Designs seminars and the customers who attended them. The output from this statement should include aty seminars that do not have any customers shown as attending them. The SQL statemen output should list SeminarID, SeminarDate, Location, SeminarTitle, Customer, LastName, and FirstName. (Hint: Use JOIN ON syntax.) L. Write an SQL statement to show all customers and the products that they have pur- chased. The output from this statement should include any products that have not been purchased by any customer. The SQL statement output should list CustomerID, Last Name, FirstName, InvoiceNumber, Product Number, Product Type, and Product Description. (Hint: Use JOIN ON syntax.) M. Write an SQL statement to show the sum of Subtotal (this is the money earned by HSD on products sold exclusive of shipping costs and taxes) for INVOICE as SumOfSub Total. Product Description. (Hint: Use JUIN UN SINNI.) M. Write an SQL statement to show the sum of Subtotal (this is the mone by HSD on products sold exclusive of shipping costs and taxes) for INVOICE SumOfSub Total N. Write an SOL statement to show the average of Subtotal (this is the money earned by HSD on products sold exclusive of shipping costs and taxes) for INVOICES AverageOfSub Total. O. Write an SQL statement to show both the sum and the average of Subtotal (this is the money earned by HSD on products sold exclusive of shipping costs and taxes) for INVOICE as SumOfSubTotal and AverageOfSub Total respectively. P. Write an SQL statement to modify PRODUCT UnitPrice for Product Number VK004 to $34.95 instead of the current UnitPrice of $24.95. Q. Write an SQL statement to undo the UnitPrice modification in part P. R. Do not run your answer to the following question in your actual database! Write the in est number of DELETE statements possible to remove all the data in your data but leave the table structures intact. Caci name only ONCE WIIU have all " U lar e Product Number eo product list eact J. Write an SQL statement to list the FirstName, LastName, Phone, Product and Product Description for customers who have purchased a video product 11 combination of name and product only once.) Sort the results by LastName scending order, then by FirstName in descending order, and then by Product Nun in descending order. (Hint: Video products have a Product Number that starte VK.) K. Write an SQL statement to show all Heather Sweeney Designs seminars and the customers who attended them. The output from this statement should include aty seminars that do not have any customers shown as attending them. The SQL statemen output should list SeminarID, SeminarDate, Location, SeminarTitle, Customer, LastName, and FirstName. (Hint: Use JOIN ON syntax.) L. Write an SQL statement to show all customers and the products that they have pur- chased. The output from this statement should include any products that have not been purchased by any customer. The SQL statement output should list CustomerID, Last Name, FirstName, InvoiceNumber, Product Number, Product Type, and Product Description. (Hint: Use JOIN ON syntax.) M. Write an SQL statement to show the sum of Subtotal (this is the money earned by HSD on products sold exclusive of shipping costs and taxes) for INVOICE as SumOfSub Total. Product Description. (Hint: Use JUIN UN SINNI.) M. Write an SQL statement to show the sum of Subtotal (this is the mone by HSD on products sold exclusive of shipping costs and taxes) for INVOICE SumOfSub Total N. Write an SOL statement to show the average of Subtotal (this is the money earned by HSD on products sold exclusive of shipping costs and taxes) for INVOICES AverageOfSub Total. O. Write an SQL statement to show both the sum and the average of Subtotal (this is the money earned by HSD on products sold exclusive of shipping costs and taxes) for INVOICE as SumOfSubTotal and AverageOfSub Total respectively. P. Write an SQL statement to modify PRODUCT UnitPrice for Product Number VK004 to $34.95 instead of the current UnitPrice of $24.95. Q. Write an SQL statement to undo the UnitPrice modification in part P. R. Do not run your answer to the following question in your actual database! Write the in est number of DELETE statements possible to remove all the data in your data but leave the table structures intact