Question: 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
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)
Step by Step Solution
There are 3 Steps involved in it
Here are SQL SELECT statements for each of the tasks you mentioned 1 Return the title artist and uni... View full answer
Get step-by-step solutions from verified subject matter experts
