What is the max balance?

  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

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]