SQL Queries for beginners based on Adventureworks data

Basic SQL queries for beginners based on Adventureworks data
1. Retrieve all columns from the DimEmployee table.
2. Retrieve the total sales amount from the FactInternetSales table.
3. Count the number of distinct products in the DimProduct table.
4. Select all columns from the DimCustomer table where the CustomerKey is equal to 123.
5. List the top 10 customers by total sales amount from the FactInternetSales table.
6. Get the average age of employees from the DimEmployee table.
7. Calculate the total number of orders from the FactInternetSales table.
8. Find the maximum sales amount from the FactInternetSales table.
9. Select all columns from the DimProductSubcategory table where the EnglishProductSubcategoryName is 'Bikes'.
10. Retrieve the order date and sales amount from the FactInternetSales table for orders placed in any year.