Write and run SQL statements to complete the following tasks
 
  1. Show all the details of the products by v_code 21344
  2. Locate the record in the vendor table that does not have a value for the attribute V_STATE
  3. Find the customers whose balance is greater than 200 but less than 300.
  4. What is the max balance?
  5. Show the names of the customers for whom we have invoices.
  6. Show the CUS_CODE of the customers for whom we DO NOT have invoices.
  7. Show the names of the customers for whom we DO NOT have invoices.
  8. Find out how many times a customer generated an invoice.
  9. List the names of the customers and how many times a customer generated an invoice.
  10. Add a new attribute (field) credithistory varchar(6) to the customer table.
  11. Update credithistory for customer ‘10011’ to ‘Bad’.
  12. 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.
 
 

Need a custom written plagiarism free essay? Click here to order now.

Never use plagiarized sources. Get Your Original Essay on
Computer Science Assignment
Hire Professionals Just from $11/Page
Order Now Click here
Open chat
Lets chat on via WhatsApp
Hello, Welcome to our WhatsApp support. Reply to this message to start a chat.