I don't know how to write the SQL for one to many relationships and many to many relationships

For this homework assignment you will need to utilize the Classic Models information located here Your instructor will provide access to this particular database in SQL Server. I only need to see the SQL you write to answer each of these queries. Because I have access to the same dataset that you do, Ican run the queries myself to see the results they provide. Be prepared to hand this in at the beginning of class and remember to put your name and student ID in the header of the document. Write the SQL to answer the following queries. Single entity a. Report those payments greater than $100,000. b. List the products in each product line. c. How many products in each product line? d. What is the minimum payment received? e. List all payments greater than twice the average payment. one to many relationship f. How many orders have been placed by Herkku Gifts? g. Who are the employees in Boston? h. Report those payments greater than $100,000. Sort the report so the customer who made the highest payment appears first. i. value of Hold' orders. each customer. j. Report the number of orders on Hold for Many to many relationship k. List those orders containing items sold at less than the MSRP. or I. Reports those products that have been sold with a markup of 100% more (i.e., the priceEach is at least twice the buyPrice) delete