Scenario based question| Get maximum sales | Joining | Oracle SQL series - part 45
In this video describe on Scenario based question| Get maximum sales | Joining | Oracle SQL series - part 45
In our channel describe on Oracle SQL Interview Question and Answers || IICS Tutorial || Data Warehousing Concept.
I have created playlist for Oracle SQL, IICS, DWH. Please check playlist u will get more knowledge on these (Oracle SQL, IICS, DWH).
Please check below link for more oracle sql questions,
https://wordpress.com/post/shobatecle...
Please check below link for IICS tutorial series,
https://wordpress.com/post/shobatecle...
Find the max sales product with vendor name?
create table order1(
order_id number,
order_date date,
product_id varchar2(20),vendor_id varchar2(20),
Quantity number,
Unit_price number,
sales number);
insert into order1 values(100,'02-08-2021','Mobile Phone','v1',1,999, 999);
insert into order1 values(101,'02-08-2021','Laptop','v2',2,1000,2000);
insert into order1 values(102,'02-08-2021','Washing machine','v2',3,1001,3003);
insert into order1 values(103,'03-08-2021','Refirgerator','v4',1,1002,1002);
insert into order1 values(104,'04-08-2021','P5','v5',1 ,1003,1003);
insert into order1 values(105,'05-08-2021','LED TV','v1',2,1004,2008);
insert into order1 values(106,'06-08-2021','P4',' v2',1,1005,1005);
select * from order1;
create table Vendor(vendor_id varchar2(20),vendor_name varchar2(23));
insert into vendor values('v1','Nokia');
insert into vendor values('v2','Samsung');
insert into vendor values('v3','Niki');
insert into vendor values('v4','Redmi');
insert into vendor values('v5','Vivo');
insert into vendor values('v6','Oppo');
insert into vendor values('v7','Google');
insert into vendor values('v8','Apple');
select * from vendor;
commit;