Computers and Technology
Consider relational schema withVehicle(vid, make, model, color, price)Salesperson(pid, salary)Customer(pid, phone)Person(pid, name)Truck(vid, weight)Sales(salesperson_id, customer_id, vid).A SQL statement to create the table for Salesperson with known salary at most $500K isA SQL statement to find the names of customers and the average price of the vehicles they bought isA SQL statement to increase the price of all red trucks by 10%SQL statement to find all the pairs of customer names that bought trucks with the same color