Computers and Technology, 12.08.2020 16:01 javlo4461
Write a SELECT statement that returns these columns from the Products table:
• The ListPrice column
• The DiscountPercent column
• A column named DiscountAmount that uses the previous two columns to calculate the discount amount and uses the ROUND function to round the result to 2 decimal places
I got number one figured out. SELECT ListPrice, DiscountPercentROUND(ListPrice * DiscountPrice/100) AS DiscountAmountfrom Products;
2. Write a SELECT statement that returns these columns from the Orders table:The OrderDate columnA column that returns the four-digit year that’s stored in the OrderDate columnA column that returns only the day of the month that’s stored in the OrderDate column. A column that returns the result from adding thirty days to the OrderDate column.3. Write a SELECT statement that returns these columns from the Orders table:The CardNumber columnThe length of the CardNumber columnThe last four digits of the CardNumber columnWhen you get that working right, add the column that follows to the result set. This is more difficult because the column requires the use of functions within functions. A column that displays the last four digits of the CardNumber column in this format: ---1234. In other words, use Xs for the first 12 digits of the card number and actual numbers for the last four digits of the number.4. Write a SELECT statement that returns these columns from the Orders table:The OrderID columnThe OrderDate columnA column named ApproxShipDate that’s calculated by adding 2 days to the OrderDate columnThe ShipDate columnA column named DaysToShip that shows the number of days between the order date and the ship dateWhen you have this working, add a WHERE clause that retrieves just the orders for March 2012
Answers: 2
Computers and Technology, 23.06.2019 13:30
Best laptops for college [$100-$500 range]?
Answers: 2
Computers and Technology, 23.06.2019 22:30
Jamie has to enter the names, employee id’s, and income of a group of employees into a worksheet. which option will jamie use to describe the data
Answers: 3
Computers and Technology, 24.06.2019 12:40
Match the feature to the network architecture. expensive to set up useful for a small organization easy to track files has a central server inexpensive to set up difficult to track files useful for a large organization does not have a central server client- server network peer-to-peer network
Answers: 3
Write a SELECT statement that returns these columns from the Products table:
• The ListPrice column...
Computers and Technology, 27.03.2020 01:26
Mathematics, 27.03.2020 01:26
Mathematics, 27.03.2020 01:26
Chemistry, 27.03.2020 01:26
History, 27.03.2020 01:26
Mathematics, 27.03.2020 01:26
Mathematics, 27.03.2020 01:26
History, 27.03.2020 01:26
Business, 27.03.2020 01:26
Mathematics, 27.03.2020 01:26
Mathematics, 27.03.2020 01:26
Mathematics, 27.03.2020 01:26
Chemistry, 27.03.2020 01:26