Can you write 10 query for this tables? Plase use join and nested queries Customer (CustomerID(Primary Key), phone) Customer_Name (CustomerID(Primary Key),fname,lname) Customer_Location(CustomerID(Primary Key),pincode,district,street_code,street_name,city) Employee(EmployeeID(Primary Key),phone,startdate) Employee_name(EmployeeID(Primary Key),emp_name) Employee_location(EmployeeID(Primary Key),city,country,country_code,pincode,street_code,street_name) RawMaterial(RawMaterialsID(Primary Key),available_quantity) RawMaterial_information(RawMaterialsID(Primary Key),raw_name,raw_details) RawMaterial_price(RawMaterialsID(Primary Key),raw_price) Product(ProductID(Primary Key),type) Product_price(ProductID(Primary Key),product_price) Product_information(ProductID(Primary Key),product_name,product_details) Payment(PaymentID(Primary Key),CustomerID,ProfitID) Product_quantity(ProductID(Primary Key),payment_amount) Payment_data(ProductID(Primary Key),data) Profit(ProfitID(Primary Key),date) Profit_quantity(ProfitID(Primary Key),profit_amount) Purchase (CustomerID(Primary Key), ProductID(Primary Key)) Made by (ProductID(Primary Key), RawMaterialsID(Primary Key)) Emanagedby(RawMaterialsID(Primary Key), EmployeeID(Primary Key)) Managesby(EmployeeID(Primary Key), ProfitID(Primary Key)) PaymentFor(PaymentID(Primary Key), ProductID(Primary Key))
Can you write 10 query for this tables? Plase use join and nested queries
Customer (CustomerID(Primary Key), phone)
Customer_Name (CustomerID(Primary Key),fname,lname)
Customer_Location(CustomerID(Primary Key),pincode,district,street_code,street_name,city)
Employee(EmployeeID(Primary Key),phone,startdate)
Employee_name(EmployeeID(Primary Key),emp_name)
Employee_location(EmployeeID(Primary Key),city,country,country_code,pincode,street_code,street_name)
RawMaterial(RawMaterialsID(Primary Key),available_quantity)
RawMaterial_information(RawMaterialsID(Primary Key),raw_name,raw_details)
RawMaterial_price(RawMaterialsID(Primary Key),raw_price)
Product(ProductID(Primary Key),type)
Product_price(ProductID(Primary Key),product_price)
Product_information(ProductID(Primary Key),product_name,product_details)
Payment(PaymentID(Primary Key),CustomerID,ProfitID)
Product_quantity(ProductID(Primary Key),payment_amount)
Payment_data(ProductID(Primary Key),data)
Profit(ProfitID(Primary Key),date)
Profit_quantity(ProfitID(Primary Key),profit_amount)
Purchase (CustomerID(Primary Key), ProductID(Primary Key))
Made by (ProductID(Primary Key), RawMaterialsID(Primary Key))
Emanagedby(RawMaterialsID(Primary Key), EmployeeID(Primary Key))
Managesby(EmployeeID(Primary Key), ProfitID(Primary Key))
PaymentFor(PaymentID(Primary Key), ProductID(Primary Key))
Step by step
Solved in 3 steps
