Write SQL statements to answer the following questions from the ‘assignment5’ Database: Answer all questions List all the record/s in the vendor table that do not have a value for the attribute...

Write SQL statements to answer the following questions from the ‘assignment5’


Database: Answer all questions


        List all the record/s in the vendor table that do not have a value for the attribute V_STATE.
        Find the customers whose balance is greater than 250 but less than 400.
        Create a query based on invoice table to show a 15% increase on tax in a new column.
        Show the first and last names of the customers for whom we have issued 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 – make sure the counted column heading reads “Invoices_generated” .
        List the names of the customers and how many times a customer generated an invoice – make sure the counted column heading reads “N_Of_Invoices” .
        Find the customers whose last name is either Dunne, Orlando or Brown and live in area 615, sort in alphabetical order by the CUS_LNAME,.
        Add a new attribute called ‘email_address’ to ‘emp’ table and use data type and length ‘VARCHAR-20’.
        Add a new row/record to the `customer` table to include your actual student ID in the CUS_CODE, your lastname as the CUS_LNAME` and your firstname as CUS_FNAME. Add any other details in the other fields.
        Delete all the vendors in the FL state.