IT 234 IT234 Unit 8 Assignment (Kaplan)
IT 234 Unit 8 Assignment (Kaplan)
1. From the Production.Product table, write a query to display the name of all products having a list price higher than $1,000.00 but less than $2,000.00 with expected starting sales date of the year beyond 2006. Include the highest Include in the result set the name of the products, the list price, and the selling starting date.
2. From the Person.CountryRegion, write a query to display the names of all countries that start with the first two letters "An".*/
3. From the Person.Address table, write a query to display the addresses having a second address line from the postal code 98004. Show the second address line, City, and Postal Code.
4. From the Person.Person table, write a query with the names of all the identified ladies having middle names. Include the Title, First Name and Last Name. Concatenate their names to display the column as “Ladies’ Names” and show their titles.
5. From the Sales.Store table, write a query that displays the names of all the stores that are related to selling bike products or services having the sales person number 279. Include the name of the store and the sales person number. Show the store names alphabetically.
6. Query and execution plan: Unit 8