Using join sort results alphabetically by customer name

Assignment Help Database Management System

Reference no: EM1362868

Develop SQL queries to retrieve the required information from the following tables.

Items (item_id, designation, price)

Items_ordered (customerid, order_date, item_id, quantity, billing_price)

Customers (customerid, firstname, lastname, city, state)

Note: Some customers get a discount, so the billing_price may differ from the standard price.

a. Select the lastname, firstname, and city of all customers who purchased an item for more that $1000. Display the results alphabetically by last name.

b. Select the firstname, city, and state for the customers who ordered a "tent," and who are living in either Arizona, Washington, Oklahoma, Colorado, or Hawaii.

c. Using Join, list the items each customer ordered where the billing_price was lower than the item price (item, billing_price, and price). Sort the results alphabetically by customer name.

Reference no: EM1362868

Questions Cloud

Show techniques in job hunting : Show prospect of searching for a job can be very intimidating and what techniques have you used in the past when you were job hunting?

Explain characteristics of an effective leader : Explain Characteristics of an effective leader and How has this leader influenced or put his/her mark within the industry (citations)IV.

Total dollar contribution margin dollars-percentage : An imaging center has the following information: Compute the total dollar contribution margin dollars and percentage.

Driving growth and sustainability of mobility industry : Nokia is a world leader in mobile communications, driving the growth and sustainability of the broader mobility industry. Nokia connects people to each other and the information that matters to them with easy-to-use and innovative products like mobil..

Using join sort results alphabetically by customer name : Using Join, list the items each customer ordered where the billing_price was lower than the item price (item, billing_price, and price). Sort the results alphabetically by customer name.

Physical growth and development during middle childhood : Describe normal physical growth and development during middle childhood, and account for the usual variations among children.

In which city hotel room is cheaper and by how much : Suppose the Japanese yen price of one British pound is 163.78 yen for each pound. In which city hotel room is cheaper and by how much.

Computing eva and comparing performance : Compute the Company's EVA for 20X4 and 20X5. Compare the company's performance in creating value for its shareholders in 20X5 with that in 20X4.

Chronic disease to become fatal : What can influence a chronic disease to become fatal? Give at least 3 examples.

User Account

All Pages