Question: Write a query to display the customer name and customer code of all customers who use 'yahoo' as their email. The customer code should be

Write a query to display the customer name and customer code of all customers who use 'yahoo' as their email. The customer code should be generated by concatenating the first

3

characters of the customer's name and the first

3

numbers of their contact number. Give an alias name as 'CUSTOMER

_

CODE'.

Sort the results based on the customer address in ascending order.

Sample data:

Customer Name: Holder

Contact Number:

9506161140

Sample Output:

CUSTOMER

_

CODE

Hol

950

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 Databases Questions!

1. Write a query to display the customer name for all customers that are not from the USA that have not placed any order. Order the results by customer name in the ascending order. 2. Write a query...

NEED HELP WITH MY MYSQL PROJECT PLEASE: QUESTION 1) Using the SUBSTRING and CONCAT functions, write a query to display each customer name as a single field in the format Jones, Tom with a heading of...

1.Using the SUBSTRING and CONCAT functions, write a query to display each customer name as a single field in the format Jones, Tom with a heading of Customer along with the customer_phone field in a...

Looking for 5.1-5.10 5. Create Queries that to do the following: (10 marki). Your queries will be marked based on whether the queries are formulated correct or not, net based on the records that are...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql 30. Write a query to display the first name, last...

SQL CODE: 30. Write a query to display the first name, last name, phone number, title, and department number of employees who work in department 300 or have the title "CLERK I." Sort the output by...

SQL CODE: https://gist.githubusercontent.com/GistMasterPro/3893fe6d62ae301e85265a7f0ceafad4/raw/40fe8193dd74c39a56724d8eda2d445e41bc58c7/SQL.sql OR...

11. Generate a listing of all purchases made by the customers, using the output shown in Figure P7.11 as your guide. Sort the results by customer code, invoice number, and product description. 12....

About the Database A company resells paints to customers both individual and company customers, but same data is recorded for both. The company tracks the sale of products to customers and the...

DATABASE Table name: CUSTOMER CUS_CODE CUS_LNAME CUS_FNAME CUS_INITIAL CUS AREACODE CUS_PHONE CUS_BALANCE 10010 Raras Alfred A 615 844-2573 0.00 10011 Dunne Leona K 713 894-1238 0.00 10012 Smith...

2. The following is a conclusions drawn from Experiments. Based on your knowledge of experiments, identify how this experiment was likely carried out including: the Experimental Group, the Control...

Investigate the potential for EPM what problems is it claimed to solve for an organisation?

Would the given assets impact the decision to issue debt

What provides an indication of the general nature of the job ( for example, night supervisor, salesperson , or team leader ) ? job description job specification job title job analysis heading

Ethics.Technology. A health spa used the term micro color in marketing campaigns to refer to permanent cosmetic makeup. A beauty supply company claimed the right to the term and said it was...

Ethics. Technology. Peter Drucker states that there is no such thing as Business Ethics, there is only ethics.Collaborate with another classmate to write a reaction paragraph to this statement....

Ethics. Technology. Evaluate this statement using the Texas Instruments Ethics Quick Test and the Code of Conduct from Figure 3.5: It is better to steal from the stockholders of a company than the...