Create functional queries
1. Display order id, order date, and shipping state for orders placed during the first week of April, 2009.
2. Display the lowest discount amount applied to a book. Give the column an alias name "Lowest Discount Amount"
3. Write a query to return the current date along with time in MS SQL Server.
4. Add 10 days to the shipping date of the orders table then display the result, name the column New_Shipping_date.
5. Display customer id and calculate how many days between order date and shipping date, name this column "Days to ship".
6. Display customer id along with their last names and the last 2 characters of their zip code.
7. Write a query to display the publishers' id and their contact names separated by a colon

Answer rating: 100% (QA)

1 Display order id order date and shipp... View the full answer