Write and run SQL statements to complete the following tasksShow 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.
Already registered? Login
Not Account? Sign up
Enter your email address to reset your password
Back to Login? Click here