ACME Protection Company

  1. Display all the assets managed by APC. Show the asset type, description and value only. Sequence the result table so the most expensive assets are listed first.
    SELECT
  2. Display the last names of customers, their city, state and zip code for all customers in California and Utah. Sequence the results by the customer’s last name.
    SELECT
  3. Display the customer number, their full name (as one result column) and the date they opened their account for customer number 7.
    SELECT
  4. Display the claim for customer number 7. Show the date the claim was submitted, the type of the claim and whether the claim has been approved and paid.
    SELECT
  5. Display the account numbers for customer number 8. Sequence the result table by the account number.
    SELECT
  6. Display the description and type of protection for all automobile assets.
    SELECT
  7. Display the customer last name, their mailing address (as one result column) and the date they opened an account for all customers that opened an account before January 1, 2000. Sequence the result table by the date from the oldest to the newest.
    SELECT
  8. Display the customer number, the date the claim was submitted and the claim amount for all claims paid.
    SELECT
  9. Display the asset type, description and value for assets that are valued from $0.00 to $2,000.00. Sequence the result table by the asset type and then by the asset value from the most expensive to the least expensive.
    SELECT
  10. Display the customer number and name for customers that have been modified.
    SELECT