MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Order_Details(
O_Id int,
F_Id int,
Price Int);
CREATE VIEW Payment_Details AS
SELECT O_Id,
SUM(Price) AS Total_Price
FROM Order_Details
GROUP BY O_Id;
insert into Order_Details values
(1,1,20),(1,2,15);
select * from Payment_Details;


O_Id
Total_Price


1
35