Create and submit your final consolidated technical report which will include th

Create and submit your final consolidated technical report which will include the new requirements outlined below that are from project step 4 as well as all of the previous project steps (1-3). From project step 4, you must create and submit a SQL sсrіpt containing your data manipulation language (DML) statements to insert your sample data into your database and your twenty queries (12 basic, 8 advanced). Within the consolidated technical report, you must include the complete textual output from running your DDL, DML, and queries successfully. You will also include a literature review of similar systems in your report. Your final score will include the evaluation of the collection of output as well as a live, error-free expected run of your sсrіpt in the environment.20 SQL Queries (12 Basic, 8 Advanced) Minimum Requirements:
Query 1: Select all columns and all rows from one table
Query 2: Select five columns and all rows from one table
Query 3: Select all columns from all rows from one view
Query 4: Using a join on 2 tables, select all columns and all rows from the tables without the use of a Cartesian product
Query 5: Select and order data retrieved from one table
Query 6: Using a join on 3 tables, select 5 columns from the 3 tables. Use syntax that would limit the output to 10 rows
Query 7: Select distinct rows using joins on 3 tables
Query 8: Use GROUP BY and HAVING in a select statement using one or more tables
Query 9: Use IN clause to select data from one or more tables
Query 10: Select length of one column from one table (use LENGTH function)
Query 11: Delete one record from one table. Use select statements to demonstrate the table contents before and after the DELETE statement. Make sure you use ROLLBACK afterwards so that the data will not be physically removed
Query 12: Update one record from one table. Use select statements to demonstrate the table contents before and after the UPDATE statement. Make sure you use ROLLBACK afterwards so that the data will not be physically removed
Perform 8 Additional Advanced Queries
NOTE: each query should have comment to describe the purpose of that query
These queries are open for you to design but must be complex in nature such as including multiple (3 or more) table joins, sub-queries, aggregate functions, etc. These queries will not only be evaluated on their design and execution but also on their depth of complexity. Challenge yourself and leverage the techniques learned throughout the course to design your advanced queries.