Question: Write a SELECT statement that returns these columns from the Orders and Customers table: The first initial of the first name ( using SUBSTRING )

Write a SELECT statement that returns these columns from the Orders and Customers table:
The first initial of the first name (using SUBSTRING) concatenated with Last Name field. Use the alias CustomerName.
CardType
The last four digits of the CardNumber (assume that the length of all is 16). Use SUBSTRING starting at 13 and returning next 4 digits. Use alias Last4Digits.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!

Q:

How to query/ write statements for exercise #4-7. See Attached Chapter How to retrieve data from a single table 1 Exercises . Write a SELECT statement that returns three columns from the Vendors...

Q:

Please create a .sql file that answers the 7 questions below. */ /*================================================================================ Q1: Write a SELECT statement that returns 3 columns...

Q:

using SQL server MGMT studio and the AP database l uling Server Management Studio. Please make sure the Cis113 the ai w the SQl syntax for each query that is created question is worth 3 points if the...

Q:

Complete all of the exercises below. There are five ( 5 ) exercises for each chapter from Week 2 ' s readings. All of these exercises use the my _ guitar _ shop database Download my _ guitar _ shop...

Q:

SQL Download the MyGuitarShop exercises: Located Below Log into Horizon. Open Start > Microsoft SQL Server Tools 18 > Microsoft SQL Server Management Studio. Click Connect to connect to the database....

Q:

How to retrieve data from a single table Exercises Enter and run your own SELECT statements In these exercises, youll enter and run your own SELECT statements. 1. Write a SELECT statement that...

Q:

Oracle SQL Developer HW: 1.Write a SELECT statement that returns three columns: vendor_id vendor_id from the Vendors table vendor_name vendor_name from the Vendors table contact_name A concatenation...

Q:

Oracle SQL Developer HW: 1.Write a SELECT statement that returns three columns: vendor_id vendor_id from the Vendors table vendor_name vendor_name from the Vendors table contact_name A concatenation...

Q:

For the following assignment use the GuitarShop database 1 . Write a SELECT statement that returns four columns from the Products table: * ProductCode * ProductName * ListPrice *...

Q:

1 . Write a SELECT statement that returns these columns: The count of the number of orders in the Orders table The sum of the TaxAmount columns in the Orders table 2 . Write a SELECT statement that...

Q:

Watch the video. (Information security: Anish Bhimani at TEDxUConn 2013). Please answer the following: Give an overview of the video. What was the most interesting point made in the video? Was there...

Q:

A short-term debt security with a face value of $38,316 and 55 days to maturity has a discount yield of 4.25 percent. How much would the security sell for today? A local bank offers a CD with and APR...

Q:

Current Attempt in Progress Skysong Company leases an automobile with a fair value of $ 1 8 , 7 0 2 from Steven Motors, Inc., on the following terms. Non - cancelable term of 5 0 months. Rental of $...

Q:

Jenna? Baker, CEO of Baker Mfg? Inc., wishes to compare her? company's inventory turnover to those of industry? leaders, who have turnover of about times per year and ?% of their assets inve