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.
