Reference no: EM131313088

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