Question: Write a query to display the customer's name, customer address, and contact information of customers whose address has the 5 th letter ' o '

Write a query to display the customer's name, customer address, and contact information of customers whose address has the 5th letter 'o'. If the customer email is not available,then display the contact number. Give an alias name to the contact information as 'CONTACT'.
Sort the results based on the customer's name in descending order.

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:

Query #1: Display the customer company name, address, city, region, customer country, employee full name (last name, coma space first name LastName, FirstName) using an alias of FullName, order ID...

Q:

SQL: NORTHWIND Query #1: Display the customer company name, address, city, region, customer country, employee full name (last name, comma space first name LastName, FirstName) using an alias of...

Q:

Using SQL Developer execute the following queries with these statements. N eed help with the joining clauses in SQL. PLEASE help Write a query to display the title, publisher name, and author FROM...

Q:

This write it in JAVA programming language. Thank you! Build an application that represents a simple system that can be used by an online food delivery company to manage its customers information....

Q:

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...

Q:

Build an application that represents a simple system that can be used by an online food delivery company to manage its customers information. This application should provide a suitable user interface...

Q:

Build an application that represents a simple system that can be used by an online food delivery company to manage its customers information. This application should provide a suitable user interface...

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:

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 the Online Consumer Purchasing Model, Figure 6.11 in Chapter 6, to assess the effectiveness of an e-mail campaign at a small website devoted to the sales of apparel to the young adult market...

Q:

B Corporation has $1000 par value bonds with 9 years left to maturity, a stated annual coupon rate of 6.5 percent (with annual interest payments). What are these bonds worth today if the required...

Q:

Company spends 4 5 0 K on R&D cost to design a new part for its products. The design is patented in addition, legal and filing fees are 5 0 K the patent should be reported at .

Q:

An environmental response where a company cuts costs in response to declining sales is called?

Q:

2 How can companies like Shell ensure that managers and key personnel are adequately prepared for international assignments?

Q:

2 Is there a relationship between country of origin of the expatriate and success or failure in an assignment (e.g. are Dutch managers more successful expatriates than British or Japanese managers)?...

Q:

3 In view of the experiences of Shell outlined above, is there really a problem with expatriate failure? How can this best be safeguarded against? How might this differ between companies such as...