Using Java Eclipse write the the code required from each question.
Write the code required for each question. I solved it but there a lot of mistakes attached is the Data Base Tables used. Please read the question and look to my answer I know it is wrong but not that wrong so stick with the way I answered I don't want a complicated answer just stick with basic you will use some join statement I didn't know whether to use a left join or normal join so help.
1. Display all active users");
2. Display all users and their addresses and phone numbers");
3. Display all orders in the system and the associated user's firstName, lastName and email");
4. Display all order header and associated user information with a delivery date before 11-Nov-2016.");
5. Display all error, warning, and info Grouped by LogType and Order by Company and Location.");
6. Display all info from System_Log Grouped by LogType and Order by Company and Location for ENGLAND.");
7. Show me all orders where no production exists.");
8. Delete all data for [email protected] (every table)");
9. Update a single address and phone number for [email protected]");
10. Show me the total UnitsOnHand(sum of all items), ProductDesc by Product for all of the United State");
11. Show me the Company Desc, total Dollar(sum of all items), ProductDesc by Product for all Companies");
12. Show me the Top performing Company Desc, total Dollar(sum of all items), ProductDesc");
13. Show me the Company Desc, for all companies with no production.");
14. Show me the User's Email, FirstName, LastName and number of orders, for the Users with the most orders.");
15. Show me the User's Email, FirstName, LastName and number of orders, for the Users with the least orders.");
16. Show me all the ProductDesc for all products that both production and orders Order by UnitCost and UnitOnHand.");
Attachment:- Attachments.rar