Description is added as an image. Its a technical assignment, need to write queries and then get the result and write in a MS word file. No need of references to put. Task: Write and run SQL...

Description is added as an image. Its a technical assignment, need to write queries and then get the result and write in a MS word file. No need of references to put. Task: Write and run SQL statements to complete the following tasks Show all the details of the products by v_code 21344 Locate the record in the vendor table that does not have a value for the attribute V_STATE Find the customers whose balance is greater than 200 but less than 300. What is the max balance? Show the names of the customers for whom we have invoices. Show the CUS_CODE of the customers for whom we DO NOT have invoices. Show the names of the customers for whom we DO NOT have invoices. Using CUS_CODE find out how many times each customer has generated an invoice. i.e. customer XXX has generated xxx invoices, and customer YYY has generated yyy invoices etc. Only the customers who generated at least one invoice should be returned. List the first name and last name of the customers and how many times a customer generated an invoice. Add a new attribute (field) credithistory varchar(6) to the customer table. Update credithistory for customer '10011' to 'Bad'. Using inner join, list the details of the products which sold more than 10 units. You are required to submit: 1. The SQL statements for each query, which should be copied from your SQLite3 Command Line and pasted into your submission file 2. The screenshots of the results of the SQL statements which are to be copied from your SQLite3 Command Line and pasted into your submission file immediately after you execute the SQL query. If you used an output file please submit only the output file