PET SUPPLIES 1. Create a view named MAJOR_CUSTOMER. It consistsof the customer ID, first name, last name, balance, credit limit,and rep ID for every customer whose credit limit is $500 or less.2. U 1 answer