The marking criteria for this assignment is: HD DI CR PS FL Accurate and elegant SQL that answers all parts of the question. SQL code copied from SQLite as well as a screen shot of code and results...

Part A - DML
1. Show the details of the products where the product code starts with ‘22’.
Ans:
Query: SELECT * FROM PRODUCT WHERE P_CODE LIKE ‘%22’;
2. Display the vendor details from area code 615.
Ans:
Query: SELECT * FROM VENDOR WHERE V_AREACODE =’615’;
3. Find the balance for customer ‘George Williams’.
Ans:
Query: SELECT CUS_BALANCE FROM CUSTOMER WHERE CUS_FNAME = ‘George’ AND CUS_LNAME = ‘Williams’;
4. Show the number of products from each vendor and display the vendor code if there are more than 2 products from the same vendor.
Ans:
Query: SELECT * FROM (SELECT * FROM PRODUCT GROUP BY V_CODE HAVING...