Mã nguồn sách Beginning T-SQL with Microsoft SQL Server 2005 and 2008
Chia sẻ đến

Mã số tài liệu: 1638
Đơn giá: 0
NHẤN VÀO ĐỂ TẢI
Download TitleSizeDownload
Readme1.74 KBClick to Download
All Code Downloads for Beginning T-SQL
Chapter 6, Exercise 1 updated on 1/3/2011
23.67 KBClick to Download
Errata: New Code for Chapter 6, Exercise 1
The problem in Chapter 6, Exercise 1 should read:
Write a query to return the average weight of all touring bikes
sold by Adventure Works Cycles that list for more than $2,300.
Use the ProductSubCategory table to determine how you should
filter these products. The correct script would be: SELECT AVG(Weight) FROM Production.Product WHERE ProductSubcategoryID = 3 and ListPrice > 2300
23.67 KBClick to Download