Can you Write the SQL statements to do the following please : 1. Display the artist's name from the Artist table in uppercase. 2. Display the person's Key, First Name, Last Name and Area Code (first 3 digits of the phone number) from the Person table and label the output as such. 3. Display the current date and five days from that date. 4. Display the difference between the current date and the PurchaseDate of the Inventory. 5. Display the day of the week, in words, on which the Purchases were place. (Hint: Use datepart dw.) 6. Display the minimum, maximum, sum, average, count fields, count records for the SaleDetailPrice from the SaleDetail table. Appropriately label the output.
Can you Write the SQL statements to do the following please :
1. Display the artist's name from the Artist table in uppercase.
2. Display the person's Key, First Name, Last Name and Area Code (first 3 digits of the phone number) from the Person table and label the output as such.
3. Display the current date and five days from that date.
4. Display the difference between the current date and the PurchaseDate of the Inventory.
5. Display the day of the week, in words, on which the Purchases were place. (Hint: Use datepart dw.)
6. Display the minimum, maximum, sum, average, count fields, count records for the SaleDetailPrice from the SaleDetail table. Appropriately label the output.
7. Display the count of phone numbers in the Person table.
8. Display the record count of the Person table.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 4 images
