ex1
zeel906
SQLProject.docxIn this assignment, using SQL Server 2019 Express and Adventure Works, you will generate a query to complete the data analysis process. Use the following query to generate the data for the exercise:
Query 1
SELECT TOP (100) [CreditCardID]
,[CardType]
,[CardNumber]
,[ExpMonth]
,[ExpYear]
,[ModifiedDate]
FROM [AdventureWorks2019].[Sales].[CreditCard]
Take a full-screen snapshot of the results of the query
Query 2
SELECT TOP (10) [TerritoryID]
,[Name]
,[CountryRegionCode]
,[Group]
,[SalesYTD]
,[SalesLastYear]
,[CostYTD]
,[CostLastYear]
,[rowguid]
,[ModifiedDate]
FROM [AdventureWorks2019].[Sales].[SalesTerritory]
Take a full-screen snapshot of the results of the query
Query 3
SELECT TOP (50) [BusinessEntityID]
,[AccountNumber]
,[Name]
,[CreditRating]
,[PreferredVendorStatus]
,[ActiveFlag]
,[PurchasingWebServiceURL]
,[ModifiedDate]
FROM [AdventureWorks2019].[Purchasing].[Vendor]
Take a full-screen snapshot of the results of the query
Query 4
SELECT TOP (1000) [AddressID]
,[AddressLine1]
,[AddressLine2]
,[City]
,[StateProvinceID]
,[PostalCode]
FROM [AdventureWorks2019].[Person].[Address]
Take a full-screen snapshot of the results of the query
Query 5
SELECT TOP (1000) [ProductID]
,[Name]
,[ProductNumber]
,[MakeFlag]
,[FinishedGoodsFlag]
,[Color]
,[SafetyStockLevel]
,[ReorderPoint]
,[StandardCost]
,[ListPrice]
,[Size]
,[SizeUnitMeasureCode]
,[WeightUnitMeasureCode]
,[Weight]
,[DaysToManufacture]
,[ProductLine]
,[Class]
,[Style]
,[ProductSubcategoryID]
,[ProductModelID]
,[SellStartDate]
,[SellEndDate]
,[DiscontinuedDate]
,[rowguid]
,[ModifiedDate]
FROM [AdventureWorks2019].[Production].[Product]
Take a full-screen snapshot of the results of the query
