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))
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![Oracle 12c: SQL](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
![A Guide to SQL](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)