Question
6. You need to sell more of your high-end bikes. You want to take $500 off all bikes that have a list price of $5,000.00
6. You need to sell more of your high-end bikes. You want to take $500 off all bikes that have a list price of $5,000.00 or more. You need to have a list showing the bike name, list price and discount price with an alias of 'Discount Price'. Sort the list showing the most expensive bike first. The result set will look like this:
7. An important announcement was given to all the staff at your store (store_id 1). The same announcement needs to get to all the other staff at the other stores. You don't want to email all your staff again. You need a list of all the staff and their email who are not from your store.
8. A customer needs more information about a specific bike, but all they know is that is has the word 'spider' in the name. You need to list the name, model year, and list price of all the bikes with the word 'spider' somewhere in the name.
9. You need to list all bikes names that have a range of prices from $500 to $550 sorted with the lowest price first.
10. Show the customer's first_name, last_name, phone, street, city, state, zip_code who:
- have a phone number listed
- and whose city has the letters 'ach' or 'och' somewhere in their name of the city
- or whose last name is William.
Limit the result set to the first five results.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Sybase Database Administrators Handbook
Authors: Brian Hitchcock
1st Edition
0133574776, 978-0133574777
