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");
3.    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.");
From my answers just edit what is inside the try statement.