We have the following tables which creates statement are

1. create table supplier(S_NO int identity(1,1), SUP_ID varchar(50) primary key,SUP_NAME varchar (50), SUP_ADD varchar (50), SUP_NIC int, rank int)
2. create table Product(Prod_ID varchar(50) primary key,Prod_Name varchar(50),[Price/Unit] float)
3. create table Orders(Ord_ID varchar(50) primary key,Prod_ID varchar(50),Qty int,Totalrate int,SUP_ID varchar (50))

Write the Queries using (Joins) on above tables:

1. List of all supplier that palced order
2. List of all Product that are supplied by supplier whose id is 101
3. Find all order(s) of product named Rice