318795 Week5

Complete work on the Learning Team project. Since Harvey is not a technical manager, write a report that discusses the logic of the query that you created. Include in your synopsis the following items: Create the final SQL database Chart of Accounts report. Test the results set Submit query, screen shots and the Chart or Accounts report for grading. ·In your haste, you accidentally changed the wrong record number, which SQL command will reverse the updates? Write the necessary query to correct this incident and notes on what was done to a novice programmer. ·Finally, create one query that uses the commands BETWEEN, AND, IN, CONVERT, COUNT, NOT LIKE and CAST. Discuss the logic that explains what this query does and why you created it.