In a Microsoft Word document, research the library or internet to discuss the purpose of Data Aggregation in assocation to data held in databases in need for data analysis or data analytics. Also reference and discuss data extraction techniques where SQL code is used for data aggregation requirements for common functions like the sum, average, min, max, and others. The paper should be in the range of 500 words. When concluding your paper, lead these conclusions into your proposed and written out DML code for the task below where data aggregation is used and needed.

Using Data Manipulation Language (DML):

Suggest and provide DML code to show the overall totals of bikes sold. The query will use the products and order items tables. The query should output the product name and the SUM function to total quantities from the order items table. Sort in ascending or descending order by product name.

Suggest and provide DML code to show the bikes brand name and the average price of bikes for these brands. This query will use the products and brands tables and should extract the brand name and average list price and sorted in descending order by brand name.

Suggest and provide DML code that shows total customers by state. This query will use the customers table and will count all records in this table. The proposed output of this query should show the state in ascending order and the total number of customers.

Suggest and provide DML code that shows the average list price based on the category of the bicycle where the range of list prices is between 500 and 1000. This query will use the categories and products tables and should output the category name and average list price within the specified list price range of 500 and 1000. Hint: This query will make use of the Having clause which is used to filter results from aggregation or other functions when the Where clause is unable to filter from calculated results.

Suggest and provide DML code that shows the category name and the associated maximum and minimum list prices of these categories. The maximum price should be greater than 4000 and the minimum price should be less than 500. This query will use the categories and products tables.

Hint: Use the Having clause to support the condition with the maximum and minimum list prices.

Important Note: All proposed code for the retail store that sells bikes should be nicely prepared and presented in a Microsoft Word document holding your written paper on data aggregation and then submitted for grading and assessment.