Question: Write a query to display the below information about the customers who have credit greater than 2000? Customer FullName, Address, PhoneNumber, email, Credit Note: 1-

Write a query to display the below information about the customers who have credit greater than 2000?

Customer FullName, Address, PhoneNumber, email, Credit


Note:

1- For the Full Name should be = FirstName_LastName

2- For the Phone Number should convert the original phone number to 8 digits: i.e. +1 444 444 3737 ==> **** 3737

3- For the email Address should convert the email format as following example: user@domail.com ==> u___@domain.com


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!

Q:

please send pictures of the steps I'm stuck!! \begin{tabular}{|c|c|c|} \hline Step & Instructions & \begin{tabular}{l} Points \\ Possible \end{tabular} \\ \hline 1 & \begin{tabular}{l} Start Access....

Q:

You work as a database administrator at the Paterson Credit Union. You are modifying a database to add validation, lookup fields, and an input mask. You will also modify queries to take advantage of...

Q:

Exp 1 9 _ Access _ Ch 0 5 _ CapAssessment - Paterson Credit Union 1 . 2 Project Description: You work as a database administrator at the Paterson Credit Union. You are modifying a database to add...

Q:

Exp 1 9 _ Access _ Ch 0 5 _ CapAssessment - Paterson Credit Union 1 . 2 Project Description: You work as a database administrator at the Paterson Credit Union. You are modifying a database to add...

Q:

The structure and contents of the Ch07_LargeCo database are shown in Figure P7.27 . Use this database to answer the following problems. 27. Write a query to display the eight departments in the...

Q:

--******************************************* -- SECTION 1: Single-Table SQL Queries -- --******************************************* -- 1. Write a query to display customers last names, first names,...

Q:

Use OT database;- Database named OT which is based on a global fictitious company that sells computer hardware including storage, motherboard, RAM, video card, and CPU. The company maintains the...

Q:

-- SECTION 1: Single-Table SQL Queries --******************************************* -- 1. Write a query to display customers last names, first names, and email addresses. -- Sort your results by...

Q:

For ease of use, you would like for users to be able to indicate the minimum loan amount on which they would like to pull loan information. You will do this by adding a parameter criterion to the...

Q:

The questions I posted last time, answers were not according to the question in this assignment but were copied directly from some other assignment that had the same database but different questions....

Q:

Flexible Budget for Selling and Administrative Expenses for a Service Company Cloud Productivity Inc. uses flexible budgets that are based on the following data: Sales commissions 14% of sales...

Q:

Based on the following stock price data (in $) for Popeye's Fried Chicken Corporation, calculate variance and standard deviation for returns on Popeye's Fried Chicken . August 2019 was 25.10 ,...

Q:

for Harry Sand. Harry Sand owns and operates Harry's Barber Shop as a sole proprietor, at 73 E. Main Street, Your City, Your State - Your Zip. His EIN is 10-6321578. His state reporting number is...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

=+Understand the fi eld of comparative IHRM.

Q:

=+j Describe the institutional, economic, and cultural context for IHRM in different regions.

Q:

=+j Understand different types of regions in the world.