Query and update databases using SQL- MySQL

Student650

Main

Home >Homework Answsers >Computer Science homework help

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.
Find out how many times a customer generated an invoice.
List the names 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'.
Delete the employee Leighla Genkazi from the EMP table.

You are required to submit:

1. The SQL statements for each query, which should be copied from your MySQL 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 MySQL 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

Notes:

I will email the MySQL Database file.

Required full screen shots capturing whole window for all 12 results.