Write a SELECT statement that returns the title, artist and unit_price columns from the items table....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Write a SELECT statement that returns the title, artist and unit_price columns from the items table. Return only those items that have a unit_price of at least $16, but less than $17.50 - (3 marks) 2. Write a SELECT statement to return all columns from the customers table where the customer's state is Ohio (OH). Sort the results by last name in descending order. - (3 marks) 3. Write a SELECT statement to return all columns from the customers table whose zip code begins with a "9" - (4 marks) 4. Write a SELECT statement to return the order_id from the orders table where the number of days between the order_date and the shipped_date is less than 6 - (4marks) 5. Expand the statement in question 4 to include the number of days between order and ship date as a column alias called 'processing_days' and sort the results by that column in ascending order - (4 marks) 6. Write a SELECT statement to return the customer_first_name and customer_last_name with a space between as a column called "CustName" and customer_address, customer_city and customer_state sperated with spaces as a category called "Address" from the customers table where the customers_address includes 'Ave' -(3 Marks) Write a SELECT statement that returns the title, artist and unit_price columns from the items table. Return only those items that have a unit_price of at least $16, but less than $17.50 - (3 marks) 2. Write a SELECT statement to return all columns from the customers table where the customer's state is Ohio (OH). Sort the results by last name in descending order. - (3 marks) 3. Write a SELECT statement to return all columns from the customers table whose zip code begins with a "9" - (4 marks) 4. Write a SELECT statement to return the order_id from the orders table where the number of days between the order_date and the shipped_date is less than 6 - (4marks) 5. Expand the statement in question 4 to include the number of days between order and ship date as a column alias called 'processing_days' and sort the results by that column in ascending order - (4 marks) 6. Write a SELECT statement to return the customer_first_name and customer_last_name with a space between as a column called "CustName" and customer_address, customer_city and customer_state sperated with spaces as a category called "Address" from the customers table where the customers_address includes 'Ave' -(3 Marks)
Expert Answer:
Answer rating: 100% (QA)
Here are SQL SELECT statements for each of the tasks you mentioned 1 Return the title artist and uni... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these databases questions
-
4. (30 points) In lecture, we've mentioned how the lower and upper Darboux sums 'bound' possible Riemann sums. In this problem, let's make that statement more rigorous. (a) Let f : [a,b] R be a...
-
1. Determine the z-transform of each of the following signals using Z-transform and find its RoC. a. x[n]u[n+ 2]-u[n-5] b. x[n] = (-u[n-2] c. x[n] =(+ cos (+) u[n] d. x[n] 2"u[1-n] e. x[n] =...
-
a) Find the set of solutions of each of the linear congruence: i. 8x = 12 (mod 28). ii. 7x = 1 (mod 9). b) Hashing Function is used to assign a memory location for the records in the computer (For...
-
For rigid-body motion, the strains will vanish. Under these conditions, integrate the straindisplacement relations (7.6.1) to show that the most general form of a rigid-body motion displacement field...
-
Use the psychrometric chart to find the missing property of: Twet, Tdry. a. Tdry = 25C, =80% b. Tdry =15C,...
-
Dontae's employer has offered him the following employment package. Salary Health insurance Dental insurance Membership to Heflin Country Club Season tickets to Atlanta Braves games Tuition...
-
This exercise considers nursing home data provided by the Wisconsin Department of Health and Family Services (DHFS). Part 1: Use cost-report year 2000 data, and do the following analysis. a....
-
Branson Furniture Company has requested that you determine whether the companys ability to pay its current liabilities and long-term debts improved or deteriorated during 2012. To answer this...
-
You are saving up for your child's braces. You know you need $5,000 in 3 years when all his adult teeth have grown in. If your bank offers 4% interest, how much must you deposit today? Write a...
-
Go to the Webinars worksheet. DeShawn wants to determine the number of webinars the company can hold on Tuesdays and Thursdays to make the highest weekly profit without interfering with...
-
9. According to Government Auditing Standards (the Yellow Book), what is the correct term for the threat that an audit organization's position within a government combined with the structure of that...
-
How can a condition precedent become a condition subsequent? Draft an example.
-
What factors account for the different levels of self-employment among ethnic minorities?
-
How can you distinguish between a third party beneficiary and an incidental beneficiary?
-
Give two examples of implied-in-fact conditions.
-
Find and analyze your own states Statute of Frauds.
-
Choose the correct definition of heat Heat is amount of energy which transfer from one body to other because of difference of PE a b. Heat is amount of energy which transfer from one body to other...
-
The liquidliquid extractor in Figure 8.1 operates at 100F and a nominal pressure of 15 psia. For the feed and solvent flows shown, determine the number of equilibrium stages to extract 99.5% of the...
-
Clifford Johnson has a limited partnership investment and a rental condominium. Clifford actively manages the rental condominium. During 2012, his share of the loss from the limited partnership was...
-
Greg died on July 1, 2012, and left Lea, his wife, a $50,000 life insurance policy which she elects to receive at $5,000 per year plus interest for 10 years. In the current year, Lea receives $6,200....
-
In 2012, Gale and Cathy Alexander hosted an exchange student, Axel Muller, for 9 months. Axel was part of International Student Exchange Programs (a qualified organization). Axel attended tenth grade...
-
Based on the photographs in Figure 26.13, in which segment(s) is the Antp gene normally expressed? Figure 26.13: (a) Normal fly (b) Antennapedia mutant
-
The bush baby, a small African mammal, is a remarkable jumper. Although only about 8 inches long, it can jump, from a standing start, straight up to a height of over 7 feet! Use the particle model to...
-
Your friend Travis claims to have set the new world speed record for riding a unicycle. His top speed, he says, was 55 m/s. Do you believe him? Explain.
Study smarter with the SolutionInn App