Create an SQL statement for each requirement. Note: sales records is in sales table, purchase records are in purchases table, inventory records are in inventory table, sales returns are in salesret...

Create an SQL statement for each requirement.

Note: sales records is in sales table, purchase records are in purchases table, inventory records are in inventory table, sales returns are in salesret table, purchase returns are in purchasesret table, and stock movement is in movement table

Answer the ff:

1. Write an SQL statement to find the highest purchase quantity of a product for the first semester of 2022 from each supplier.


2. Display inventory records that were returned to supplier due to “defects” as mentioned in particulars, with the following data: item number, description, reorder, eoq.