Create a user-defined function called VEHICLES_BY_VEHICLE_TYPE that receives an input parameter of a concatenated make and model and then queries the VEHICLES and SALES_FACTS tables to return the total vehicles sold by that combination. Execute your function for a sample input value of your choosing to demonstrate that it works correctly.

CREATE TABLE Vehicles (

vehicle_Code VARCHAR2(10),

description VARCHAR2(100),

PRIMARY KEY (vehicle_Code));

CREATE TABLE Sales_Facts (

sale_day DATE NOT NULL,

vehicle_Code VARCHAR2(10) NOT NULL,

plan_ID VARCHAR2(10) NOT NULL,

dealer_ID VARCHAR2(5) NOT NULL,

vehicles_sold NUMBER(8,2) NOT NULL,

gross_sales_amt NUMBER(8,2) NOT NULL,

CONSTRAINT PK_Sales_Facts PRIMARY KEY (sale_day, vehicle_Code, plan_ID, dealer_ID),

CONSTRAINT FK_Sale_Day FOREIGN KEY(sale_day) References Times(sale_day),

CONSTRAINT FK_Vehicle_Code FOREIGN KEY(vehicle_Code) References Vehicles(vehicle_Code),

CONSTRAINT FK_Fin_Plan_ID FOREIGN KEY(plan_ID) References Financing_Plans(plan_ID),

CONSTRAINT FK_Dealer_ID FOREIGN KEY(dealer_ID) References Dealerships(dealer_ID));