SQL 2

create table CUSTOMERS ( CustID number not null constraint table_1_pk primary key, LastName varchar2(60) not null, FirstName varchar2(60) not null, MI varchar2(1), Address varchar2(60) not null, Street varchar2(60) not null, City varchar2(60) not null, State varchar2(60) not null, Zip number not null ); create table sales ( Sale_ID number not null constraint sales_pk primary key, gross_sale_price number not null, vehicle_status varchar2(20) not null, mileage number not null, vehicle_date date not null, CustID number not null, VIN number not null ); create table VEHICLES ( VIN number not null constraint vehicles_pk primary key, model varchar2(60) not null, make varchar2(60) not null, wholesale_cost varchar2(10) not null, wherefrom varchar2(60) not null, type varchar2(60) not null ) ; INSERT ALL INTO CUSTOMERS values(123, 'Nelson', 'Freeman', 'N', '614-601-5147', 'Abdella Way', 'New York', 'New york',12345) INTO CUSTOMERS values(16, 'Mary', 'Mader', 'K', '614-624-6628', 'Alwyne Avenue', 'Philadelphia', 'Philadelphia', 43441) INTO CUSTOMERS values(3, 'William', 'Mack','A', '330-949-2522', 'Arcadia Lakes Drive', 'Alaska', 'Alaska', 23423) INTO CUSTOMERS values(4, 'Mary', 'Burbank', 'G','330-512-9725', 'Arruda Terrace', 'Summerville', 'Alabama', 22323) INTO CUSTOMERS values(7, 'Enoch', 'Whitman', 'S', '216-848-9837', 'Atwood Way', 'Texas', 'Texas', 33234) INTO CUSTOMERS values(8, 'Rebecca', 'Gardner', 'H', '210-332-4332','Avila Place', 'Rosecounty', 'Nevada',67733) INTO CUSTOMERS values(2, 'Samuel', 'Hunter', 'J', '513-395-7045', 'Avila Place','Rosecounty', 'Nevada',45374) INTO CUSTOMERS values(10, 'Lucerna', 'Harlow', 'L', '513-786-2650', 'Summerville', 'Texas', 'Texas', 32344) INTO CUSTOMERS values(11, 'David', 'Freeman', 'F', '513-545-8812', 'Rosewood','Montana', 'Massachussetts', 53626) INTO CUSTOMERS values(12, 'Desiah', 'Mack', 'B', '330-802-5776', 'Hollywood', 'Hollywood', 'Nebraska', 23235) INTO CUSTOMERS values(13, 'Nathanial', 'Whitman', 'M', '216-596-6123', 'Springsfield', 'Alabama', 'Alabama', 34323) INTO CUSTOMERS values(9, 'Jane', 'Hunter', 'C', '216-596-6321', 'Silicone Valley', 'Silicone valley', 'New York', 34393) INTO CUSTOMERS values(14, 'Joseph', 'Freeman', 'J','312-893-2254', 'Bloomberg', 'Bloomberg', 'New Mexico', 63423) INTO CUSTOMERS values(15, 'Abigale', 'Whitman', 'W', '773-254-8919', 'Texas', 'Texas', 'Texas', 32466) INTO CUSTOMERS values(5, 'Samuel', 'Freeman','P','321-323-3343', 'Houston', 'Houston', 'New York', 89676) INTO CUSTOMERS values(6, 'Jessica', 'Freeman','S', '614-719-9213', 'Neverland','Hollywood', 'New York', 45671) INTO CUSTOMERS values(17, 'Alex', 'Whitman','A', '216-596-6240', 'Maryland','Maryland', 'Maryland', 45783) SELECT * FROM DUAL ; INSERT ALL INTO SALES values(1, 400000, 'in stock', 20, '01-APR-98', 12, 34) INTO SALES values(2, 200000, 'sold', 30, '13-Mar-2020', 32, 64) INTO SALES values(3, 500000, 'available', 40, '01-APR-98', 42, 84) INTO SALES values(5, 600000, 'sold', 0, '01-APR-98', 52, 74) INTO SALES values(13, 450000, 'in stock', 0, '01-APR-98', 1, 4) INTO SALES values(41, 200000, 'sold', 40, '01-APR-98', 82, 4) INTO SALES values(91, 500000, 'sold', 78, '01-APR-98', 73, 94) INTO SALES values(51, 20000, 'in stock', 20, '01-APR-98', 92, 84) INTO SALES values(14, 200000, 'sold', 20, '01-APR-98', 124, 534) INTO SALES values(16, 200000, 'sold', 20, '01-APR-98', 125, 734) INTO SALES values(19, 200000, 'available', 20, '01-APR-98', 212, 234) INTO SALES values(198, 700000, 'sold', 0, '01-APR-98', 912, 934) INTO SALES values(12, 200000, 'sold', 60, '01-APR-98', 152, 834) SELECT * FROM DUAL; INSERT ALL INTO VEHICLES values(1, 'Toyota', 'SUV', '20000', 'Japan', 'SUV') INTO VEHICLES values(2, 'Ford', 'SUV', '40000', 'USA', 'SUV') INTO VEHICLES values(3, 'Toyota', 'SUV', '90000', 'Japan', 'SUV') INTO VEHICLES values(4, 'Toyota', 'SUV', '70000', 'Japan', 'SUV') INTO VEHICLES values(5, 'Toyota', 'SUV', '30000', 'Japan', 'SUV') INTO VEHICLES values(6, 'Toyota', 'SUV', '40000', 'Japan', 'SUV') INTO VEHICLES values(7, 'Toyota', 'SUV', '20000', 'Japan', 'SUV') INTO VEHICLES values(8, 'Toyota', 'SUV', '20000', 'Japan', 'SUV') INTO VEHICLES values(9, 'Toyota', 'SUV', '20000', 'Japan', 'SUV') INTO VEHICLES values(10, 'Toyota', 'SUV', '520000', 'Japan', 'SUV') INTO VEHICLES values(11, 'Toyota', 'SUV', '40000', 'Japan', 'SUV') SELECT * FROM DUAL; select * from sales; select * from customers; select * from vehicles;