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.
Other samples, services and questions:
When you use PaperHelp, you save one valuable — TIME
You can spend it for more important things than paper writing.